Regarding Access query of prod5.5 sp5 is not working in EIC dev 24.3

[KG]

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 

[rushikeshvartak]

Please check actual query printed in logs when you try to request for application from ARS

[Raghu · Accepted solution]

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')))

[KG · Accepted solution]

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 

[KG]

its not working .