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

  1. Type the text to be used as a filter in the text box below the column heading.
  2. Click the funnel-shaped filter icon (Image of Filter Icon) and select one of the following:
    • NoFilter – Clear existing text and redisplay results.
    • Contains – Display only results that contain the filter text.
    • EqualTo – Display only results that exactly match the filter text.
    • NotEqualTo – Display only results that do not match the filter text.
    • IsEmpty – Display only results where the column is empty.
    • NotIsEmpty – Display only results where the column is not empty.
  3. The filtered table will show only those records with text that matches the filter.

screen shot of text filtering example - Univerity-affiliated Radiology clinics

  1. Use the calendar widget to select the date.
  2. Click the funnel-shaped filter icon (Image of Filter Icon) and select one of the following:
    • NoFilter – Clear existing date and redisplay results.
    • EqualTo – Display only results that exactly match the filter date.
    • NotEqualTo – Display only results that do not match the filter date.
    • GreaterThan – Display only results with dates that are after the filter date.
    • LessThan – Display only results with dates that are before the filter date.

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

    screen shot of date filtering example - participation start dates greater than 10102014