How to use –sortOrder with Json Attribute on LDAP

[0b91dc2a-752f-477c-9ba3-d603940fe02d]

I have a set of Entries in LDAP, each entry has an attribute is Json format as sample bellow:

user-custom-attrs:{"category":"creation","createdOn":"2021-10-25T10:38:58.198Z","updatedOn":"2021-10-25T10:38:58.198Z","createdBy":"1","updatedBy":"1"}

My question is how to use ldapsearch with --sortOder to sort with user-custom-atts's attribute?.

I already try with ldapsearch --baseDn ou=people,ou=sampel01,ou=identities --bindPassword password --sortOrder "user-custom-attrs:caseIgnoreJsonQueryMatch:=/category" --simplePageSize 10 --countEntries "(uid=*leonidas*)" but DS server said that “Unable to process the provided server-side sort request control because it references undefined ordering matching rule caseIgnoreJsonQueryMatch:=/category”

• This topic was modified 1 month, 3 weeks ago by 0b91dc2a-752f-477c-9ba3-d603940fe02d.
• This topic was modified 1 month, 3 weeks ago by 0b91dc2a-752f-477c-9ba3-d603940fe02d.

[0b91dc2a-752f-477c-9ba3-d603940fe02d]

@ludo hope you can help me, ty sir

[Ludo]

Hi,

To be able to sort, you need an ordering matching rule. caseIgnoreJsonQueryMatch is a equality rule.

There is an example of the use of a Json ordering rule in our documentation:
https://backstage.forgerock.com/docs/ds/7.1/ldap-guide/search-ldap.html#server-side-sort

--sortOrder +jsonToken:extensibleJsonOrderingMatch:true:true:/category is like to achieve what you need.

[Author]

Posts