When you want to include the catalog item variables in your report, you must configure catalog variables in your reports because the variable values are stored in different tables rather than in the request item (sc_req_item) table. You can see the diagram of their relationship among catalog items, request items, and variables below.
Report Type
- Database View
- Report configuring variables using dot-walking.
Database View
Since both request item data and variable data are stored in the different tables (sc_item_option_mtom, sc_item_option, and sc_req_item), we can create a data source (database view) by merging all three tables together using the following steps:
Step 1 - Create Database View
Step 2 - Very your Database view by clicking "Try It" of Related Links
Step 3 - Create a report by selecting your database view table -u_catalog_item_variable_report
Report configuring variables using dot-walking.
If you want to create a variable report for one specific catalog item, you can configure those variables directly through your report by dot-walking to the variable table.
Step 1: Identify the catalog item for your report.
As a use case, I selected the "Request Leave of Absence" (OOB) catalog item. There are three variables in this item, so I am going to configure them into a report.
Step 2 -Configure Report Data with table
Step 3 Configure Catalog Item by the following steps
Step 4 - Add variables
Step 5 - Add filter condition by your item
Summary
The database view option is used for all types of catalog item variable reports, which can be added for a specific catalog item by adding a condition filter. The dot-walking option can be configured using dot-walking without any customization, but scope is only for the specific catalog item by adding the required variables through dot-walking.
If you enjoy my ServiceNow posts, please be sure to follow me on LinkedIn and my ServiceNow YouTubes Channels
4 Comments
