Use the graphic data selector¶

GMrepo is equipped with two graphical data selectors to allow users to quickly build complex queries to find projects and runs of interests; see below:

The selectors are a bit difficult to start with, so we provided six examples. Users can click one of the links Examples: #1, #2, #3 above the selectors to view:

the purpose of the search, e.g., "get runs from healthy people with healthy BMIs",
the selector setup, and
query logic in SQL command string: "disease = 'D006262' AND BMI BETWEEN 18.5 AND 24.9".

Build complex queries using the data selector¶

It is very easy to use the data selectors. There are three basic logics to build an efficient query:

AND,
OR, and
GROUP to modify the orders of the logics.

For example, to search for samples that were taken from healthy individuals that are either American or British, we need to:

a. first build a group logic using the ADD GROUP button that defines the target population;
b. then add two rules using the ADD RULE button that set Country to United States of America OR United Kingdom;
- note the logic between two rules on the Country is OR!
c. then add a new rule paralelle to the above group, and use it to select Phenotype as Health
- note the logic between the Phenotype and the Country group is AND!.