The CreatorCon Call for Content is officially open! Get started here.

ACL Question with isApprovalMine

Yusuf5
Tera Expert

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

find_real_file.png

13 REPLIES 13

Ankur Bawiskar
Tera Patron
Tera Patron

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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Thanks Ankur,

I also tried this before as follows but still the same problem.

This is not the first time I use ACL, I've used thousand times before but I am stuck 🙂 and no idea why ?

find_real_file.png

Harsh Vardhan
Giga Patron

 

 

Please refer the link below and see the example .

 

https://hi.service-now.com/kb_view.do?sysparm_article=KB0677278

dhananjay
Giga Contributor

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.