Campaign consult/reassign list shows limited users not all active users

[sakshibansal]

Hello,

We have NOT configured the Consult/Reassign User Query in Campaign Advanced configurations. But for most users, when they select Does not work for me, they could see a limited set of users in consult/reassign list and not all active users.

I am not sure why this is happening? Could there be any other configuration which caused this?

[Enakshi · Accepted solution]

Could you configure below Consult User Query and check if all active users are coming?

select u from Users u where 1=1

[rushikeshvartak]

Please share template configuration & Does SAV Role assigned to user is different ?

[sakshibansal]

The query provided works in Dev. I believe it should work in PROD as well.

Thanks!