Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/20/2024 06:10 AM
Hi Team,
Below access query is not working in new EIC dev 24.3 as it was working fine in Prod 5.5sp5 version
where users.customproperty39 != 'sponsor' AND customproperty15 != 'callcentre' and users.userkey=${requestee.id} and (${requestor.id} = ${requestee.id} or ${requestor.id} = ${requestee.manager} or ${requestor.id} in (SELECT A.USERKEY FROM USER_SAVROLES A INNER JOIN SAVROLES B ON A.ROLEKEY=B.ROLEKEY WHERE B.ROLENAME IN ('ROLE_ADMIN','ROLE_L1','ROLE_L2','ROLE_xxxx.ARSxxxx')))
There is error calling out
Solved! Go to Solution.
05/20/2024 10:37 PM
Please check actual query printed in logs when you try to request for application from ARS
05/25/2024 08:37 AM
try @KG below
where users.customproperty39 != 'sponsor' AND users.customproperty15 != 'callcentre' and users.userkey in (${requestee.id}) and (${requestor.id} = ${requestee.id} or ${requestor.id} = ${requestee.manager} or ${requestor.id} in (SELECT A.USERKEY FROM USER_SAVROLES A INNER JOIN SAVROLES B ON A.ROLEKEY=B.ROLEKEY WHERE B.ROLENAME IN ('ROLE_ADMIN','ROLE_L1','ROLE_L2','ROLE_xxxx.ARSxxxx')))
05/27/2024 05:27 AM
where users.customproperty39 != 'sponsor' AND users.customproperty15 != 'callcentre' and users.userkey in ('${requestee.id}') and ('${requestor.id}' = '${requestee.id}' or '${requestor.id}' = '${requestee.manager}' or '${requestor.id}' in (SELECT A.USERKEY FROM USER_SAVROLES A INNER JOIN SAVROLES B ON A.ROLEKEY=B.ROLEKEY WHERE B.ROLENAME IN ('ROLE_ADMIN','ROLE_L1','ROLE_L2','ROLE_xxxx.ARSxxxx')))
Note - make sure to add the apostrophe for the requestor will work
05/27/2024 05:01 AM
its not working .