Help Creating a Database view

[Alex319]

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]

Hi Alex, 

Please check the where clause you written the ppa it must be pp

Kindly consider marking the provided answer as correct if it proves helpful.
Thank you and best regards,

Siddhesh

[Alex319]

Hi Siddhesh, 
I have made that change, must have been a typo, but unfortunately I'm still not seeing any records. 

[AndersBGS]

Hi @Alex319 ,

Your "where clause" is writting wrongly. You have written "ca_asset_sys_id.ppa_asset_sys_id", but it think it should have been "ca_asset_sys_id = pp_asset_sys_id". Please also remember of one of the tables should be a left join or not.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders  

[Alex319]

Hi Anders, yeah sorry Siddhesh pointed out that typo too. unfortunately after updating I still have the same issue. 

Thanks

Alex