Interactive filter on Sys_user
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2025 12:26 PM
I have a dashboard that I created with a bunch of interactive filters for our Agile tickets as it was easier than customizing the out of box agile board. One of the filters is for Assigned to is not working for anyone without admin permissions.
I've tried two things, one is giving the scrum_user role read access to the user table via an ACL.
The other is updating the user query business rule with the following:
gs.getSession().isInteractive() && !(gs.hasRole("admin") || gs.hasRole("user_admin") || gs.hasRole("scrum_user"))
Neither seems to work.
I feel like I'm missing something simple. Suggestions?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2025 12:46 PM
I'd recommend using the Debug Security module to check why the filter is failing. It will tell you exactly which ACL the user is not passing. Also I recommend logging out and back in after applying the changes to ACLs; sometimes caching is the issue!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2025 01:57 PM
I'll give the debug security mode a try. I had already logged out and cleared caches.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-03-2025 02:12 PM
I've tried the fixes listed
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0824673
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0752435
Debug security mode wasn't showing much, but I'll give it a try again.
