Filter

Click the name of the browser filter on the Filter list page and then select Edit to view or edit filter information in the Filter details page. See "Adding or Editing Data Browser Filter Details" below.

Click the name of the browser filter on the Filter list page and then select Select to select this filter for use on the previous page.

Filter by patient results. This is selected by default.

When Patient Results is cleared, the browser will not show any results for patients.

Filter by QC results.

When QC Results is cleared, the browser will not show any results for QC lots.

Use the settings in the Data Browser Query section to trigger comparisons between column values (e.g., Order Choice Abbreviation, Collection Location, or Result) and a specified value.

Select an option in the list and click the Arrow button or double click an option to add the column to the Query Criteria list. Continue adding columns to the query, if desired. For a full list of data browser filter options, see Data Browsers.

For example, you may define a query that lists all patient results with a collection date greater than 9/1/08 and with an ordering provider name containing "Smith." If a user adds a supported Column to Compare (left side) list value to the Query Criteria (right side) list.

Click the button next to the time and date fields to update the fields to the current date and time, if desired.

If you select a column that pertains to a date or time, the system displays the date and time fields in the format MM/DD/YYYY, HH:MM AM/PM, along with some additional buttons.

Enter the date/time, or you may select a date from the calendar view by clicking the calendar icon located next to the fields.

Click to have the system enter the #Current Date# placeholder.

When you run the data browser, the system will automatically fill in the appropriate date value for the report.

If you have clicked Current, you may click Date to return to the full set of date/time fields.

If you select a column that pertains to a user, the system displays a Current button. Click this button to have the system enter the #Current User# placeholder. When the system runs the data browser, it will automatically fill in the appropriate user value for the report.

If you have selected User-defined Field in the Column to Compare list, the Question button will appear in the Column column. Click the button to open the Set User-defined Field pop-up, where you can select the user-defined field to query.

Select an option from the drop-down list to select how to compare the values.

Select either Is Equal To, Is Not Equal To, Contained In List, Is Not Contained In List, Contains, Does Not Contain, or Is Empty from the drop-down list.

Enter or select the Value against which your system is comparing the selected column's value. When creating the data browser report, your system will only display those entries that qualify. For example, if you select Is less than or equal to and enter "45," your system will only display those entries where the value in the selected column is less than or equal to 45.

• For the ABN Status, Result Status, Order Choice Status, Order Choice Billing Status, Order Status, and Order Fasting columns, your system displays the possible values in the Value column. Select the appropriate value from the drop-down list.
• For the Patient Age column, your system displays a years field, a months field, and a days field. Enter the appropriate values into the fields.
• If the selected column will have a date value, the greater than/less than/equals/etc. option is available. If you select Is Less Than, Is Less Than Or Equal To, Is Greater Than, or Is Greater Than Or Equal To, enter date and time values in the blank fields next to the option.
• If the selected column will have a date value, the Is Empty or Is Not Empty options are also available. 
• If the selected column will have a text value, does/does not contain, is/is not equal, and contained/is not contained in list options are available. Select an option and proceed as follows: If you select Contains or Does not contain, enter a value in the blank field next to the option. If you select Is Equal To or Is Not Equal To, enter a value in the blank field next to the option or select the value from a drop-down list. If you select Contained in list or Not contained in list, enter the valid values for the list, separated by commas.

Click the button in the Delete column. Your system immediately removes the query from the list.

For example, to find tests with certain words or phrases in the result, but with words or phrases that are different for each test, you could create the following series of queries:

• ((Test Abbreviation contains WBC) AND
• (Result contained in list: High,Low)) OR
• ((Test Abbreviation contains RBC) AND
• (Result contained in list: Critical, Abnormal))

Select the checkbox to have your system allow rows to be displayed where the record does not have a related result record. The Empty results checkbox will be unchecked by default, which allows rows to be displayed only if a related result record is found.

This change applies to the following data browser columns: Test Name, Order Choice Code, Test Abbreviation, Result, Reference Range, Units, Result Status, Result Comments, Result Numeric, Result Text, Result Severity, Result Testing Location Code, and Test Additional Info. This change also applies when using the Data Browser's Tests options to filter on Selected Tests or All Tests Except… as well as the Apply Date and/or Time Range option when Received Date/Time or Approved Date/Time is also selected. Test Name, Test Abbreviation, Order Choice Name, and Order Choice Abbreviation columns display a magnifying glass next to the Value field while editing a data browser filter. Clicking the magnifying glass displays a pop-up search where a test or order choice may be selected, and the value in the highlighted query criteria field will be replaced.

• Select an option in the Column to Sort list and click the Arrow button or double-click an option to add the column to the Query Sorting list. Continue adding columns to the sort order, if desired. For a full list of data browser filter options, see Data Browsers.
• The system sorts the data browser report in the order columns are listed here. Click the Arrow buttons in the Sort column to rearrange the order of the columns.
• Select an option from the ASC/DESC drop-down list for each column to set whether your system sorts the data in that column in ascending (ASC) or descending (DESC) order (alphabetically or numerically). Select either ASC, DESC, ASC (Date Only), or DESC (Date Only) from the drop-down list. Select ASC (Date Only) or DESC (Date Only) from the drop-down list to sort the Selected Date column by the date without sorting by the time.
• To remove a column from the sort order, click the X button in the Delete column. The system immediately removes the column from the list.

Click the name of the collection list filter on the Filter list page and then select Edit to view or edit filter information in the Filter details page. See "Adding or Editing Collection List Filter Details" below.

Click the name of the collection list filter on the Filter list page and then select Select to select this filter for use on the previous page.

• Select an option in the Column to Compare list and click the Arrow button or double-click an option to add the column to the Query Criteria list. Continue adding columns to the query, if desired.
• If you select a column that pertains to a user, your system displays a Current button. Click this button to have your system enter the #CurrentUser# placeholder. When your system creates the collection list, it will automatically fill in the appropriate user value for the report.

Enter or select the Value against which your system is comparing the selected column's value. When creating the collection list, your system will only display those entries that qualify.

If the selected column will have a text value, does/does not contain, is/is not equal, and contained/is not contained in list options are available. Select an option and proceed as follows: If you select Contains or Does not contain, enter a value in the blank field next to the option.

If you select Is Equal To or Is Not Equal To, enter a value in the blank field next to the option or select the value from a drop-down list. If you select Contained in list or Not contained in list, enter the valid values for the list, separated by commas.

Select the appropriate options from the (, ), and AND/OR columns to build sophisticated queries using AND/OR logic. By default, all new queries use AND logic, which means that all of the queries must be true in order to pass the filter.

The system evaluates the queries using standard mathematical operator precedence (evaluates items in parentheses first, then evaluates from left to right). You may use zero to five sets of parentheses.

• Select an option in the Column to Sort list and click the Arrow button or double click an option to add the column to the Query Sorting list. Continue adding columns to the sort order, if desired.
• The system sorts the collection list in the order columns are listed here. Click the Arrow buttons in the Sort column to rearrange the order of the columns.
• Select an option from the ASC/DESC drop-down list for each column to set whether your system sorts the data in that column in ascending (ASC) or descending (DESC) order (alphabetically or numerically).
• To remove a column from the sort order, click X in the Delete column. The system immediately removes the column from the list.