I want to pull MRVS variables in Database View Report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-04-2024 03:10 AM
I am struggling to pull MRVS variables from Requests into the Database View Report.
I want to display the variables into the report.
- Labels:
-
Data Foundations
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-04-2024 03:23 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-04-2024 03:45 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-04-2024 03:50 AM
Yes ... I have already mentioned key which is common in both the tables.
Join Condition:
req_item.sys_id = mrvs.document_key