Filter condition issue

[dmahendran]

Hello Guys,

I'm working on a report where I need to filter records based on a variable called "Stop Date" within a Multi-Row Variable Set (MRVS). The requirement is to display records exactly 21 days before the Stop Date. For example, if the Stop Date is August 31, the record should appear in the report on August 10. I tried using relative date conditions like before, after, and on, but I haven’t been able to achieve this specific condition. Any help or suggestions would be greatly appreciated.

[Pranesh072]

It is not possible to directly use MRVS in report or filter conditions. As there is no one to one mapping between mrvs and requested item. It stored as json.

You have to create a database view with sc_req_item and sc_multi_row_question_answer and then you can add the filter for the dates. 

https://www.servicenow.com/community/platform-analytics-forum/create-a-report-with-ritm-variable-set...