Create a report with RITM Variable Sets and Multi-row Variable Set

Erika · ‎08-18-2022

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.

Community Alums · ‎08-18-2022

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)
1. Give it a name like 'u_sc_req_item_multi_var'
2. Label like "Multi Row Variable Set"
3. Plural like "Multi Row Variable Sets"
4. 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"
1. Table: Requested Item [sc_req_item]
2. Variable Prefix: sci
3. order: 100
4. Where clause: mrqa_parent_id = sci_sys_id
5. Click "Submit"
Under View Tables click "New"
1. Table: Multi Row Question Answer [sc_multi_row_question_answer]
2. Variable Prefix: mrqa
3. order: 100
4. Where clause: keep this field blank
5. 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

View solution in original post

Aishwarya37 · ‎04-03-2024

So variables from your report are all from multirow set or from RITM also?

Just for more clarification I am adding portal form which I created:

So here, variables from Red are getting saved in sc_item_option_mtom and sc_item_option and variables marked in Blue are getting saved in sc_multi_row_question_answer.

If I remove blue from bellow view, then ONLY variables marked in red in above form will show up in report.

othman jamail · ‎01-16-2025

Hello,

I created the Database View as you mentioned, but I can't find it in the Reports section.

Do you have any ideas that could help, please?

Thank you in advance!

Ravindra H V · ‎02-09-2025

Follow below steps to join Req item table with Multi row variables table:

Step 1: -

Create a Database View as show below in screen grab.

Step 2: - verify the data is visible on the table.

Step 3: - create the report.

If this response is useful, please mark it as helpful.