Definitions:

  • Queries are inquiries or alerts about potential incorrect data.
  • Annotations are notes on a Form that do not contain clinical data and are usually used for keeping track of workflow.
  • Reasons for Change are notes added by a user when modifying data on a form that has already been marked as Complete.

The system creates queries automatically if you close a Form that has unaddressed errors or you can manually create a query.

Another user can respond to it and/or change the response in the field. Only Data Managers and Monitors can close queries.

The Queries Table

A table displays queries, annotations, and reasons for change. Details about each query, annotation, or reason for change are listed in the Detailed Notes column.

You can click Show More at the top of the table to show more columns.

To filter by reason for change, click the gray filter box under the Type column, and select Reason for Change. You can change the view of the Queries screen to filter any column that includes a gray filter box.

The Table Below Displays Statuses for Queries and Annotations:

IconStatusDescription
No QueryClick this bubble to create a query.
NewA query has been added by either a site user (e.g., a comment/annotation), data manager, or monitor, or was auto-generated by OpenClinica based on built-in edit checks.
UpdatedEither a site user, data manager, or monitor has added information to the query.
ClosedThe query is considered resolved by the data manager or monitor.
Closed ModifiedSlightly paler than Closed, this means the data was changed after the query was closed.
Multiple New QueriesYou can select each query from the sidebar.
Multiple Updated Queries
You can select each query from the sidebar.
One or Multiple AnnotationsYou can select each annotation from the sidebar.

To Review Data Associated with a Query, You Have Two Options:

IconViewDescription
View Query OnlyThis option displays a shaded background showing the item value in question, with the query and item history in the foreground. You can add a query comment, assign the query, and you have the option of emailing the assigned user. All users with access to queries can update the query; only Data Managers and Monitors have access to close a query.
View Query Within RecordThis option displays a shaded background of all the item values on the form for that query. You have access to update the query and update and/or review all the data on the form. This provides reviewers with more context when reviewing specific item data issues.

You can access these options from the Actions column of the Queries table.

View Query Only:

View Query Within Record:

You can then update the query comment, use the x to close the query details, and review the entire form in question. Data Managers and Monitors have the additional option of closing the query.

If an item only displays based on the response to another question, there may be instances where an item was conditionally displayed, a query was added to that item, and then the response to the lead-in question was changed, so that item is no longer displayed. That query still exists, however, and needs to be addressed.

Similarly, if there is a form that has repeating records and a query was added to a row, but that row has since been deleted, the query still exists, but is no longer displayed on the form. OpenClinica informs you of these hidden items and provides an option for resolving the associated queries.

For example, when the item in question is a response that has since been hidden, or is on a repeating record that has since been deleted, the following message displays:

To review the remaining data on that form, click OK and review the data. To review the data for the item in question, return to the Queries screen and use the View Query Only icon for that query (as instructed in the message).

Creating Queries

Use Case(s):

  • Participant data does not match the source record.
  • Participant data is clinically inaccurate.
  • Participant data contains a typographical error.
  • A form needs to be marked complete but an edit check prevents it.
  • Information is missing from a form.
  • A form in an Event was not started on time.

Users can create queries to inquire about participant data.

Note: Each query is automatically assigned an ID that is unique to the study environment (i.e. Test or Production). The ID appears in the Queries widget but is not visible until you close and reopen the Form. It also appears on the Queries table.

You can add multiple queries regardless of any existing ones.

You can only add/respond to queries and annotations in Edit Mode or Review-Only Mode, as determined by your User Role. You cannot do so in Read-Only Mode.

You can view the history for all queries and annotations on a single item by selecting View All History, or you can view the history of each query or annotation individually by selecting that query or annotation from the left panel. If you check the Show value changes checkbox, each value change is included in the history.

Best Practice:

  • If a form has not been started when it should have been, a Data Manager can add a query to the events start date.
  • When a query is created, it should be assigned to the correct recipient. If action is required excluding if the query needs to be closed, the Email checkbox should be checked off.
  • A new query should be created for a single issue, instead of combining multiple issues.
  • A new query should be created rather than reopening a query that has already been closed.

To Create a Query:

  1. Open a Form.
  2. Click the Query Bubble in the field you want to create a query for.
  3. Click the +New button next to Queries.
  4. In the Add a new query field, enter text explaining the possible error or question.
  5. (Optional) Select a user from the drop-down list next to Assign to. If you want to email that user to notify them about the query, check the box next to Email. When a query notification email is sent, it includes the Query ID for easy access.
  6. Click the Add Query button.

Responding To/Updating Queries

Use Case(s):

  • A response is required for the query to be resolved.
  • Participant data must be changed for the query to be resolved.

Users can update queries by responding to a query and/or changing data in the form. If data is changed, they will be prompted to enter a reason for change.

Note: You can only add/respond to queries and annotations in Edit Mode or Review-Only Mode, as determined by your User Role. You cannot do so in Read-Only Mode.

