Consult Query not showing all the Managers

[Isha]

Hi, 

We are using the following query for Consult to list all the Managers.

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

But the Consult list is not showing all the managers. A few managers are not present in the consult list.

Also, what does this Note at to of consult list page mean?

Note: Consult action will not be applied on the item if it belongs to the user selected for consulting

[NM]

@Isha are those managers inactive in saviynt?

[Isha]

No, they are Active but still not showing in the Consult list.

[rushikeshvartak]

How many users are not visible ?

[Isha]

Atleast 10+. In the logs  we can see the query as:

select new Map(u.username as username, u.id as id, u.firstname as firstname, u.lastname as lastname, u.systemUserName as systemUserName, u.email as email) from Users u where 1=1 and u.id in (select distinct m.manager from Users m where m.username='Test_user_****') and u.statuskey = 1 and u.id not in (:notInList)"

What does notInList mean?

[rushikeshvartak]

Does manager is campaign owner ?

[Isha]

Yes , manager is campaign owner 

[NM · Accepted solution]

@Isha if they are assigned with certification they won't appear in the list.

[rushikeshvartak · Accepted solution]

• Campaign owner does not appear in consult This is product standard behavior
• ✅Please click the 'Accept As Solution' button on the reply (or replies) that best answers your original question and hit 'Kudos' button 👍.

[Isha]

Okay, thanks !