Templates

OpenSpecimen

Overview
Space shortcuts
BlogsYouTube ChannelQ & A Forums
Pages
User Manual (Community Edition)
Configuration Settings
•
Getting Started
Administrative setup
Biospecimen data entry
Specimen Distribution
Reporting
Sample queries
•
Consent based queries
•
Matched samples query
•
Query across multiple CPs
•
Query based on distributed samples
•
Query based on multiple time points
•
Query for participants registered to multiple CPs
•
Search based on MRNs
•
Search based on time difference
•
Search for DNA/RNA
•
Search for Tissue Slides
•
Summary reports (Pivot table)
•
What is "aliquot sequence" field?
•
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
•
Search for samples that are not reserved
•
Hierarchical query for child samples based on conditions of parent specimens
•
Filter by Total Aliquot Quantity (v8.0)
•
Query for dropdown values used across CPs
•
Search for participants where no specimens are collected
•
Searching Container using Barcode
•
Query Privilege (v6.3)
•
Aggregate (Counts) Queries
•
Calculated fields (Temporal Queries)
•
Import/Export query definitions
Parameterizing queries
Query Results view
•
Share queries
•
Scheduling Queries
•
How to remove queries from folders?
•
Dashboard changes using query
•
Updating Catalog Query
•
Hierarchical Queries
Specimen Cart
Shipments
Others
Forms
User Manual (Enterprise Edition)
Bulk Operations (CSV Import)
Paid Plugins
Release Notes
Deployment
E-Learning Module
And others...
Mobile App Overview (v2 version)
  1. OpenSpecimen
  2. User Manual (Community Edition)
  3. Reporting
restrictions.empty

Sample queries

Created by Srikanth Adiga
Last updated: Dec 21, 2021 by Divya Prabhu

  • Consent based queries
  • Matched samples query
  • Query across multiple CPs
  • Query based on distributed samples
  • Query based on multiple time points
  • Query for participants registered to multiple CPs
  • Search based on MRNs
  • Search based on time difference
  • Search for DNA/RNA
  • Search for Tissue Slides
  • Summary reports (Pivot table)
  • What is "aliquot sequence" field?
  • 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
  • Search for samples that are not reserved
  • Hierarchical query for child samples based on conditions of parent specimens
  • Filter by Total Aliquot Quantity (v8.0)
  • Query for dropdown values used across CPs
  • Search for participants where no specimens are collected
  • Searching Container using Barcode

  1. 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 \\
  2. Usage of backslash in 'Equals, Not Equals, Is One Of, and Is Not One Of' is not supported.
{"serverDuration": 30, "requestCorrelationId": "5a5137dd89e1f7c4"}