Database view table not returning any results

matthew_hughes
Kilo Sage

I've got the following database view where I'm wanting to return a list of software models with certification tasks:

 

matthew_hughes_0-1704360531999.png

 

However when I click on Try It, no results appear. I was expecting the following results to appear:

 

matthew_hughes_2-1704360638738.png

 

Can somebody explain what I'm doing wrong?

2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @matthew_hughes 

 

Let's break this in to chunks, and try 

with 2 table and see results are coming then add 3  and check and then 4th and check

 

only way to trouble shoot.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Ana39
Tera Contributor

Hi there, It is pretty much try - change & try again. 
be aware that the order of the tables, has impact. the left join can be also one issue affecting the results.
today I faced that the text in the "where clause" was wrong, there was an "enter" and that is something it doesn´t like at all. 
I leave you here the one I was playing with today 

Ana39_0-1723136781619.png

 

hope it helps!