You can view the history for all queries and annotations on a single item by selecting View All History, or you can view the history of each query or annotation individually by selecting that query or annotation from the left panel. If you check the Show value changes checkbox, each value change is included in the history.

Best Practice:

  • All users can view a list of queries that have been assigned to them by expanding the Quick Links header in the left-hand sidebar and clicking Queries Assigned to Me.
  • Data Managers can view a list of queries that have been assigned to them by clicking Queries Assigned to Me on the Home screen.
  • When a query is responded to/updated, it should be assigned to the correct recipient. If action is required, the Email checkbox should be checked off.
  • Data Managers and Monitors should review the entire queries list regularly to check for unassigned queries.
  • If a conditional field (a field that appears based on the response to another field) has a query on it but a user has changed the response to the main field so that the conditional field no longer appears, the query still exists and needs to be addressed, but the field no longer appears on the Form. To review the remaining data on that Form, click OK, and review the data.
  • If there is a form that has repeating records, and a query was added to a row, but that row has since been deleted, the query still exists, but no longer appears on the Form. A message appears to inform you of these hidden items and provides an option for resolving the associated queries. To review the remaining data on that Form, click OK, and review the data.

To Respond to or Update In a Form:

  1. Open a Form.
  2. Click the Query Bubble in the field you want to create a query for.
  3. Select the query you want to respond to and/or update.
  4. (Optional) If you need to change information in a form, close the Query widget, and make changes to the Form manually. You must provide a Reason for Change before completing the Form.
  5. In the Respond to query field, enter text explaining the query response.
  6. (Optional) Select a user from the drop-down list next to Assign to. If you want to email that user to notify them about the query, check the box next to Email. When a query notification email is sent, it includes the Query ID for easy access.
  7. Click the Update button to add the response and leave the query open.

To Respond to or Update a Query from the Queries Table:

  1.  Click View Query Only or View Query within record in the Actions column of the Queries table.
  2. (Optional) If you need to change information in a form, close the Query widget, and make changes to the form manually. You must provide a Reason for Change before completing the form.
  3. In the Respond to query field, enter text explaining the query response.
  4. (Optional) Select a user from the drop-down list next to Assign to. If you want to email that user to notify them about the query, check the box next to Email. When a query notification email is sent, it includes the Query ID for easy access.
  5. Click the Update button to add the response and leave the query open.

Closing Queries

Use Case(s):

  • The information on the form has been changed to address the query.
  • A response clarifies why the existing information is accurate.

Data Managers and Monitors can close queries when the issue has been resolved. Data Managers and Monitors are also the only user roles with the ability to reopen a closed query.

Best Practice:

  • A new query should be created rather than reopening a query that has already been closed.
  • If a conditional field (a field that appears based on the response to another field) has a query on it but a user has changed the response to the main field so that the conditional field no longer appears, the query still exists and needs to be addressed, but the field no longer appears on the Form. To review the remaining data on that Form, click OK, and review the data.
  • If there is a form that has repeating records, and a query was added to a row, but that row has since been deleted, the query still exists, but no longer appears on the Form. A message appears to inform you of these hidden items and provides an option for resolving the associated queries. To review the remaining data on that Form, click OK, and review the data.

To Close a Query In a Form:

  1. Open a Form.
  2. Click the Query Bubble in the field you want to create a query for.
  3. Select the query you want to close.
  4. Click the Close button.

To Close a Query from the Queries Table:

  1. Click View Query Only or View Query within record in the Actions column of the Queries table.
  2. Click the Close button.

Queries can also be closed in bulk using the Data Review Table.

Annotations

Use Case(s):

A user adds an annotation to keep track of workflow

You can add an annotation to a field to make a note. Annotations cannot be assigned, responded to or closed.

Best Practice: Annotations should not contain clinical information.

Note: You can view the history for all queries and annotations on a single item by selecting View All History, or you can view the history of each query or annotation individually by selecting that query or annotation from the left panel. If you check the Show value changes checkbox, each value change is included in the history.

To Enter an Annotation:

  1. Open a Form.
  2. Click the Query Bubble in the field for which you want to create an annotation.
  3. Click the +New button next to Annotations.
  4. In the Add a new annotation field, enter text for the annotation.
  5. Click the Add Annotation button.

Note: Annotations are indicated with an i icon. They appear as N/A in the Query ID column and Not Applicable in the Resolution Status column. 

Downloading Queries, Annotations, and Reasons for Change

To Download Queries, Annotations, and Reasons for Change:

  1. Click the Download button at the top of the table. A Download window appears.
  2. Select comma-separated values or portable document format in the format field.
  3. Click the Download notes button.

Printing Queries, Annotations, and Reasons for Change

To Print Queries, Annotations, and Reasons for Change:

  1. Click the Print button at the top of the table. A Print window appears.
  2. Click ctrl + p (Windows) or command + p (Mac) or click Ok, right click the window, and select Print.