Certifier - Select from Manual Query

[GSR]

Hello,

My requirement is to launch certification for user accounts for specific application.

Certifier has to be dynamic based on country.

If user is from Country A then Assign to "ABC' As certifier

If user is from Country B then Assign "BCD' As certifier

Please guide me how to achive this.

Thank you.

[rushikeshvartak]

Sample query -  u.id in (select manager from Users where id=:loggedInUser)

Based on this prepare query for your requirement

[GSR]

tried below did not work : Invalid SQL syntax error

u.username IN (SELECT DISTINCT
case when (u1.country = 'ABC') then '12345'
when (u1.country = 'DEF') then '5678'
else '9876'
end as 'ID'

from
Users u1

WHERE
u1.statuskey=1
u1.id =:loggedInUser)

[rushikeshvartak]

Keep in same line 

u.username IN (SELECT DISTINCT CASE WHEN u1.country = 'ABC' THEN '12345' WHEN u1.country = 'DEF' THEN '5678' ELSE '9876' END FROM Users u1 WHERE u1.statuskey = 1 AND u1.id = :loggedInUser)

[GSR]

Query worked but campaign moved to launching state and stuck there. I have picked only one endpoint with 5 users

[rushikeshvartak]

Check logs for error. It won't work ideally at only 1 Primary certifier is allowed