Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Note
titleNote:
  1. You can only query for your own sites.
  2. 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.

Expand
titleExample Query Results View...

Image RemovedImage Added

Query Actions

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

...

Expand
titleQuery Actions Button

Image RemovedImage Added

Configure Columns 

...

Expand
titleClick here to view the steps...

Steps:

  1. From the results page, click on the 'Actions' button. 
  2. Select option 'Columns'
  3. Select the Columns needed in the results.
  4. Reorder the columns by using drag and drop (Note: Drag the main tree node. Individual columns cannot be dragged)Image Removed
  5. Click on +/- beside the object(Participant/visits/Specimen/CP) to expand/collapse the fields of object.
    Image Added

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.

Expand
Image RemovedImage Added



Example - On Enabling Wide Rows
Image RemovedImage Added

Example - On Disabling Wide Rows
Image RemovedImage Added

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

Expand
titleTo show the field names as column headers


Image RemovedImage Added

On enabling 'Display Field Names'

Image RemovedImage Added

Default: Disabled 'Display Field Names'

Image RemovedImage Added


Case Sensitive Search

...

Image Removed
Expand
titleTo configure case sensitive search...


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

Example - Case Sensitive Search disabled on first name

...

Expand
titleTo save query...
  1. Click on 'Actions' button
  2. Select option 'Save'.
  3. Enter the query title and click on 'Save' button.

This will save the query along with the results view.
Image Modified

Export Query Results

...