How to add Multi Row Variable Set variables/questions as report columns

Rajesh Mudam
Mega Guru

‎04-14-2023 06:22 AM

Hi, 

we have a requirement to add and show the multi-row variable set variables in the report as columns.

I try to create a database view by joining sc_multi_row_question_answer, sc_item_option & sc__reg_item, but it is giving the option to add a question column to the report, actually, we need the variable in the report columns.

 

RajeshMudam_0-1681478384377.png

 

For example, we are collecting asset details from the SD team in one request MRVS, that MRVS has Assent Number, and Asset Type questions/variables, we are trying to add Asset Tag, and Serial Number in report columns. 

 

Can anyone please help us here?

 

Thanks in advance.

0 Helpfuls
  • 1,110 Views
2 REPLIES 2

Ratnakar7
Mega Sage
Mega Sage

‎04-20-2023 02:33 AM

Hi @Rajesh Mudam ,

 

To add Multi-Row Variable Set (MRVS) variables as report columns, you need to create a join between the sc_multi_row_question_answer table and the task table (or any other table that contains the MRVS field). Here are the steps to achieve this:

  1. Create a database view that joins the sc_multi_row_question_answer table and the task table. You can also join other tables that are needed for your report.

  2. In the database view, select the value field from the sc_multi_row_question_answer table for each MRVS variable that you want to include as a report column.

  3. Rename the columns in the database view to meaningful names, such as Asset Tag and Serial Number.

  4. Create a report in ServiceNow, and select the database view as the table to report on.

  5. In the report, add the columns from the database view that correspond to the MRVS variables that you want to include in the report.

  6. Save and run the report to see the MRVS variables as report columns.

 

If my response was helpful in resolving the issue, please consider accepting it as a solution by clicking on the ✅Accept solution button and giving it a thumbs up 👍. This will benefit others who may have a similar question in the future.

 

Thank you!

Ratnakar

0 Helpfuls

chrortega
Tera Contributor
In response to Ratnakar7

‎08-09-2024 02:14 PM

Ratnakar,

 Can you please provide more information on how to achieve this? I tried using the Databaseview but I cannot make that for example a question saying "What's year creation " shows a column in the report.  Seems to be in your step 2 but where/how is that exactly done?

 

Thanks¡

Christian O.

0 Helpfuls