- 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
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
05-24-2023 01:10 AM
Hi @Community Alums
That was very helpful, thank you. There's only one thing that's still missing for me: If my MRVS contains questions that are references, I'll only see the sys_id of the referenced records with this method.
I created a MRVS with the questions "Affected CI" (reference to cmdb_ci) and "Problem description" (string) for testing purposes, and added it to the default incident record producer. As you can see, for the field "Affected Ci", I'm only getting the sys id (as this is saved in the sc_multi_row_question_answer table), not the display value of the CI.
Can you please help me on this??
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-24-2023 04:09 AM
Hi Vamsi,
I am facing the same issue.
Did you ever find a solution for the displaying sys_id instead of value?
Regards, Vincent Wong
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-20-2024 10:29 AM
@Vincent Wong1 - I did this a terrible way, but it works. Just added a text (hidden on form, not in MRVS display, unfortunately) and used auto-fill to populate it. Then on the report, I'm hiding the sys_id question/answer, so I only see the readable name in the report. It's not the prettiest, but it'll work in my case.