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

Error: Macro BackLinks(None) failed

'Environment' object has no attribute 'get_db_cnx'