I want to run a report to find managers without a approver_user role
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-24-2025 11:19 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-25-2025 06:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-29-2025 06:01 AM
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!