How to run a report on RITM variables and approvers

[e_wilber]

Hi everyone,

I'm trying to do a sanity check before building a solution.

We have a need to run a report on a handful of catalog forms. Each form would get their own report as we need to look at some of the variables that are special to that form.

That part is easy. However, we need to know the name of at least one of the approvers who approved that form during its lifecycle. This isn't a KPI that I see in the system anywhere. Because of this, I was thinking I'd create a new field on the RITM referencing the user table. Then write a background script to go through all the request items that were ever created, scan the approvals table and grab one of the names for each of the RITM records and update the RITM.

This would give me access to everything all in one report but it seems a bit much for what I'm trying to do.

Are there any other options? Is there anywhere the approver may be kept already?

[James Hammond]

Have you considered creating a database view of the Requested Item and Approval Tables, then running your report from there?

[e_wilber]

Yes but there appears to be a bug in Jakarta. I am not able to access any of the RITM variables from the database view table. It allows me to select them but if I click run or save on the report, it takes away all of the variable editor fields from the selection.

[SRJ]

HI , did you get any solution .. i am also facing the same issue in istanbul..

i need to generate a report form approval, Ritm and its variables ..