multi row variableset - report variables group by number

Ana39
Tera Contributor

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... 

Ana39_0-1717622564671.png


Thanks in advance! 
-Ana

1 ACCEPTED SOLUTION

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.

If this information helped resolve your issue, please remember to mark response correct and thumbs up to help future community members on this information, thanks!

View solution in original post

3 REPLIES 3

Zach Koch
Giga Sage
Giga Sage

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

If this information helped resolve your issue, please remember to mark response correct and thumbs up to help future community members on this information, thanks!

Ana39
Tera Contributor

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 

Ana39_0-1717763394774.png

thanks for the answer!! 

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.

If this information helped resolve your issue, please remember to mark response correct and thumbs up to help future community members on this information, thanks!