Query and report on request meta data

Development
1

What is the best way to query and report on request meta data, not process data.
Example - When each action is completed a completion date is captured. What if I wanted to report on the average time it has taken users to go from completing action A to completing action B within a workflow.

2

The best and fastest way is to query directly in the database:
The table WFACTIVITY_INST contains all the information you need.
Each instance has the opening, start and closing date (DATE_OPEN, DATE_START, DATE_CLOSE).
You will be able to get the time and calculate the average time to complete actions.

Eddy.

3

Thanks , that was a plan B I was planning to pursue.
Would GraphQL make this easier in any way?