|Create new queries|
Create queries based on fields across standard, custom forms, and fields with complex expressions (AND, OR, NOT, intersection, hierarchical and parenthesis)
See: Sample queries
|Get counts (pivot tables)|
Run the queries to get the count of participants and specimens that match the filters.
|Get raw data|
Run queries to get raw data from the system.
See: Query Results view
|Save query so that can be reused for later use.|
|Folders and sharing|
Saved queries can be organized in folders and shared with other users. E.g. 2-3 users are working on shortlisting specimens for a project can share the same set of queries.
See: Share queries
Data is filtered as per the user's privileges. E.g. if the user does not have PHI access, then the patient identifier fields will be hidden.
Access to the Query module can be controlled using the Query privilege.
|Data export (CSV)||Data from the query results view can be exported as a CSV file.|
|Custom fields and forms||The custom forms and field added via form builder is available for querying the reports.|
Difference between two dates (e.g. age at the collection, warm ischemia time, etc)
|Hierarchical queries||To support queries like, show any DNA aliquot whose parent specimen's "warm ischemia time" is less than x minutes.|
|Import and Export queries||One can import and export queries one instance to another. E.g. test server to production server.|
|Aggregate functions||Supports functions like sum, max, min, etc.|
Create visually appealing dashboards with graphs and numeric counters based on query results.