Creating Report to include Approval Status and Requested Item Variables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-26-2019 07:34 AM
I am trying to create a report that will include the Approval status from the sysapproval_approver table and the requested items variables as columns. I have tried to do database view as described in the article below but I am unable to get the variables as columns.
Any help would be great.
Thank you
Brandon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-27-2019 10:32 AM
Hi Brandon,
I am not sure if you want to display the Requested Item Variables from Catalog Items. If this is the case, just follow the next steps:
1. Go to Create new Report from the Report Module
2. Select Classic UI (More easy)
3. Select "Requested Item" table
4. In the Available Columnes, search by a field called "Variables [+]"
5. Search the variable from Catalog items.
6. Add it to Selected Columns
Hope this helps,
Pedro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-29-2020 11:39 AM
This is old, but apparently it is targeted to be fixed in Paris: https://hi.service-now.com/kb_view.do?sysparm_article=KB0793561. Ran into the same issue, but couldn't get any combination of items working the way I wanted it to.
Workaround would be potentially to create a field on that table specifically referencing the requested item table, then dot-walk from there. You could use a BR or something similar to copy down the reference from "approval for" to this field.
