Help Creating a Database view

Alex319 · ‎01-29-2024

Hi All,
I'm trying to create a database view to link a custom cmdb table and the case table.
When I add the cmdb table to the database view and click on 'try me' the table shows no records.
The purpose of this database view is to create a report which can look at an asset and see if there are any cases related to that asset.

Any help would be greatly appreciated

Thanks

Alex

Siddhesh Wani1 · ‎01-29-2024

Hi Alex

The where clause doesn't support the dot walking. You have to think about the correct condition

Something unique on the both table and write the query like below

here com is company and checking the user's company and give the correct data.

Both field should are referring to the same sys_id.

View solution in original post

Alex319 · ‎01-29-2024

It's not that I want to see specific assets. I was just expecting more than 7 records to show up. I thought there would be a record for each case that had been created.

Thanks

Alex

Siddhesh Wani1 · ‎01-29-2024

Then you have to play with the conditions, you will get one condition that will work.

Alex319 · ‎01-30-2024

Hi,

Do you mean the Where clause conditions?
Thanks
Alex

Siddhesh Wani1 · ‎01-30-2024

Yes, You have to check which where clause condition is perfect for the result or otherwise go with my solution of link all the three tables and for the asset table you can add other asset sys_id using or condition
as_sys_id = '005b1c08471e3d94fa51e929736d439f' || as_sys_id = '***************' || .............