Who is this article for?

Users wanting to find or report on reviews.

No elevated permissions are required.

This article provides guidance on generating reports on reviews using various methods available within Please Review and through direct database queries.

1. Usage Report
2. PleaseReport
3. Direct Queries
4. Reporting Considerations
5. Review Length
6. Reviews Open Concurrently
7. Reviews Opened Over a Month

1. Usage Report

Please Review offers a built-in Usage Report that may cover the required reporting needs. For more details on accessing and utilizing this report, refer to the article: Using License & Usage Reports.

2. PleaseReport

For more advanced reporting capabilities, Please Review provides the PleaseReport feature. Additional information on PleaseReport can be found in the article: What is PleaseReport?

3. Direct Queries

For on-premise deployments, it is possible to run SELECT queries directly on the Please Review database. However, it is important to note that updating the database schema is unsupported. To mitigate the risk of inadvertent changes, consider creating a secondary read-only database login specifically for querying purposes.

4. Reporting Considerations

When developing custom reports, it is crucial to clearly define the criteria and dates of interest. Determine whether the focus is on the creation date, dates during which the review remained open, due dates, closure dates, or completion dates. Once the relevant dates are identified, construct the appropriate queries to retrieve the desired information.

5. Review Length

To calculate the length of a review, examine the Start and Completion dates in the Review table. Keep in mind that depending on the system settings, completed reviews might be reopened. If the goal is to account for closure time and deduct it from the total open time, refer to the concepts discussed in the article: Reporting on Daily or Hourly Usage.

6. Reviews Open Concurrently

To determine the number of reviews open concurrently, analyze the review status: in progress (P), overdue (O), or closed (C). While this information can be obtained at a specific point in time, tracking it over an extended period would require generating reports at regular intervals and consolidating the data. The article Reporting on Daily or Hourly Usage discusses this approach in more detail. Be cautious when using open and completion dates for this purpose, as reviews can be completed and reopened multiple times.

7. Reviews Opened Over a Month

To identify reviews opened within a specific month, query the Review table and filter the results based on the desired open date range.