Unable to get variables on RITM table report

Snehal13 · ‎07-23-2024

I am creating a report on sc_req_item table that needs to show the variable under it. When I choose columns, I dont see variable(+) in the column list.

How to get variable of RITM on list type ServiceNow report.

Prathamesh G · ‎07-23-2024

Hello @Snehal13,

Please try to follow below steps to add RITM Variables in your report: (refer to the screenshots)

Then select the Catalog item's name in the pop-up window:

Once you select the Catalog item, then the Variables associated with that catalog item will displayed to select in the report as below:

Please let me know if you still face any issue.

If the above solution resolve your issue, Please mark the solution as Accepted Solution and also mark it as Helpful.

Thank you.

View solution in original post

Amit Verma · ‎07-23-2024

Hi @Snehal13

Below post could be helpful :

https://www.servicenow.com/community/developer-forum/while-generating-a-report-from-ritm-variables-a...

Thanks and Regards

Amit Verma

Please mark this response as correct and helpful if it assisted you with your question.

Snehal13 · ‎07-23-2024

As informed earlier, When I choose columns, I dont see variable(+) in the column list.

Amit Verma · ‎07-23-2024

@Snehal13

Can you please check if your RITM has variables or not ? If possible, could you please share some screenshots ?

Please mark this response as correct and helpful if it assisted you with your question.

Weird · ‎07-23-2024

I feel like I struggled with a similar issue before as it was not possible OOB.

You could try building a database view where you connect one of the variable tables to the ritm records and then try reporting on it. Note that I didn't try that so I'm not sure how database tables work with reporting.