Admin unable to view a database view

nowdev777
Tera Contributor

I have created a simple DB view configured as follows:

  • Table: Metric Data [sn_grc_metric_metric_data]
  • Where clause: None
  • Left join: False
  • View fields:
    • value

When I click "try it", it returns as follows. However when I go directly to the sn_grc_metric_metric_data.LIST, I can see all of the records. Does anyone know what is causing this and how to configure the access. Thank you.

 

Database View (not working)

nowdev777_0-1743166272149.png

 

.LIST going directly to the table

nowdev777_1-1743166470767.png

 

7 REPLIES 7

Hi @nowdev777 

Thanks for doing another test, and I agree with you, but I’m not convinced that the DB is only for one table (A database view defines table joins for reporting purposes).

As for the issue, I’m not sure if it’s a permission issue or a cache issue. If one table is working fine, why isn’t the other? Try using cache.do, or else log a case with Now Support.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Ankur Bawiskar
Tera Patron
Tera Patron

@nowdev777 

should not occur and looks a weird issue as you are able to see it when you do .LIST

Please raise a case with ServiceNow.

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

SandyBatcheller
Tera Expert

Hello,

 

I just discovered this same issue with a database view we setup a couple years ago that has been working fine until now.  Ended up removing columns in my list view until I just had one which was the Name field from the first table in my database view.  After that, the records showed up.

 

Not sure why it was causing the issue, but there was reference field in that same table that I had added along with some dot-walked fields from it to my list view and some reports.  Removing those fields and using the same data from another reference field made the list view and reports work.

 

There was nothing in the ACL that would have prevented seeing rows because of that field.  Also, after revising my list layout, I tried adding that field back in and it works now.

 

Strange things afoot but was glad I didn't have to rebuild the database view.  I may end up opening a case for this, guessing I will see this on other database views.

 

Hope this helps!

 

Sandy