How to output Authorisation data in a report

[Adrian Simpkins]

Hi All,

I have had a requirement posed to output a report to show the progress of authorisation's in a request. Currently we have some processes that once raised assign direct to our Finance Team to authorise. I want to output this in a report ideally with the following data:

- Date of approval / rejection by Finance team from the assigned authorisation activity

- Date of expiry on any authorisation's that are not actioned in the required time period set in the BPM timer config

Which table should I join from within the report tool please?

Many thanks

[Steve Giller]

These values are all available within the Workflow, so I'd be putting them into Custom Fields on the Request to avoid having to build potentially complex JOINs and WHERE clauses.