and more in a single search tool across platforms. Read the announcement here. |
01/18/2023 07:44 PM
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')
01/18/2023 08:10 PM
u.username in (select c.username from com.saviynt.ecm.identitywarehouse.domain.Users c where c.username like 'certifiers')
01/19/2023 04:49 AM
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?
01/19/2023 05:41 AM
You can use . You need to give saviynt class name
01/19/2023 06:00 AM
com.saviynt.ecm.campaign.domain.Certification
com.saviynt.ecm.campaign.domain.Certification_user
com.saviynt.ecm.campaign.domain.Certification_user_status
01/19/2023 09:50 AM
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)
01/19/2023 09:50 AM
Please disregard the above comment
01/19/2023 09:54 AM
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')
01/19/2023 11:12 AM
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
01/19/2023 11:14 AM
I don't think other tables are exposed except users
01/19/2023 07:28 PM
Will open a idea request