Queries Search is a bulk search when find a list of participants that meet specific criteria. Any user that has access to the Revolution Database can run a query. The user that generated their query export is responsible for their file!
- Categorical Values have options that can be seen and selected for by clicking the three lines (
) to the right of each option (highlighted with a purple arrow) - These values include:
- Future Contact (whether they would like to be contacted in the future by the lab)
- Household Status
- Biological Relationship (to household status, "Self" participant)
- Sex
- Pregnancy
- Race
- Ethnicity
- Marital Status
- Education Level
- Public Assistance
- Health Condition
- Preferred Contact Method
- Preferred Contact Time
- Preferred Contact Day
- Continuous values have options that exist along a gradient, and therefore, can be selected using a moving marker along a bar, or typing in your specifications
- Age
- Please note that when selecting an age, you must either choose "Age," in years (shown at the top of the left-most image) or "Age (in Months)" (shown at the bottom of the left-most image)
- BMI
- zBMI
- BMI percentile
- Age
Export
Data that rendered using Queries Search are able to export as spreadsheet.
- To export data, user can use Search Filters to filter the information and also able to customize what data to be display or export using Customize Output.
- Once the data are rendered, the "Export as Spreadsheet" button will appear right under Customize Output for user to export the data in a spreadsheet.
- Users are responsible to password protected the export file since data include PHI.
