Queries

From HSDB Wiki
Jump to: navigation, search

Demo QI queries[edit]

  • qid=222 Query over all sources listed in the source register for studies in which at least one of the interventions administered is an antibiotic of the macrolide class. The query first issues template query qid=221 to SNOMED on BioPortal with the code for macrolide as argument. Such query returns the list of SNOMED codes of macrolide and all its children, which are then used in the original query to search the studies in the register. The query returns the study in the register (HIVNET024) in which one of the interventions is erythromycin, a macrolide.
  • qid=224 Query over all sources listed in the source register for studies in which at least one of the outcomes - either primary or secondary - is "HIV infection" (SNOMED code 86406008). The query returns 3 studies in the register.
  • qid=163 Query over all sources listed in the source register for studies whose design is one of the interventional study designs defined in OCRe. The query first issues template query qid=164 to OCRe to retrieve all the subclasses of "Interventional study design" which are then used in the original query to search the studies in the register. The query returns 3 studies with "Parallel group study design" a type of Interventional study design.
  • qid=263 Query over all sources listed in the source register, find all of those whose study design is "Parallel group study design" or "Crossover study design" (or a subclass thereof) according to OCRe, that have less than 2 arms (one arm can be the placebo or usual care arm). The query first issues template query qid=226 to OCRe to retrieve all the subclasses of "Parallel group study design" and "Crossover study design" which are then used in the original query to search the studies in the register. This is a logical curation task on interventional studies submitted to ClinicalTrials.gov the first 6 weeks of 2012. ClinicalTrials.gov XML files have been (partially) transformed into HSDB XML.
  • qid=265 Query over all sources listed in the source register, find all of those whose Allocation type is "Random allocation" or one of its subclasses in OCRe but whose arm count is less than 2. The query first issues template query qid=226 to OCRe to retrieve all the subclasses of "Allocation type" which are then used in the original query to search the studies in the register. This is a logical curation task on interventional studies submitted to ClinicalTrials.gov the first 6 weeks of 2012. ClinicalTrials.gov XML files have been (partially) transformed into HSDB XML.
  • qid=268 Query over all sources listed in the HSDB source register, find all of those whose Allocation type is "Random allocation" or one of its subclass in OCRe and whose study design is not one of parallel group, crossover, or n-of-1 (or a subclass thereof). The query first issues template query qid=226 to OCRe to retrieve all the subclasses of "Allocation type" and then again the subclasses of the specified study design; the information is then used in the original query to search the studies in the register. This is a logical curation task on interventional studies submitted to ClinicalTrials.gov the first 6 weeks of 2012. ClinicalTrials.gov XML files have been (partially) transformed into HSDB XML.