Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

need help with database view

priyanka chodip
Tera Contributor

‎12-11-2025 05:06 AM

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
  • 917 Views
6 REPLIES 6

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

‎12-17-2025 02:34 PM

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.

*************************************************************************************************************
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

‎12-11-2025 05:20 AM

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