= 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

* 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...)