database view question

[drslry2]

Hi gurus,

I'm attempting to create my first database view and between a custom table that looks like this...

and the 'Business Application' class...using the following left join...

...however it returns no records.

Any idea what to join on in this case?

thanks in advance.

Rob

[drslry2]

It's really just between two table, one of them is defined as follows...

and the other table is the Business Application Class

...and this is how I currently have the join define (incorrectly)....

[AndersBGS]

Hi @drslry2 ,

The configuration item column on the business application table - is that custom? As far as to my knowledge there is no Configuration Item on that table?

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

best regards

Anders

[Sohail Khilji]

Hi @drslry2 ,

See the below example along with video :

https://www.servicenow.com/community/in-other-news/database-views-left-joins-and-filters-video/ba-p/...

I hope this helps...