Filters

By default, the grid displays all current employees, but you can limit the number of employees by applying a filter (or query) to the employee list.

The following example explains how to view only female employees in the Development Department.

1. Click the Show filter link to open the filter options.
2. In the Field combo box, select Gender.
3. In the Function combo box, select is equal to.
4. In the Parameter 1 text field, type Female.
5. Click the Add clause button.

   You have completed the Gender is equal to ‘Female’ clause. The grid refreshes and displays only female employees.

   Note: If you wanted to delete the clause, then you would click the Delete icon .

6. In the Field combo box, select Department code.
7. In the Function combo box, select is equal to.
8. In the Parameter 1 text field, type the department code, such as 04.

   Note: If you do not know the department codes in your database, then the next section shows you how to add the Department code and Department description columns.

9. Click the Add clause button.

   You have completed the Department is equal to ‘04’ clause. The grid refreshes and displays only 2 of the original 16 employees.

   

10. Click Save (in the top-right corner) so you can use the filter again.

    The Save filter box appears.

11. In the Save as field, type Female Developers.
12. Click Save query.

    The next time you want to apply a filter that you have saved, click Load. This link displays a list of your saved queries.

13. Click Delete all to see all your employees again.
14. Click Hide filter to hide the filter details.

    Note: You can hide the filter details while a filter is activated and then click the Show filter link to open the filter details again.

Topic: 28289