Setting up a Rejected AWA Cases report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-14-2022 09:07 AM
Hello All,
I'm trying to setup a report in our servicenow system for AWA time out cases. Screenshot attached. What i want to do is to see the time out for only P1 incidents. How can i achieve that.
I'm unable to find a filter to select the priority. Any help would be really helpful
- Labels:
-
Advanced Work Assignment
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2022 07:28 AM
Hi,
on which table you are generating report. Both case and incident table have the priority field.
please share more details.
regards,
Pavankumar
ServiceNow Community MVP 2024.
Thanks,
Pavankumar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2022 02:19 AM
Im using Table: SAP timed out work item [u_sap_timed_out_work_item]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-16-2022 08:34 AM
Hello,
You can do reporting on awa_work_item where you can get all your work items and I think if your queue or channel is on case table then in "Document ID" field you will find the tagged case or you ticket.
I know that you can't dot walk on Document ID field
I had a requirement like yours but we ended up in creating a custom field on work item form which refers to case table and stores the case tagged in document ID field. We wrote a BR for this which updates this custom field with case number when ever a work item is created .
And i did reporting on that custom field .As it was a reference field i could dot-walk to fields on case table.
In your case you can access priority field on the case form by dot-walking from that custom field.
please refer below link for proof that we can't dot walk .Check for chuck thomasi answer
This is the only solution that we got.
And in your report you can filter out for timed out work items using check box "Timed Out" on work item form like below
Please mark my answer helpful if it helps you
Hope this helps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2022 02:20 AM
Sure will check this and get back. Appreciate your help