To get Variables and MRVS variables in reports

[shobhan]

Have a scenario where need to fetch the Variables and Multi Row Variables of a particular catalog item in reports.

[Vishal Savajia1]

You can add few more tables in your current Database view. you should be good to retrieve expected result. 

M2M table to request item
sc_item_option_mtom.request_item = sc_req_item.sys_id

M2M table to variable
sc_item_option_mtom.sc_item_option = sc_item_option.sys_id

Reporting on Catalog item variables - ServiceNow Community

[shobhan]

I have tried  help me to how to write the M2M table in with database i have created.

the below screenshot attached just gives the MRVS but not all variables

[salma98]

Hi Shobhan,

Please refer to the below video and let me know if you have any questions.

Please mark this comment as Correct Answer/Helpful if it helped you.

Cheers,

Salma

[shobhan]

This gets only the variables but not all MRVS