How can I create a report view ACL to allow approvers to see the records they have approvals for

[Mark Endsley]

Normally this is no problem, I just created a script include to return a comma delineated list of sys_ids.

However, https://docs.servicenow.com/en-US/bundle/utah-now-intelligence/page/use/reporting/concept/report-vie...

Apparently you can't write scripted report_view ACLs.

So does that mean there is just no way for me to create a report for approvers to see the records they need to approve?

I know that we could write a report on the approval table, but that is not what we desire.

[Bert_c1]

Hi Mark

You seem to contradict yourself. You post "So does that mean there is just no way for me to create a report for approvers to see the records they need to approve?". and then post "I know that we could write a report on the approval table, but that is not what we desire."

A report on the 'sysapproval_approver' table with conditions:

"State", "is", "Requested" and

"Approver", "is (dynamic)", "Me"

Works.

[Mark Endsley]

Hey Bert,

You make a good point. Our users desire a large number of fields from the record, and would like to be taken to the record when they click it...

But I suppose I could just put the sysapproval field as the first column and that would work. 

...But we also would only want it to show one record, even if that user has multiple approvals on that record. Things start to get complicated. 

We would also like users to be able to create their own reports on records they are approving.

[Bert_c1 · Accepted solution]

Hello Mark,

A report as I suggested will work as you describe.  And for Reporting topics, please see:

https://docs.servicenow.com/search?q=Report

A review of ACLs on the sys_report table shows any user with the 'snc_internal' role can create reports. There are also a few related roles: report_admin, report_user, report_global.

You may also use Google and search for Servicenow reporting.

Other Community members may have suggestions. Good luck on achieving your requirements.