need help with database view

priyanka chodip
Tera Contributor

3 weeks ago

Hi There,

i have a requirement to get cases with a,b,c groups that has an sla or not
so i created tables below

priyankachodip_0-1765457617194.pngpriyankachodip_1-1765457670960.png

result looks like below

priyankachodip_2-1765457815351.png

it is acutally getting SCTASK,Case and other as well.
but i need only Case table data.
please advice on it.

Thankyou

0 Helpfuls
  • 562 Views
6 REPLIES 6

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to priyanka chodip

2 weeks ago

Ho @priyanka chodip 

It will be “as is” because it matches the sys_id. Try creating another DB view where the condition is manetib != sys_id, and then check if that works.

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

OlaN
Tera Sage
Tera Sage

3 weeks ago

Hi,

I believe that the Left join should be on the customer_case table (this is the base table and you want this to be the left table in your view).

We did a video on database view recently, and at about 22 min in we discuss the Left join option.

Have a look and see if it helps you.

0 Helpfuls