Summary

Filters enable you to view a specific group of records in a grid. You can filter records by single fields or by a combination of fields.

Important: You cannot use Save Layout to save filters.

Apply a filter

Grid column headers display Filter drop-down buttons only when you place your mouse pointer over the header.

This example filters employee records by location.

1. In the Employees grid, place your mouse pointer on the Location Code column header.
2. Click the Location Code drop-down button.

   A list of the Location Code values that are used in the grid appears.

3. Click the checkbox for the required Location Code, such as 02.

   Note: You can select multiple options in the filter list.

   The Employees grid now displays only employees with Location Code = 02. The grid uses the following indicators to show that you have applied a filter:

   • The filter drop-down arrow in the Location Code column header changes from black to blue to indicate that this column is filtered.
   • The Active Filter Bar at the bottom of the grid displays filter information.

   

4. In the Active Filter Bar, click the cross button to clear the filter without saving it.

Active Filter Bar

When you apply a filter, the Active Filter Bar at the bottom of the grid or area contains the following buttons:

Cross
Clear the filter without saving it.

Tick checkbox
Click the ticked checkbox to clear the filter and save it for later use in this session. Click the blank checkbox to reapply the filter.

Drop-down
Available only after you save a filter by clicking the ticked checkbox. Displays a list of filters saved in this session that you can select to apply.

Customize
Displays the Filter builder form that allows you to edit the filter.

Custom Filter

When you click "(Custom...)" in the Filter drop-down list, the Custom Filter form appears. This example creates a filter to view only employees who have an annualised salary between $100,000.00 and $150,000.00 (inclusive).

1. In the Employees grid, place your mouse pointer on the Annualised Salary column header.
2. Click the Annualised Salary drop-down button.
3. Click Custom.

   The Custom Filter form appears.

4. In the first field, select is greater than or equal to.
5. In the associated text field, enter 100000.00.
6. Click the AND option.
7. In the second field, select is less than or equal to.
8. In the associated text field, enter 150000.00.
9. Click OK.

The Employees grid now displays only employees who have annualised salary between $100,000.00 and $150,000.00 (inclusive).

When you create a Custom Filter for a non-numeric field, the drop-down options include "like" and "not like". You can use the following wildcard characters with these options:

• Underscore (_) to wildcard a single character. For example, SALES_ would display records for SALES1 and SALES2.
• Percentage sign (%) to wildcard a series of characters. For example, SALES% would display records for SALES1, SALES2, SALESMGR and SALESHELP.

Apply multiple filters

You can use multiple filters to select a very specific group of employees. Based on the previous examples, you could apply the Location Code filter and the Annualised Salary custom filter to display only employees in location 02 whose annualised salary is between $100,000.00 and $150,000.00.

Save Custom Filter

You can save custom filters. This example shows how to save the custom filter created in the previous example.

1. Click the Customize button in the Active Filter Bar.

   The Filter builder form appears.

2. Click Save As.
3. Navigate to the folder you want to save the filter in.
4. Enter an appropriate File name, such as "EmpGridAnnSal100-150.flt".
5. Click Save.
6. In the Filter builder form, click OK.

Open saved Custom Filter

You can open saved custom filter. This example show how to open the EmpGridAnnSal100-150.flt saved in the previous example.

1. In the Filter builder form, click Open.
2. Navigate to the folder that EmpGridAnnSal100-150.flt was saved in.
3. Double-click EmpGridAnnSal100-150.flt to load it.
4. Click OK to apply the filter.

You can also edit and save your filter.

Filter builder

The Filter builder form contains the following features:

Filter
Click this button to display the following options:

• Add Condition - Add a condition to the first level of the list.
• Add Group - Add a lower level of conditions with a separate relationship.
• Clear All - Clear all conditions from the filter.

AND, OR, NOT AND, NOT OR
Defines the relationship between conditions on the same level.

...
Click this button to display the following options:

• Add Condition
• Add Group
• Remove Row - Remove the condition on this row and any lower level conditions associated with this row.

(Field)
Click this part of the condition to see a list of fields currently displayed in the grid or window.

(Operator)
Click this part of the condition to see a list operators that now include "in", "not in", "between", and "not between".

(Value)
Click this part of the condition to enter a value.

press the button to add a new condition
Click this button to add a condition to the end of the list. The level of the new condition is determined by the level of the last condition in the list.

Open
Open a saved filter (*.flt).

Save As
Save the current filter.

Note: You cannot save filters in hosted environments, such as PayGlobal Online Services.

OK
Apply the current filter and close the filter builder.

Cancel
Close the filter builder without saving any changes.

Apply
Apply the current filter.