Using Filters to Limit Data Size

Workflow Manager 2019 / AdminStudio Enterprise Server 2019

When large amounts of information are available from your database, there are two quite similar approaches to reducing the amount of information shown in a list:

Searching—When you search for a particular value in the search field above the list, the contents of your list are replaced with the values that match your search. Often you'll be looking for one, or a few records.
Filtering—Filtering tends to be used to narrow down to a group of records. This section covers filtering.

You can use the search and filter controls in any combination you like.

Behind the scenes, there is just one filtering engine; but there are different ways you can control it, depending on how you prefer to work:

Types of Filters

Filter Type

Description

Using the Quick Filter Button

This extra button in the header row enables you to quickly filter the list by selecting one of the listed values.

Using the Header Filter

Using a header filter makes it easy to restrict the values in column you can see displayed. It constantly updates the list as you adjust the filter settings.

Of course, filters apply only to the list where you create them; and even if you navigate away to another page, they are still in place when you return, until you clear the filter.