Database view Where Clauses

[Wendy20]

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!

[Prince Arora]

@Wendy20 ,

Can you try the below combination, it is giving me correct response as I have checked in my PDI, just change the sys_id according to your user

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful based on the Impact.

[Prince Arora]

@Wendy20 , Have it worked for you? 

Please accept it if it works!

[Wendy20]

Hi, Thank you for your response. Unfortunately it did not work. I need to show the security incidents "opened_by" the "X user sys id" and it also has to show "task_sla" details of those security incidents and from the user table we need to see the details of the "assigned_to" user that is working on the security incidents we are seeing.    when I tried your suggestion I could not see any records. 

[Prince Arora]

@Wendy20 ,

Could you please share snippet of you DB view, because it worked for me in my PDI

same conditions and same where clause, might be you missed something