Campaigns - Certifier - Select From Manual Query

[RV]

Does  Saviynt supports SQL queries in 'Select From Manual Query' on 'Select Certifier' Step ?

I am giving a SQL statement and keep getting an error (Invalid SQL syntax error) in the UI.  Here is the sample query :

u.username in (select username from users where username like 'certifiers%')

If I give something like it works, but I am looking for a SQL query to work so I dont need to list all the users.

u.username in ('certifiers_1', 'certifiers_2')

[rushikeshvartak]

u.username in (select c.username from com.saviynt.ecm.identitywarehouse.domain.Users c where c.username like 'certifiers')

[RV]

Thanks.  Can we use tables like certification, certification_user_status and certification_user as well.  I am getting error when using them with com.saviynt.ecm.identitywarehouse.domain.Certification

If so, Can you please provide their com.saviynt.* path for these tables as well?

[rushikeshvartak]

You can use . You need to give saviynt class name

[rushikeshvartak]

com.saviynt.ecm.campaign.domain.Certification
com.saviynt.ecm.campaign.domain.Certification_user
com.saviynt.ecm.campaign.domain.Certification_user_status

[RV]

It is not working.. I used this query and it complains "Invalid SQL syntax error"

u.username in (select cu.username in com.saviynt.ecm.campaign.domain.Certification_user cu)

[RV]

Please disregard the above comment

[RV]

I was using below query and see an Invalid SQL syntax error

u.username in (select cu.username from com.saviynt.ecm.campaign.domain.Campaign cm inner join com.saviynt.ecm.campaign.domain.Certification c on cm.id=c.campaignkey inner join com.saviynt.ecm.campaign.domain.certification_user_status cus on c.certkey=cus.certkey inner join com.saviynt.ecm.identitywarehouse.domain.Users us on c.certifier=us.userkey inner join com.saviynt.ecm.campaign.domain.certification_user cu on cus.cert_userkey=cu.cert_userkey where cus.certified is null and cm.campaign_name='Testing')

[rushikeshvartak]

Unfortunately  com.saviynt.ecm.campaign.domain.* is not exposed.

u.userkey in (select cu.cert_userkey from com.saviynt.ecm.campaign.domain.certification_user cu)

Raise idea ticket if you need 
 

[sk]

I don't think other tables are exposed except users

[RV]

Will open a idea request