Table of Contents
Query View allows you to review data queries, with filter options such as query status (outstanding, pending, resolved), query category (such as missing, illegal, overdue visit), and query timing.
![[Note]](../../imagedata/note.png) | Note |
|---|---|
| Query View is only available when DFcollect is connected to DFdiscover server and API version 5.5 or later. |
To view data queries, from the Sites or Subjects page, click 
to open the Application Menu, and select from the dropdown menu.
When you open Query View from the Sites page, the Query Summary appears, showing the number of total queries at each site you have access to as well the number of outstanding, pending, and resolved queries. The totals for all sites are shown in the last row. Select a site row in the table to highlight it, then click to see the list of queries for that site.
When you open Query View from the Subjects page, the Queries page displays all outstanding queries for this site and includes the following information for each query: Subject, Visit, Plate, Field, Category, and Status. At the top of the table, Subjects shows the number of subjects currently selected and Total Rows indicates the number of queries that appear in the table.
To see more detail about any query in the table, click the row to select it, then click ... to open a dialog showing full details about the query. Click anywhere outside the dialog to close it.
The Queries page also includes options to filter queries by status, category, and timing, to download data records with queries for offline use, and to view reports about queries at this site.
To filter the queries that appear in the table, click 
to display the filter options for query modification timing, category, and status. Use the dropdown menu to select the desired options, and the table will update immediately. Click 
to reset the filter options. Click 
to hide the filter options.
To download queries for offline use, click one or more rows in the table to select them, or click the circle to the left of the Subject column header to select all records in the table. Click the row again to unselect it if needed. The Subjects number at the top of the table will update as rows are selected. Click 
to start downloading all data for the selected subjects. Once a subject's data is downloaded to your device, the icon 
will appear at the beginning of the row.
To view reports about queries at this site, click 
next to the site name at the top of the screen. The reports include:
Query Status in Site. Pie chart of queries by status at this site, including outstanding (blue), pending (orange), resolved (green).
Query Category in Site. Pie chart of queries by category at this site, including categories missing, illegal, inconsistent, overdue visit, missing page, and others.
Query Distribution in Site. Bar chart showing number of subjects, visits, records, and fields with total, outstanding, pending, and resolved queries.
Queries in Site Subjects. Bar chart showing the total number of subjects at this site alongside the number of subjects with any queries, with pending queries, with outstanding queries, and with resolved queries.
Queries per Subject. Table showing number of pending, outstanding, resolved, and total queries per subject. Click any subject row to highlight it, then double-click to close the report dialog and filter the list of queries to show only the selected subject.
Swipe to view each report. Click outside the dialog to close it.
To close the Queries page and return to the Sites or Subjects page, click .
To review a query, click a row in the Queries table to highlight it, then click to open the CRF and go to the field where the query is located. Click to open the query dialog.
The CRF menu will indicate that you are reviewing queries, with a small pie chart showing the status of queries on that CRF page. Click Query in the CRF Menu to see how many outstanding queries remain on the current CRF page. Review and resolve the queries and save the CRF as appropriate, as you would during data entry.
Click 
to return to the Queries page and select another query to review or close the Query View.