Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Image Removed

  • Queries allow users to gather statistics regarding the population in Revolution
    • This function could help users with recruitment as it can select for potential participants who fit in study-specified criteria
  • The categories by which you can select for individuals include categorical values and continuous values, which are further specified below

    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!


    Run Query

    Use the 'Search Filters' to specify the target sample you are searching for:

    • 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 




    Image Added

    Image Removed

    • 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


    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.