Consult Campaign Query not working

[Isha]

Hi , 

We are triggering campaign from user update rule and are using the below query for consult to show only manager in consult list:

select u from Users u where 1=1 and u.id in (select manager from Users where id=:loggedInUser)

The query was working fine before, but is not working now. It is behaving weird , works sometimes , doesn't work at other times. The manage is active.

[rushikeshvartak]

select u from Users u where 1=1 and u.id in (select m.manager from Users m where m.id=:loggedInUser)

[Isha]

Hi Rushikesh,

The consult query works when campaign is triggered manually but when campaign is triggered by user update rule , the list for consult comes as empty.

[rushikeshvartak]

Can you check logs for error. also download config of launched campaign to check query

[Isha]

Hi Rushikesh,

There is no error in the logs, the logs is showing the proper consult query. The same query is working in UAT environment but not working in dev. We compared the logs from both the regions and there is no difference.

The query is present in the launched campaign summary.

[Isha]

This is the one which is showing empty list in consult. In UAT also, it is the same but in UAT we are able to see the logged in user's manager.

[rushikeshvartak]

Does both saviynt instance version and sub version same ?