- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-30-2023 10:54 AM
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2023 02:51 PM
Thanks for your help. I used your suggestion and modified a bit and it's working. See below. Really appreciate your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2023 02:51 PM
Thanks for your help. I used your suggestion and modified a bit and it's working. See below. Really appreciate your help.