Need help on database view

[chaudharymahesh]

Hi All, I am trying to create a database view on rm_defect and rm_story

I need the records/defects returned as a result from the defect table which are referenced in the defect field on the story

 I tried below, but i am getting the below Error Message

Where clause in view u_defect_rm_story has an invalid field or a field that is not visible (s_defect)

[chaudharymahesh · Accepted solution]

made changes to where clause and removed left join . it is working now.

[Voona Rohila]

Hi @chaudharymahesh 

Can you please check if the defect field from rm_story is returned, If there are no fields specified then all the fields will be returned.

Follow below link for steps : 

https://docs.servicenow.com/bundle/vancouver-application-development/page/use/reporting/concept/c_Sp...