Tagged: Searching filter Admin-UI
April 21, 2016 at 12:37 pm #9986
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).
MortenApril 21, 2016 at 5:14 pm #9994tim.sedlackParticipant
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,
TimApril 23, 2016 at 9:03 am #10010
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?
MortenApril 24, 2016 at 12:46 am #10012tim.sedlackParticipant
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.
TimApril 29, 2016 at 8:13 pm #10164
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.
You must be logged in to reply to this topic.