Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com
Sample queries
- Consent based queries
- Matched samples query
- Query across multiple CPs
- Search based on MRNs
- Search based on time difference
- Search for DNA/RNA
- Summary reports (Pivot table)
- Upcoming visits query
- Reconsent for minors
- Query for specimens that are reserved, distributed or available
- Query for specimen events data
- Query for anticipated visits/specimens
- Query for searching available specimens in a container
- Query for searching not stored specimens
- Query for searching specimens that do not have child specimens
- Search for samples that are not reserved
- Hierarchical query for child samples based on conditions of parent specimens
- Filter by Total Aliquot Quantity
- Query for dropdown values used across CPs
- Search for participants where no specimens are collected
- Searching Container using Barcode
- Query based on distributed samples
- Querying for custom forms using CPG
- Display ancestor requirement name/code on child specimens
- How to query for collection and received details for child specimens?
- How to find N child specimens (sequence) from Query?
- Querying for Custom Forms/Fields associated with CP
- Query Checked-Out Specimens
- Count of patients having 0.5 & 1 ml plasma across time points
- Query for participants registered to multiple CPs
- Display date as year only in query results
- Cart Queries
- Visit Count by Visit Date per Collection Protocol
- Query for Tracking Shipment by Shipment Status
- How to find participants whose specimens belongs to 2 Carts
If there is a backslash in your PPIDs, Visit names, etc., and you want to use the 'Contains, Starts With, Ends With' operators to query, you need to use two backslashes. E.g., Participant >> PPID Contains \\
Usage of backslash in 'Equals, Not Equals, Is One Of, and Is Not One Of' is not supported.
Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com