We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Consult/Reassign User Query for Service Account Campaign

mgandr
New Contributor III
New Contributor III

Hi,

I'm attempting to retrieve a list of users with Primary and Secondary Certifier Rank using the query below. However, I'm encountering an Invalid SQL syntax error. Does anyone here know the correct query for these requirements? Thanks!

select u from Users u where 1=1 and u.id in (select distinct ao.ownerkey from accountowners ao where ao.rank=26 OR ao.rank=27)

 

1 REPLY 1

rushikeshvartak
All-Star
All-Star

Only user table is exposed accountowners table is not exposed.

rushikeshvartak_0-1706154530091.png

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.