This topic has 4 replies, 2 voices, and was last updated 6 years, 5 months ago by Morten Lømo.

  • Author
    Posts
  • #9986
     Morten Lømo
    Participant

    I’m in the Managed objects UI in the Admin UI. One of my attributes is “End date”. It’s a string with syntax yyyy-mm-dd. Is it possible to search for all entries with End date after a certain date? (I have tried using the “>”-sign (e.g. “>2016-10-01”), but it doesn’t work).

    Morten

    #9994
     tim.sedlack
    Participant

    Hi Morten –
    First, what version of OpenIDM are we talking about here?

    Second – there’s a great section in the docs on querying that you should review: https://backstage.forgerock.com/#!/docs/openidm/4/integrators-guide/chap-data#query-comp-express-gthan

    This points specifically to the “greater than” example, but that should put you in the right area :-)

    Hope that helps,
    Tim

    #10010
     Morten Lømo
    Participant

    Thanks, but I´m interested in searching in the Admin UI, not with REST call. In the Admin UI I select the MANAGE menu, then USER. Here I see all my users. One of the columns in the UI (searchable property) is End Date. It is a string with syntax yyyy-mm-dd. Is there a way to filter on all users with End Date later than e.g. 2016-10-01?

    Thanks
    Morten

    #10012
     tim.sedlack
    Participant

    There is no “End date” in the default implementation of the Admin UI. That must have been something you added at some point. The logic on how to do it is in the section I pointed out… if you extended the UI (or the user schema either directly or through manipulating a relationship), you will have to add that logic as well.

    Tim

    #10164
     Morten Lømo
    Participant

    Thanks. Let me take another example. If we take samples/workflow. After having reconciled the users, I have two users listed in the Admin-UI->MANAGE->USER UI: manager1 and user1. The columns that are shown are: USER NAME, FIRST NAME, LAST NAME, EMAIL ADDRESS and STATUS. Above each column there is a filter. Now I use the filter above LAST NAME. If I filter on “Manager”, only manager1 is listed because manager1 is the only user that has LAST NAME = Manager. If I filter on “%ploy”, only user1 is listed, because it is the only user that has LAST NAME that contains “ploy”. Now to my question. Is it possible to filter on bigger than? E.g. give me all users with LAST NAME bigger than “F”. It should give me only manager1, because it is the only user with LAST NAME bigger than “F” How would the filter syntax be? I have tried with “>F”, but that does not work.

    Thanks for help.

    Morten

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.

©2022 ForgeRock - we provide an identity and access platform to secure every online relationship for the enterprise market, educational sector and even entire countries. Click to view our privacy policy and terms of use.

Log in with your credentials

Forgot your details?