I want to pull MRVS variables in Database View Report

Taaha M
Tera Contributor

I am struggling to pull MRVS variables from Requests into the Database View Report.
I want to display the variables into the report.

3 REPLIES 3

Vishal Savajia1
Kilo Sage

Each MRVS is stored in a separate table named sc_multi_row_question_answer

Choose Tables for Database View

For Example
Add the Parent Table (e.g., sc_req_item).
Add the MRVS Table (sc_multi_row_question_answer).
Define Join Conditions:

Join the parent table and MRVS table on the appropriate key, typically the sys_id of the parent table matches the document_key of the MRVS table.

 

DB View should be like this: 
sc_req_item (Alias: req_item)
sc_multi_row_question_answer (Alias: mrvs)
Join Condition:

req_item.sys_id = mrvs.document_key

Abdul Azeem
Tera Contributor

The DB view will only show you information from the two tables WHEN there is a "connection" (the where clause) between the two of them. In your case request table and mrvs table. You need to build the connection between these 2 tables using right key which is common in both the tables.

Yes ... I have already mentioned  key which is common in both the tables.

Join Condition:

req_item.sys_id = mrvs.document_key