Technical rule not accepting SAVCUSTOMQUERY::ev.entitlement_value in ${user.customproperty1}

[sandeepsingh]

Hi Team,

We need to provision one or more entitlement as part of birthright based on values stored in CP1 of user.

Ex: If CP1 of user is ABC01,ABC02,ABC05

Then we need to provision entitlement ABC01,ABC02,ABC05. For this we are using below query in the technical rule. But this does not work. Your thoughts please.

SAVCUSTOMQUERY::ev.entitlement_value in ${user.customproperty1}

[DaanishJawed]

Hi @sandeepsingh ,

Please refer Scenario 4: Using Custom Query to Fetch Entitlement Values

Link - https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter05-Policies/Creating-Technic...

Thanks.

[sandeepsingh]

Hi @DaanishJawed ,

Yes we have refered the same and created the query. But still doesnot work.

[nimitdave]

@sandeepsingh , I have tried your use case as per below savcustomquery and it worked with creating tasks for the accounts and entitlements:

SAVCUSTOMQUERY::ev.entitlement_value in (${user.customproperty1})

User upload csv is like below:

firstname|lastname|departmentname|statuskey|owner|customproperty10|customproperty1
Chris|Doe|AUS|1|ndave|customquery|'CREATE TYPE','BACKUP LOG'

where cp1 has entitlement names to provisioned.

And below is the tech rule used: