- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-18-2022 01:36 AM
Hi community!
I'd like to know if there's a way (or if it is possible) to create a report joining RITM variable sets and Multi-row Variable sets in one report.
Solved! Go to Solution.
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-18-2022 01:45 AM
HI Erika,
You can actually report on MRVS by creating a database view, then use that view to report on
- Create a new Database view (System Definition -> Database Views)
-
- Give it a name like 'u_sc_req_item_multi_var'
- Label like "Multi Row Variable Set"
- Plural like "Multi Row Variable Sets"
- Description like "Joins the sc_req_item to the Multi Row variable set table to be able to report"
- Save
- Under View Tables click "New"
-
- Table: Requested Item [sc_req_item]
- Variable Prefix: sci
- order: 100
- Where clause: mrqa_parent_id = sci_sys_id
- Click "Submit"
- Under View Tables click "New"
-
- Table: Multi Row Question Answer [sc_multi_row_question_answer]
- Variable Prefix: mrqa
- order: 100
- Where clause: keep this field blank
- Click "Submit"
You should now have a DBV that looks something like this:
Create a new report
Select Table as source and select your new Database view (Multi Row Variable Set) as the table
You should now be able to create a query and select the catalog item that you want to report on that has the MRVS, as well as adjust your columns to display the Question and Value as well as any other columns you want on your report.
Referred from this thread :https://community.servicenow.com/community?id=community_question&sys_id=252bce56dbd363809a64e15b8a96...
Mark my answer correct & Helpful, if Applicable.
Thanks,
Sandeep
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2024 05:43 AM
I just did exactly what was above by Sandeep in my instance and it's working. I'm guessing it's the inclusion of those last 2, or how you're choosing your columns. But, group by Number first and it should give you a view closer to mine.
Tip for you, I see that you are also gathering a user name/ID, in my catalog item I have a hidden text field that contains the string value of the User ID, so I get a readable name in the report (hence the hiding of question in my query).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2024 06:07 AM
Hi Neil
So for you all variables from RITM and multirow are coming in single column as Question and Value? If yes then, can you please help me with the data base view which you have created ?
I created like below:
So my main requirement is that, I want to create single report to show all variables from RITM (which get saved in tables marked in blue) and Multirow variables ( which get saved in table marked in Blue)
Thanks,
Aishwarya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2024 06:36 AM
Try removing the 2 Blue, I do not have those in my DB View.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2024 06:43 AM
Then it will show only data from Multirow variable sets (marked in Blue) and will not show from RITM ( those are simple variables from RITM marked in red). And I need to show both variables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2024 06:49 AM
I'm not sure I'm getting your issue, as you can see in my screenshots, I see exactly what you're requesting, using only the DB View above, and the report setup below.