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
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  ||  9x 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  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@Ankur Bawiskar I'm joining incident and metric_instance