To find these patients, build two separate filters (one for Lupus, and a separate one for Diabetes). Start with an initial Diagnosis filter including Lupus.

Build an additional Data Source (Diagnosis) by returning to the main filter list. Click Diagnoses, enter Diabetes into the Diagnosis code field, and click Add Selected to create new, separate criteria.

After specifying the details (refining your ICD9 codes if desired), click Add.

The additional required criteria appear as a separate criteria box in the right hand panel, and the narrowed query results show a far more limited population of patients – only those patients who possess BOTH of the listed diagnosis codes (710 and 250).

Each of the displayed criteria boxes in the right-hand panel represents an “AND”statement – in other words, all retrieved patients must possess ALL of these criteria:

Tip: Each time that you click Add, you are adding a new criteria panel (an ‘AND’ statement to the query).

Continue to build and refine your query using Data Sources on the left-hand panel. Refer to the instructions inside each filter panel to determine the source and details for the information available.

If you wish to retrieve data related to Laboratory collections, you may select details for Ordered and well as Resulted Laboratory tests.

When you select Laboratory Results data, you may “include” or “exclude" results within specific value ranges.

Note, specifying a value range only works for lab values that are numeric (as opposed to “pos,” “neg”)

For each filter you wish to add, click Add to save it to your query.

In addition to the Procedures, Outpatient Medications, Medication Administration (the MAR), and Laboratory filters, you may select Waveform data for specific dates, from specific UMHS units, including duration details.

Central Biorepository sample data is also available to be added as criteria to your query including Age at Date of Collection, Study, Sample Type, and Tissue Type.

Again, be sure to click Add for any criteria details you would like to include in your query.