Leave a comment at the end of this page or email contact@krishagni.com
Query Results view
Note:
- You can only query for your own sites.
- 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.
Query Actions
The below operations can be performed on the query using the "Actions" button:
- Edit
- Save
- Columns
- Rerun
- Export
Configure Columns
The fields or the order of the fields to be displayed on the query results page can be configured.
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.
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
Case Sensitive Search
From v6.3, there is an option to choose whether the search should be case sensitive. By default, all queries are run in case sensitive mode.
Configure display names for column headers
From v5.1, you can configure the header names for the columns in the query results page and the Exported CSV.
This feature can also be used in conjunction with the "Scheduled Query" feature. Once renamed and saved, the automated exported CSVs will contain the custom header names. This can be used to import into external databases. E.g. importing into a data warehouse.
Save query
A query can be saved for future reuse OR sharing with other users.
Export Query Results
You can export the query results as a CSV file, click on the 'Actions' button, and select option 'Export' to export query results
Select rows in query for operations
Users can select the rows from the query result and perform the action specified in below 'Specimen Operation' section.
Row count:
Display the count of row selected feature is implemented in v7.1. Check the highlighted in the below screenshot.
Specimen Operations
You can perform any specimens operation listed by selecting specimens in bulk.
- Edit
- Delete
- Close
- Distribute
- Reserve
- Ship
- Create Aliquots
- Create Derivatives
- Add/ Edit event
- Transfer
- Retrieve
Add Specimens to Cart
A Cart is a picklist of specimens. For more details: Specimen Cart.
You can add specimens from the results view to a new cart or existing cart.
Creating New Dashlets
Dashlets are items displays on a dashboard. You can create dashlets from the query results view. Refer 'Dashboard changes using query' for more details.
Leave a comment at the end of this page or email contact@krishagni.com