RITM report with all variables and approval details in single report

[Raghesh]

Hi All,

We have a requirement to pull a report of all RITM's and its associated variables and approval details in one single report. Is that possible, if yes from which table we need to run that report.

Any guidance on this matter is much appreciated.

regards,

Raghesh

[Prince Arora]

@Raghesh 

Variables of the RITMs are stored in MTOM table, you need to add 2 more tables in the database view please check below:

And you need to fetch the name of variable as follows

Question.Name is something

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful based on the Impact.

[Manoj89]

Instead, build a report from the sysapproval_approver table

Set the filter source table to "sc_req_item"

On the configure tab --> Choose Columns --> you may see prepopulated related table (sc_req_item) column, you can also add more by moving columns from left to right

[wmcgrath]

Hi @Raghesh 

What is the purpose of your report? What outcomes are the business trying to achieve with this report?

The problem with a report like this is that the answer to each question in each RITM will appear in a column under that question. If you have a number of catalog items with a number of questions, you'll find that the number of those columns can become harder to view in the report - it's more likely that such a report would have to be exported and manipulated further to make better use of the data as you'll have many empty cells which are irrelevant to the catalog items in question.