Please help, I am confused as to how to implement this.
I have this table with records and each record
contains a MRVS data (Red rectangle), and I wanted to get the values of each MRVS record in the green box as my requirement is to make a report that shows the popularity of each drink per month.
Hi
Reporting is not available for MRVS OOTB, you will require to create a Database view.
Refer to this example:
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
Hello Sandeep,
I am having trouble setting it up. My requests are not in the requested items. These are different ones.
The requests/orders are in this table
and its each record has its mrvs data with the name of the drinks but I do not know how to access the column(specifically the Name of the drinks) in the MRVS. The values for the name of the drinks cannot be seen in the table. I only added a formatter there so it will show how it looked like in the record producer.
