Training video
Features
| Features | Description |
|---|---|
| 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 | Save query so that can be reused for later use. |
| Folders and sharing | Saved queries can be organised 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 |
| Privileges | 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. |
| Data export (CSV) | Data from the query results view can be exported as CSV file. |
| Custom fields and forms | The custom forms and field added via form builder is available for querying the reports. |
| Calculated fields | Difference between two dates (e.g. age at 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. |
| Dashboards | Create visually appealing dashboards with graphs and numeric counters based on query results. |