Creating, viewing responding to, and closing queries
Query creation, routing, and closure are key components to drive the success of data collection. These processes help identify errors and provide more accurate data for reporting. This article covers how to interact with queries, how the routing works, and how to manage queries.
Use the following links to jump to a desired section:
Prerequisite: User must have permissions to manage queries.
The normal workflow of Queries is as follows:
1. Query gets created - either by the system due to data entry or manually by a user. These will have the status "Attn: Site" and appear Red in color.
2. The query has a message posted
3. The query is closed
Manual queries must be manually closed by a user with permission to do so.
Automatic (system) queries will automatically close based on data being corrected.
Queries are only visible to a user if one or more of the following is met:
- The query is deployed to their role
- They have permissions to view all queries within the Queries Report
Query Distribution is unique to each query, but follows a default setting configured by the Study Administrator. Read more about redeploying queries below.
How the system routes query status
When a query is created either by the system or by an Administrative type role, the status of that query will be Attn: Site
When a site type user comments on a query, the status will update to Attn: Issuer
Commenting/Posting a message to a query
Queries are the optimal way to handle contextual communications that pertain to study data, without the need for email or other external methods.
Prerequisite: User role has access to Query management
Query dialog windows can be opened by tapping the query icon on the eCRF or via the Queries Report.
In the table that opens, there will be one or more queries listed, along with details of each, including which roles it was distributed (visible) to.
Tap the query link to open additional details:
Comment as needed to add a message to the query, then tap the save or post button.
Same process on the mobile app after tapping the query icon next to a field on the form.
The same can all be done from the Queries Report to address all queries in one place without opening forms one by one.
Adding a manual query
Prerequisite: User must have access to Query Management, Create Query permission
When reviewing a form, an icon like below will display next to each field on the form.
If the field is being SDVd or a query already exists, that can be tapped as well to open the query creation form:
Here's an example where a query already exists on a field. Tapping the query icon opens the form to add a new one. Select the query type and use the description for the query message.
The Roles checkboxes indicate who the query will be visible to. This may be disabled depending on the configured study permissions.
or select the existing query in the table at the top for viewing its details:
From here the query can be updated, commented on, closed or redistributed - depending on permissions granted to your user role.
By default, all queries will be distributed to the roles defined within the study configuration. Roles not included in the distribution will not see the query on the eCRF or in the Queries Report.
Queries can be individually re-deployed (redistributed), to different roles if needed.
Prequisite: User role does not have the permission "Prevent editing role distribution" enabled within the Query Management permissions.
To redeploy a query, open the query window, select the desired query, select the roles needed and then tap the redeploy button.
Closing A Query or Group of Queries
Prerequisite: User must have access to Query Management, Close Query permission.
Open the query dialog window from the form or from the Queries report
Select the query message and then check the box "Close query". A reason will also be needed. The reasons available to choose from are configured by the Study Administrator.
From the Queries Report:
Batch closing groups of queries can also be done from the Queries Report. Continue reading to learn about that capability.
Closing manual queries authored/created by other users might not be possible if your Admistrator has prevented that in the role permissions.
This report serves as a central place to both view and work with queries.
Prerequisite: User has access to Query management, Bulk close query, and the Queries report
Select the Queries Report option under the Reports Menu.
Column descriptions for the highlighted columns above:
- Subject ID where the query resides - This is a link to the subject’s casebook
- Date/time the query was opened - This is also a link to open the record where the query resides.
- Msg - Tap to open dialog window for posting message or closing (permission-dependent). The number indicates the number of messages currently posted on the query
- Batch close - Checkoxes to select for the purpose of batch closing the queries by using the action buttons on the right.
Query Summary Report
The query summary report is located under the Reports menu and provides metrics related to query statuses and ages.
Prerequisite: Access to Query Summary Report
The following metrics can be assessed from this report:
- Total open queries split by manual and system
- Total closed queries, split by manual and system
- Total queries, both open and closed across the study
- Total open and closed by the site (website only)
- Total open and closed by age across the study (app only)
- Total number of CRFs by the site to help show site performance alongside the query numbers
Unable to see a query on the form
There are two possible causes for this, starting with the most common:
- The query exists on a data field that has since been deleted. This is typically a row within a table that was deleted - which can be verified in the audit history. Alternatively, it was a field that the study Administrator removed from the form. In either case, the query is only visible in the queries report and can be commented or closed from there.
- The user's role did not have the query distributed to it. If the role is normally supposed to see queries, the study configuration needs to be updated to include that role. Otherwise, queries must be individually re-distributed to the desired roles. This can be done by opening the query details by anyone who has the permission to edit query distribution.