The Complex Filters Support for The SCIM 2.0 API

[ravinduramesh]

Is your suggestion related to an experience ? Please describe. Currently the complex filters (queries with AND, OR, NOT operators) are not supported in filter parameters for SCIM 2.0 API requests. These complex queries are very useful to perform many data retrieval tasks (ex-: to retrieve roles management roles in application domain, we need to perform a filter: 'displayName+sw+Application/+and+displayName+ew+manager').

Currently it gives the following response:

{
    "schemas": [
        "urn:ietf:params:scim:api:messages:2.0:Error"
    ],
    "detail": "Complex filters are not supported yet",
    "status": "501"
}

Describe the improvement Facilitate complex filters with AND, OR, NOT operators in SCIM 2.0 API.

[AnuradhaSK]

AND operation is supported https://github.com/wso2-extensions/identity-inbound-provisioning-scim2/blob/5d8e8482396ba084faebee30657f030511e47b2f/components/org.wso2.carbon.identity.scim2.common/src/main/java/org/wso2/carbon/identity/scim2/common/impl/SCIMUserManager.java#L2119

Logical operators OR and NOT are the not supported filters yet

[manuranga]

We came across this requirement when we wanted to show a list of users in a SPA (medical aid project). We have a list of ID we keep in the data base associated with each resource. We want to get a list of display names. Our query will look like Users?filter=id eq 23 or id eq 34 or id eq 24.

(I think an alternative way is to model the resource in IS as well then this will be filtering by permission, but this is not available yet)

[zim333]

Is there any work in progress about "or " and "not" operators ? It would be very useful in our environment. Thanks !