Database View is not showing results

ServiceNowSteve · ‎12-13-2017

Good Afternoon All,

I am attempting to dive into Database Views and I have created a simple view based off of a video I watched (below)

After joining my incident table and my company table I added a WHERE clause to the incident table that attempts to pull records where the "company" field on my incident table matches the "name" field on the company table.

After I "Try It" I get nothing in return, any idea why? I do know that there are records on our Incident table that match these names.

My Reference Video...picks up around 9:55

&lt;/p&gt;

Tim Deniston · ‎12-13-2017

Try using all underscores: inc_company = comp_sys_id

View solution in original post

Tim Deniston · ‎12-13-2017

The Company field on Incident stores a sys_id, so you want to compare it to the sys_id field on the Company table.

ServiceNowSteve · ‎12-13-2017

How would I do that? After your reply I tried

inc.sys_id = comp.sys_id and inc.company = comp.sys_id and got nothing.

ServiceNowSteve · ‎12-13-2017

Hmm wait a sec...I applied Left join just for fun and it seemed to bring up results...

ServiceNowSteve · ‎12-13-2017

So despite it working with a left join it seems to not pull data from the company field now. The fields show but no data