Database view obstacle

[kalakaramad_20]

"Hi, I need help with a report in ServiceNow. I have a Standard Laptop field (true/false) in the product model table. When this field is true, I want the report to display all assets related to those models. However, the condition isn't working as expected. Any suggestions?"

This assets from product model must be seen in the Reports, if the field is marked true.

Also have created database view for both tables but not able to figure out the whereclause.

[Ankur Bawiskar]

@kalakaramad_20 

database view helps in joining 2 tables based on common field

what's your business requirement?

[Abhishek Varma]

First add relevant fields from these tables to this database view, then figure out the common values between these two tables and then use the below logic.

chpm.field=ad.field

this should be in the product model table.