- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-10-2023 05:21 PM
Hi all,
I have created a database view where I need to combine security incidents opened by "x user". and the sys_user table. I need some help with the where clause to connect the tables and show the user's details based on Security incidents opened by "x user". Any help is appreciated.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-14-2023 08:45 PM
Hello @Wendy20 ,
I misread your comment, I thought you want all incidents for which Assigned To is Beth Anglin. However, if you want to get incidents opened by Beth Anglin you can use below mentioned WHERE clause and that will work for you:
Incident --> Order: 100 --> inc_opened_by="46d44a23a9fe19810012d100cca80666"
User -- Order: 200 --> inc_assigned_to=usr_sys_id
If my answer has helped with your question, please mark it as correct and give it a thumbs up!
Regards,
Shubham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-14-2023 11:40 AM
I am looking to find a list of incidents opened by "beth anglin" from incident table and the user details of the users assigned to those incidents from the user table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-14-2023 08:45 PM
Hello @Wendy20 ,
I misread your comment, I thought you want all incidents for which Assigned To is Beth Anglin. However, if you want to get incidents opened by Beth Anglin you can use below mentioned WHERE clause and that will work for you:
Incident --> Order: 100 --> inc_opened_by="46d44a23a9fe19810012d100cca80666"
User -- Order: 200 --> inc_assigned_to=usr_sys_id
If my answer has helped with your question, please mark it as correct and give it a thumbs up!
Regards,
Shubham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-16-2023 09:30 AM
Thank you so much for all of your time and help.