Consult/Reassign User Query for Service Account Campaign

[mgandr]

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)

[rushikeshvartak · Accepted solution]

Only user table is exposed accountowners table is not exposed.