This topic has 3 replies, 3 voices, and was last updated 5 years, 11 months ago by ssripathy.

  • Author
    Posts
  • #13441
     spauwels
    Participant

    Hi,

    i’ve got an Object with an array of strings, like this : image here
    I need to query this object through the REST API, searching the objects containing an element in this arrays, but the requests Object?_queryFilter=attribut+eq+”{var}” or Object?_queryFilter=attribut+co+”{var}” don’t seem to work for this.

    Could you please help me ?
    Thanks,
    Seb

    • This topic was modified 5 years, 12 months ago by spauwels.
    • This topic was modified 5 years, 12 months ago by spauwels.
    • This topic was modified 5 years, 12 months ago by spauwels.
    • This topic was modified 5 years, 12 months ago by spauwels.
    #13446
     laurent.bristiel
    Participant

    Hi,
    this is currently not possible in OpenIDM with query filters.
    A request for improvement was raised in Jira in OPENIDM-3155
    Laurent

    #13448
     spauwels
    Participant

    Hi,
    thanks for your response. However, if you can’t query a long string like CSV and can’t query an array…
    Well, we’ll find a solution ;)

    #13619
     ssripathy
    Participant

    If the database repo you use supports SQL queries on JSON objects, you could create a preset query and invoke the query via REST with a param that’s not an array. Even if JSON querying is not available with SQL, you could at the very least do string searches and then passs the search param. Not pretty, but may get the job done

    example REST:
    GET https://localhost:8443/openidm/endpoint/echo?queryId=query-my-data&_para=foo

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