Database View shows count but doesn't show records

[Community Alums]

Hi, this issue is not really any release specific or module specific

as i have seen this issue on different releases and different modules so it's platform wide

whenever i create a database view (join 2 tables) , I see a count of all the results in the list view of the catabase view, but i dont see the records themselves. 

Please can anyone help me figure out whats the problem with data base views? what am I doing wrong? as it's really hindering my progress in acheiving a report of all the Cis that were last discovered(inserted/updated) by Qualys scan and have related VIs. I need to join the 2 tables (cmdb_ci & Vulnerable items) together 

please see attached images

Thanks & Kind Regards

[Kieran Anson]

Database view configuration aside, when you load the database view as shown in your screenshot, can you interact with the form? i.e can you click the funnel icon to build a query? Reason I ask is that I've had a few issues where no records are displayed and it's actually the form/browser failing to render the list layout and erroring. This is notable as nothing on the page is clickable.

Also, do you need information from the vulnerable items table, or just the CI table? If you don't need the info and just want to know if a CI is being referenced, you can use a related list query rather than a database view.

[Rufino]

I'm having the same problem here! 😞

The report makes the count, but don't show the data.

When I try to build a query, the count goes to zero. This happens with any simple query.

[Ayyappa]

I am also facing the same , do you find solution for this?

[Rufino]

unfortunately not 😞