Version 2 (modified by 11 years ago) ( diff ) | ,
---|
CaTissue search functions
Use cases
- Search for 'missing' aliquot data. Specifically, search for all specimen under a range of participant IDs where the specimen place holder isn't populated:
*Simple search:
- Specimen Collection Group / Protocol Participant Identifier STARTS WITH "9" ("9" is first character of all Northampton lab IDs)
- Specimen / Label IS NULL (NULL indicates the label doesn't exist, which is a mandatory field so this searches for missing data only)
- For GENVASC, which participants have two aliquots of buffycoat, and which have one?
- Advanced search:
- Collection Protocol / Short title EQUALS "GENVASC"
- LINK TO
- Collection Protocol Registration / Protocol Participant Identifer IS NOT NULL
- LINK TO
- Specimen / Label IS NOT NULL
- Specimen / Lineage EQUALS "Aliquot"
- Specimen / Specimen Type IN Cryopreserved Cells
- Collection Protocol / Short title EQUALS "GENVASC"
- Advanced search:
Note:
See TracWiki
for help on using the wiki.