Interested in a ServiceNow event built for developers? Registration for now[dev]26 is officially open!

Report on Database view

GBS
Tera Contributor

I have created a database view that combines an incident table and a metrics definition table, and I have created a report on the database view. User was able to access the data from the list view but was unable to view the data on  report. Getting the attached error.

GBS_0-1737447507118.png

 

19 REPLIES 19

Ankur Bawiskar
Tera Patron

@GBS 

are you sure user has report_view Access on metric table?

Definitely an ACL issue

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

Hi @Ankur Bawiskar given report_view to user and tested, even though user was unable to view 

@GBS 

you are joining which tables in your database view?

for all those tables you should give report_view ACL

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

@Ankur Bawiskar I'm joining incident and metric_instance