Note:

You can only query for your own sites.
If you do not have access to a CP, the data (specimen/ visits/ participants) related to that CP, will not be visible to you - even in the query results.

Introduction

The query results display fields along with the options to perform various operations like Save, Export, Define Columns, Specimen Operations, etc.

Example Query Results View...

Query Actions

The below operations can be performed on the query using the "Actions" button:

Edit
Save
Columns
Rerun
Export

Query Actions Button

Configure Columns

The fields or the order of the fields to be displayed on the query results page can be configured.

Click here to view the steps...

Steps:

From the results page, click on the 'Actions' button.
Select option 'Columns'
Select the Columns needed in the results.
Reorder the columns by using drag and drop (Note: Drag the main tree node. Individual columns cannot be dragged)

Wide Rows

Wide Rows is related to 1:many fields like. E.g. one Participant with many Race, Ethnicity or MRNs OR Visit with multiple Clinical Diagnosis. In such cases, the Wide Row checkbox determines where to display all the values in one row (i.e. Wide Row) or display one row per value.

Click here to expand...

Example - On Enabling Wide Rows

Example - On Disabling Wide Rows

Display Field Names

If you need to display the internal "field name" as column headers instead of the "display name", the 'Display Field Names' option from 'Query' > 'Columns' can be used. This is especially useful for Forms where the display name can be a long question.

By default, the fields use display names

To show the field names as column headers

On enabling 'Display Field Names'

Default: Disabled 'Display Field Names'

Case Sensitive Search

From v6.3, there is an option to choose whether the search should be case sensitive. By default, all queries are run in case sensitive mode.

To configure case sensitive search...

Example - Case Sensitive Search enabled (default) on first name

Example - Case Sensitive Search disabled on first name

Configure display names for column headers

From v5.1, you can configure the header names for the columns in the query results page and the Exported CSV.

This feature can also be used in conjunction with the "Scheduled Query" feature. Once renamed and saved, the automated exported CSVs will contain the custom header names. This can be used to import into external databases. E.g. importing into a data warehouse.

Click here to expand...

Once the query is created, select the columns to be displayed in the query results page and click on 'Next' button. From 'Field Labels' section, specify the labels to be displayed and click on 'Done'

Column headers before configuration:

Column headers after configuration:

Save query

A query can be saved for future reuse OR sharing with other users.

To save query...

Click on 'Actions' button
Select option 'Save'.
Enter the query title and click on 'Save' button.

This will save the query along with the results view.

Export Query Results

You can export the query results as a CSV file, click on the 'Actions' button, and select option 'Export' to export query results

Select rows in query for operations

Users can select the rows from the query result and perform the action specified in below 'Specimen Operation' section.

Row count:

Display the count of row selected feature is implemented in v7.1. Check the highlighted in the below screenshot.

Specimen Operations

You can perform any specimens operation listed by selecting specimens in bulk.

Edit
Print
Delete
Close
Distribute
Reserve
Ship
Create Aliquots
Create Derivatives
Add/ Edit event
Transfer
Retrieve

To perform specimen operations...

To perform specimen operations, follow the below steps:

Select desired specimens from the results by clicking on the respective rows or click on 'Select All' to select all the specimens
Click on 'Specimens' button and select any desired operations from the list
Enter valid details and perform the selected operations

Once all the specimen are selected by clicking 'Select All', the 'Unselect All' option appears, click on that option to unselect all the selected specimens

Add Specimens to Cart

A Cart is a picklist of specimens. For more details: Specimen Cart.

You can add specimens from the results view to a new cart or existing cart.

To add specimens to a cart...

Click on 'Add to Cart' to add specimens to cart

Creating New Dashlets

Dashlets are items displays on a dashboard. You can create dashlets from the query results view. Refer 'Dashboard changes using query' for more details.

OpenSpecimen

Query Results view