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.

Database view Where Clauses

Wendy20
Tera Expert

Hi all,

I have created the below database view and need some help with the where clauses.  The requirement is to view all security incidents Opened by "x" .  It should contain information on the user that is assigned to this incident.  and also should include Task SLA details for the security incident.  No records are showing.  

If I use the where clause for Task SLA as "tsla_sla"  and I can see records but it's showing millions of records where only less then 1000 security incidents were opened by "x" user.  Any advice will be appreciated. Thank you!

 

Wendy20_0-1680198162279.png

 

1 ACCEPTED SOLUTION

Thanks for your help. I used your suggestion and modified a bit and it's working.  See below.  Really appreciate your help.

Wendy20_0-1680645073197.png

 

View solution in original post

5 REPLIES 5

Thanks for your help. I used your suggestion and modified a bit and it's working.  See below.  Really appreciate your help.

Wendy20_0-1680645073197.png