- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2024 02:25 PM
Hi all, I am working on a request item with a mutirow variable set. This multi row variable set in that request needs to be shown in one report, each question of this variable set... I have been folowing the tread Solved: Create a report with RITM Variable Sets and Multi-... - ServiceNow Community but in the report I cannot see the questions of the variable set...
I am maybe doing something wrong
I came so far...
Thanks in advance!
-Ana
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2024 06:46 AM
It looks like in your Where clause you need an additional equal sign. The way you have it written is assigning value, not comparing. It would look like mrqa_parent_id == sci_request.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-06-2024 07:02 AM - edited 06-06-2024 07:03 AM
Did you create the Database view between [sc_req_item] and [sc_multi_row_question_answer]? The question column comes from [sc_multi_row_question_answer]. The thread you linked is correct in how to report on Multi Row Variable Sets. You have to report on the newly created database view (table) that is created that grabs data from both tables and "creates" a new table with the info from both tables combined
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2024 05:36 AM
Hi Zach, yes I was choosing those two tables, the problem now is the SQL query in the where clause... I was trying with "mrqa_parent_id = sci_sys_id" but the database view table shows no results
thanks for the answer!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2024 06:46 AM
It looks like in your Where clause you need an additional equal sign. The way you have it written is assigning value, not comparing. It would look like mrqa_parent_id == sci_request.