The CreatorCon Call for Content is officially open! Get started 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