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...

Open

Query Actions

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

1. Edit

2. Save

3. Columns

4. Rerun

5. Export

Query Actions Button

Open

Configure Columns 

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

Wide Rows

Wide Rows are related to 1:many associations, such as one Participant with many MRNs, multi-record forms, etc. In such cases, the Wide Row checkbox determines whether to display all the values in one row (i.e., Wide Row) or one row per value.

For example, Participant P1 has 2 MRNs (Site1/MRN1, Site2/MRN2). By default, these are displayed in 4 columns with 1 row per participant. If "wide rows" is disabled, they will be displayed in 2 rows, with the rest of the columns duplicated. 

This can also be used for multi-record forms.

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

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.

Configure display names for column headers

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.

Save query

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

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 below.

Specimen Operations

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

1. Edit 

2. Print 

3. Delete

4. Close 

5. Distribute

6. Reserve

7. Ship

8. Create Aliquots

9. Create Derivatives

10. Add/ Edit event

11. Transfer

12. Retrieve

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.

Creating New Dashlets

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