= CaTissue search functions = Tags: [[CaTissue]] == 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 * For GENVASC, include comments (comments IS NOT NULL doesn't work as a search): * Advanced search: * Collection Protocol / Short title EQUALS "GENVASC" * LINK TO * Collection Protocol Registration / Protocol Participant Identifer IS NOT NULL * LINK TO * Specimen Collection Group / Comment CONTAINS "draw" (to include 'withdrawn', withdrawal, etc...) [[BackLinks]]