Query for Config for Requestable Entitlement in ARS page for Entitlements

[Rajesh_IAM]

Hi Team,

We are onboarding new DB based application into Saviynt. It has 13 filters as below.

Actually here entitlement name is concatenation of selected values from these dynamic attributes.
Ex: IP&ID_Coach, IP&ID_Coach_HUB,IP&ID_Coach_HUB_NAM and so on.
Here first two filters are mandatory, Application and Role. Rest of the filters are optional. End users may select or not based on their requirement.

Note: All these entitlements are imported to Saviynt from DB through entitlement import job,

Now please help me how to write query to display respective(only single) matched entitlement name in ARS. I need help on how to write query for Config for Requestable Entitlement in ARS to get respective/correct entitlement name dynamically  in ARS based on selected values from dynamic filters.

[SumathiSomala]

@Rajesh_IAM try simliar to this

ev.entitlement_value like '%${Dynamic Attribute Name}%',
Example: ev.entitlement_value like '%${DACode}%'

ev.custompropertyxx like '%${Dynamic Attribute Name}%'

[Rajesh_IAM]

@SumathiSomala  Thank you for response.
Here few dynamic filters are optional (means user may select or not).  If user selects all the dynamic filters then entitlement name is concatenation of 11 values. If user select only few required filters then entitlement name is concatenation of those selected values. Now How could I write to met this optional filter condition.

[Rajesh_IAM]

For example, I tried below query with first two filleters, but even its not accepting query.

Config for Requestable Entitlement in ARS page query:
ev.entitlement_vaue in (SELECT distinct Role_Name FROM OPEX_Input.SVNT.vCustomOrganizationUnits where ev.customproperty2 = '${Application}' and ev.customproperty24 = '${Role}') Where Application and Role are the dynamic attribute names.

Please review this and help me on this query.

[pmahalle]

Hi @Rajesh_IAM ,

In "Config for Requestable Entitlement" you can only filter entitlements based on eneitltment_values table's attribute along with dynamic attributes.

[Rajesh_IAM]

@pmahalle  Thank you for response.
Could you please help me with sample query like how can we concat the dynamic filters values for entitlement_values table to get entitlement name based on selected values from dynamic filters.

[rushikeshvartak]

Create one more multiselect dynamic attribute which will do concat logic and show only that multiselect dynamic entitlement to end users.

[Rajesh_IAM]

@rushikeshvartak  Thank you for response.
But we have already imported all the entitlements from DB to Saviynt. App team requirement is while enduser raising a request through ARS page based on the dynamic filter selection respective entitlement name should be display in Available Entitlements section in ARS Page.

In case If we create one more multiselect dynamic attribute then Available Entitlements section in ARS Page will be empty and please guide me how can we  trigger Add access task along with new account task when end user submit request for Access.?

[rushikeshvartak]

There are limitation on "Requestable Entitlement in ARS page for Entitlements" size and table exposed hence you won't be able to achieve with "Requestable Entitlement in ARS page for Entitlements"

[Rajesh_IAM]

@rushikeshvartak  Thank you for the update.

Please provide any sample syntax like how can we concat all the selected dynamic filter values and display that concatenated value in another multiselect dynamic filter.
Ex: Application, Role, DataEntery, BU, PG and country are the dynamic attributes name. How Can we implement concat operation for these selected dynamic filter values and display that concatenated value in another multiselect dynamic filter.

[Rajesh_IAM]

@rushikeshvartak 
Could you please provide any sample syntax like how can we concat all the selected dynamic filter values and display that concatenated value in another multiselect dynamic filter.
Ex: Application, Role, DataEntery, BU, PG and country are the dynamic attributes name. How Can we implement concat operation for these selected dynamic filter values and display that concatenated value in another multiselect dynamic filter.?

Also How can we pass this entitlement value (concatenated value in dynamic filter) to entitlement attribute in add Access JSON.?

[Rajesh_IAM]

Hi All,

Please help me to resolve this issue as still facing issue with entitlement display query.