Versions Compared

Key

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

Table of Contents

Note
titleNote:
  1. Users You can only query for their your own sites.
  2. If a user does you do not have access to a CP, the data (specimen/ visits/ participants) related to that CP, will not be visible for that userto 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.

...

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 Modified

Example - On Enabling Wide Rows
Image Modified

Example - On Disabling Wide Rows
Image Modified

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


On enabling 'Display Field Names'

Default: Disabled 'Display Field Names'


...

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

...