You are viewing limited content. For full access, please sign in.

Question

Users performance report

Forms

Updated March 1, 2019

asked on January 7, 2019

Laserfiche Forms Version: 10.3.1

Is it possible to create a view on Laserfiche Forms database to get the following statistics within a range of dates? (As this cannot be achieved through reports in Forms)

User Name: Display Name

Available Tasks: Count

Completed Tasks: Count

In Progress Tasks: Count

I will appreciate if SQL Queries can be provided to know exact tables.

1 0

Replies

replied on March 1, 2019

You're right that the specific information you are looking for it is not currently available through Forms reporting. If you are just looking for the top users/teams however, you can find a subset of this information on the operational reports with the "Tasks" filter.

In terms of database tables, the task_metrics_mapping table should contain all of the information you need.

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked January 7, 2019
Updated March 1, 2019
139 views