How to get the list of incidents closed by particular user
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-03-2019 11:07 PM
Hi ,
I need a small help guys
If a user is assigned with 10 Incidents and the user has closed 7 incidents of 10.
I need the list of 7 incidents numbers.
In a custom table there are 2 fields
1.USER(ref)
2.NUMBERS
if i select the user in USER field then the list of incidents closed by that user should reflect in NUMBERS field
Thanks in advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-04-2019 12:52 AM
There is a custom table with 2fields
1 USER(reference)
2 NUMBERS
If i select a person(user) in USER field then
i need all the list of incident numbers that are closed by that user
in NUMBERS field

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-04-2019 03:58 AM
Hi
I suggest to create a form view on the user record, with a related list filtered on incidents, which are closed by that user.
The table in my example above has a user field. So, if you show that List of the table, you can click on the user and open the form view with the related list.
Does that makes sense?
BR
Dirk

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-03-2019 11:55 PM
Create a report
Filter: Assigned to Same As Closed
Group by Assigned To
I don't understand the requirement for all these custom tables.
Each custom table is a table you have to allocate to a product suite when you move over to Madrid Licensing.
This 100% can be done with reports.
Why are you doing this?
ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022