Resource Centre - Smart Filter

Return to Resource Centre

Video Tutorial

The Smart Filter is a text based filtering tool that allows you to filter results by any keyword, partial word, number, or date displayed in the view. A Smart Filter search hides rows from the results screen that do not match the leading characters entered in the Smart Filter box. This is useful if you need to narrow down your results to view specific data.  The Smart Filter searches the entire grid to find any data that has the leading characters entered into the search then , displays data that starts with those leading characters.  The Smart filter also allows for the use of AND/OR conditions allowing for the combination of terms to be searched. This is described in more detail below.

Example: To narrow down the search results to display only items from the HHS can be done by typing HHS in the Smart Search box. Only rows that have the leading characters ‘HHS’ are displayed. Any row not containing HHS is filtered. 

a tip icon The Smart Filter feature is available in multiple modules and census lists. Clearing the data from the Smart Filter box will display all previously filtered.

Image of the smart filter results


Conditional Smart Filter

Conditional filter terms are a great tool you can use when using the smart filter. These are also known as AND/OR conditions. 


AND Condition


The AND condition is used if you want to only show rows of results that include two or more specific keywords. To use this condition, simply use a space to separate each keyword you want to include in your results. 

Example: You are looking for discharge summary transcriptions from Hamilton Health Sciences (HHS). To locate these transcription you would type dis HHS in the Smart Filter Search box.

Image showing how to use the and condition in smart filter

Only transcriptions that include text that start with both dis and hhs are displayed.


OR Condition


To display rows that include one or more keywords, simply use a comma to separate each keyword you want included in your search. 

Example: You want to view your patient’s results for all potassium or sodium labs. To locate these labs you would type potassium, sodium in the Smart Filter Search box.

Image showing how to use the or condition in the smart filter

Only lab results that include potassium or sodium keywords are displayed.


Combining AND and OR conditions


You can combine AND and OR conditions in a single Smart Filter search. For example; if you wanted to view just consultation and discharge transcriptions from the general facility, type dis, con gen in the Smart Filter box.

Image of combining AND and OR conditions in smart filter

Only Transcriptions with the keywords discharge and general or consultation and general are displayed.


Combining the Smart Filter with Other Filters and Sorting Functions

The Smart Filter can be used on its own or in combination with other filter and sorting functions. Depending on the patient information that you are trying to filter and the module, you may find that the other sorting and filter functions may narrow down the results you are looking for without having to use the Smart Filter. It is up to you to determine which options will best meet your clinical needs.

The following are some suggested practices when using the Smart Filter with other sorting/filtering functions.

1. Set the Encounters filter to All Regional Encounters. This is typically the default setting. 
This filter ensures that all available data from provincial repositories and from visits across all hospitals available in the portal are displayed in the module if available.

Image showing use of smart filter with encounters set to all regional encounters

 2. To narrow down the number of results displayed in the view, you can consider changing the Days Back filter to view a shorter duration.

Example: If you are looking for a Transcription from the past week or two you would set the filter to 30 to only display records from the past 30 days (just to be safe). All records entered past 30 days will be hidden from the Transcription list. 

Image showing the set back days drop down option

3. Sort by column

Image of the sort by column

Each column in your list view can be sorted in ascending or descending order. This example is showing the Transcription module columns.

Sort by Date

Results that contain a Date field (such as Date or Event Date) can be sorted from newest to oldest (and oldest to newest). Simply click the column header containing date information to sort by date. This sort preference can also be set in the module preferences, eliminating the need to click on the column header each time.

Sort by Name

Results that contain the name of the result or record (such as Test or Name) can be sorted to group common results. Simply click the column header containing the information you want grouped.

This makes it easy to go through your list view to find a specific result based on the name of the result. 

4.  Using the Smart Filter

If you would like to narrow your results even further, you may want to use the Smart Filter to add a keyword, as described in the previous steps.


Printing Filtered Results

You can print the filtered list view results by clicking the Print button  after entering Smart Filter keywords. 

See Printing for more information on how to print list and detail views.