Database View-Where Clause Not working

[chaitanyaya]

Team,

I am creating database view for two tables. cmdb_ci_hardware & Problem records with left join. 

It should show for how many CIs problem was raised plus rest of CIs (with no any problem ticket raise)

But its not showing any records.

[Yashsvi]

Hi @chaitanyaya,

please check below link:

https://www.servicenow.com/community/developer-forum/where-clause-on-database-view-not-working/m-p/1...

Thank you, please make helpful if you accept the solution.

[Mark Manders · Accepted solution]

Shouldn't it be 'hwd_sys_id=prb_cmdb_ci'? You are checking if the sys_id of the CI is the same as the sys_id of the problem. That will never be the case.

[chaitanyaya]

Hi @Mark Manders 

Thanks. Its working & showing records from hardware table for which problem is raised.  

But left join not working. (Like its not showing all recrods)

[Community Alums]

Hi @chaitanyaya ,

SysId of problem table and hardware table is never be the same , you should take some other variable instead sys_id like I did with assigned_to 

Hardware_assigned_to= Problem_assigned_to

Result 

Please mark my answer correct and helpful if this works for you

Thanks and Regards 

Sarthak