Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/17/2024 03:15 AM
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
Solved! Go to Solution.
09/17/2024 03:17 AM
@Isha are those managers inactive in saviynt?
09/17/2024 03:26 AM
No, they are Active but still not showing in the Consult list.
09/17/2024 06:00 AM
How many users are not visible ?
09/17/2024 06:35 AM
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?
09/17/2024 10:38 AM
Does manager is campaign owner ?
09/18/2024 01:00 AM
Yes , manager is campaign owner
09/18/2024 01:25 AM
@Isha if they are assigned with certification they won't appear in the list.
09/18/2024 04:58 AM - edited 09/18/2024 04:58 AM
09/18/2024 02:06 AM
Okay, thanks !