I want to run a report to find managers without a approver_user role

Johnny Miller2
Tera Contributor

I have created a report and cannot seem to get a complete list of managers but so far what I have done is run a report on user table with keyword mgr or manager in the system. This is insufficient as many managers in the system haven't had titles updated or are directors so forth, but if I can get the last part of the report completed I cant go back and make a better list.

 

I tried a related list condition of group approval>approval user and come up with a bunch of folks who have approver_user at least from the 20 or so I checked they all do. What I want to do is opposite though.

 

I want to find a list of people with a certain title who DO NOT have approver_user

2 REPLIES 2

shun6
Giga Sage

Hi @Johnny Miller2,

shun6_0-1745630415539.png

Thanks.

I couldn't figure out how to get these conditions on the right table but I finally did today. The sys_user_has_role table. Thank you Shun6!