Before Query Business Rules

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2023 03:51 PM
Hi,
User getting "Number of rows removed from this list by Security constraints" on their list view. I need to remove this message using BR. I have ACL that restricted groups from accessing each other's tickets which causing this message to show.
its a custom table
thanks,
S
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2023 04:04 PM
hi,
I believe you'll need to update script logic in a 'read' ACL. I doubt any BR logic can defeat ACL security.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2023 04:43 PM
Hi @sparkles , If you mean to replace the row level ACL with Before query Business rule you can do that. You can look at OOB 'incident query' BR to take reference and create yours.
Regards,
Badal Khojare
Community Rising Star 2023
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2023 05:13 PM
@sparkles query business rule will remove that message. So delete the read acl and write the same logic in query business rule.
Like below
current.addQuery("QUERY HERE");
ServiceNow Community Rising Star, Class of 2023