Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/20/2024 11:52 PM - last edited on 05/21/2024 12:24 AM by Sunil
Hi guys, i'm testing for using SAVCUSTOMQUERY as below but seems not working. is there any problem on my query?
Target Enterprise Role Name : BR_LOC_Coupang, Corp._KR_OF
SAVCUSTOMQUERY::r.role_name='CONCAT('BR_LOC_',u.companyname,u.customproperty10,'_OF') from users u where u.username=${user.username}'
[This message has been edited by moderator to disable hyperlink]
Solved! Go to Solution.
05/21/2024 01:09 AM
Hi @moosam2 ,
Seeing your query u.username=${user.username}, as technical rule execution happens per user, you can ignore the above config.
Can you directly put the below and check:
BR_LOC_${user.customproperty1}${user.customproperty10}_OF
If this helps your question, please consider selecting Accept As Solution and hit Kudos
05/21/2024 01:44 AM
Hi PremMahadikar, Yes we already use your case but i tested other way to usingSAVCUSTOMQUERY. Thank you for your help!
06/19/2024 03:16 AM
Hi @moosam2
Did you get this to work, I am also trying to use SAVCUSTOMQUERY to assign enterprise roles but dont know if this is supported or not
06/19/2024 03:33 AM
Nevermind, I got it working. Below is the syntax:
SAVCUSTOMQUERY::r.customproperty1 = '${u.customproperty33}'
Here we are matching the roles cp1 with users cp33 and if they match user will be assigned with the enterprise role.
05/21/2024 02:06 AM
@moosam2 ,
There is no documentation on dynamically picking role using SAVCUSTOMQUERY
Refer article: Solved: User Update Rule Action: Deprovision Role Options - Saviynt Forums - 2795
But as you are testing, can you try the below:
SAVCUSTOMQUERY::ev.entitlement_value like 'BR_LOC_${user.customproperty1}${user.customproperty10}_OF'
SAVCUSTOMQUERY::ev.entitlement_value like '${user.customproperty1}${user.customproperty10}'
If this doesn't work, then as I and you mentioned above, using directly without SAVCUSTOMQUERY is the only way.
Please hit Kudos and select Accept As Solution for the reply (or replies) which helped your original question.