Versions Compared

Key

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

...

Expand
  1. By default Super and Institute Admins have access to query

  2. Users with the role of Create, Update, Delete, Import, Export Query privileges can access the Query.

  1. PHI data of the participant is hidden/shown based on the role privilege.

Refer to the wiki page for more information on Roles and Privileges.

Creating Queries

  1. Navigate to Queries from the widget or navigation menu.

...

  1. Click on +Create

Fields description

Expand
titleClick here to view fields description

Field

Description

Select a Collection Protocol

Helps to search through a Collection Protocol/Collection Protocol Group.

If none is selected, search is done across all collection protocols.

Info

For flexibility and reusability of queries, When a saved query is used in other areas like ‘Catalog' or 'Sub-query’, the CP/CPG selected in this option is not carried over.

Add Filter

Used to create queries based on calculations(Temporal Queries). Refer to the wiki page for more details.

Collection Protocol

Helps to search based on fields of Collection Protocol. E.g., Coordinator, sites, etc,.

Participant

Helps to search based on fields/forms of participants, e.g., gender, name, date of birth, race, etc.,

Visits

Helps to search based on fields/form of visits, e.g., name, status, event code/label, etc,.

Specimens

Helps to search based on fields/forms of specimens, lineage, type, etc,.

Specimen Kits

Helps to search based on fields of kits, e.g., receiving/sending site, specimen label, etc,.

...