# Query and report on request meta data **URL:** \ **Category:** Development\ **Created:** [July 28, 2017, 7:15pm UTC](https://discuss.workflowgen.com/t/query-and-report-on-request-meta-data/827 "2017-07-28T19:15:30Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![schaubal](https://avatars.discourse-cdn.com/v4/letter/s/8baadc/32.png) [@schaubal](https://discuss.workflowgen.com/u/schaubal)\ **Post date:** [July 28, 2017, 7:15pm UTC](https://discuss.workflowgen.com/t/query-and-report-on-request-meta-data/827/1 "2017-07-28T19:15:30Z")
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. ---
**Author:** ![eddy.daouk](https://yyz2.discourse-cdn.com/flex030/user_avatar/discuss.workflowgen.com/eddy.daouk/32/672_2.png) [@eddy.daouk](https://discuss.workflowgen.com/u/eddy.daouk)\ **Post date:** [August 3, 2017, 1:14pm UTC](https://discuss.workflowgen.com/t/query-and-report-on-request-meta-data/827/2 "2017-08-03T13:14:57Z")
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. ---
**Author:** ![schaubal](https://avatars.discourse-cdn.com/v4/letter/s/8baadc/32.png) [@schaubal](https://discuss.workflowgen.com/u/schaubal)\ **Post date:** [August 3, 2017, 1:30pm UTC](https://discuss.workflowgen.com/t/query-and-report-on-request-meta-data/827/3 "2017-08-03T13:30:41Z")
Thanks , that was a plan B I was planning to pursue. Would GraphQL make this easier in any way?