Filtering Data Tables

All tables in the 340B application can be filtered using one or more columns to make the data displayed more manageable.

Filtering example - Univerity-affiliated Radiology clinics with a participation date later than January 1, 2014

filtering text columns 

  1. Type the text to be used as a filter in the text box below the column heading.

  2. Click on the filter icon (Image of Filter Icon) and select one of the following options from the drop-down:
    • Default – Clear existing text and redisplay results. Use this option to reset the results after filtering the data.
    • Contains – Display only results that contain the filter text.
    • Starts With – Display only results that start with the filter text.
    • Ends With – Display only results that end with the filter text.
    • = – Display only results that exactly match the filter text.
    • <> – Display only results that do not match the filter text.
  3. The filtered table will show only those records with text that matches the filter.

filtering date columns

  1. Click the funnel-shaped filter icon (Image of Filter Icon) to apply a filter to the date column.
  2. The System will display the list of dates (grouped by year, then month, and then date) that are available for the records in the results set. You can directly check the years, months, and dates that you would like to filter the results on.

  3. The table will show only those records with dates that match the filter.