ACL Question with isApprovalMine
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-05-2018 02:56 AM
Hi,
I'am expecting every user just to lists their approval.
Therefore, I added an ACL for sysapproval_approver table as follows.
But unfortunately, it deosn't execute, the user sees other approvals as well.
I am not sure if I am missing something, any help is appreciated.
Regards
Yusuf
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-05-2018 03:08 AM
Hi Yusuf,
Why not achieve this using query business rule because if there is no approval for particular user and that user visits the approval table they would get message i.e. Number of rows removed because of security contraint.
Query BR:
current.addQuery('approver',gs.getUserID());
if you want to achieve this using ACL don't use script section use condition and add Approver is dynamic me
Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
Thanks
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-05-2018 03:14 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-05-2018 03:10 AM
Please refer the link below and see the example .
https://hi.service-now.com/kb_view.do?sysparm_article=KB0677278
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-05-2018 03:10 AM
hi , why are yo trying acl if do it using acl you have to write the Before Query BR to Remove the Message "no of rows removed due to security constraint" . Instead of writing the ACL just write the before Query BR to show every user only their approval.