queryFilter for retreiving user using a nested attribute as the filter

This topic has 1 reply, 2 voices, and was last updated 3 years, 7 months ago by cbontemps.

  • Author
  • #23184


    I’m trying to use the rest api to return managed users who have a certain relationship property(_refProperties).

    For example below is an extract of the JSON for a user. Is it possible to write a query filter to return users who have the “customProperty” (inside_ refProperties) with value “test”?

        "result": [
                "_id": "1234",
                "userName": "user1",
                "address": {
                    "_ref": "managed/address/f7145ae2-d77b-4dcd-980f-67ddb8cddfbc",
                    "_refResourceCollection": "managed/address",
                    "_refResourceId": "f7145ae2-d77b-4dcd-980f-67ddb8cddfbc",
                    "_refProperties": {
    	            "customProperty": "test"
                        "_id": "8498f37c-61ba-48d6-918b-bb1fc9d342ea",
                        "_rev": "0000000089eea504"

    I tried writing the query like the below, but not too sure on the syntax.

    http://openidm.example.com/openidm/managed/user?_queryFilter=roles/_refProperties/customProperty eq "value1"&_fields=userName

    Any ideas how i would go about writing this query? I’m using opendj as my user store.


    • This topic was modified 3 years, 9 months ago by jm89.
    • This topic was modified 3 years, 9 months ago by jm89.

    Hi jm89
    I am also interested by the answer. Did you get any lead on the question ?

Viewing 2 posts - 1 through 2 (of 2 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?