Defining filter criteria using Condition Builder

You can use the Condition Builder to build filter conditions. For example, the condition builder is available from the Filter tab when you create a report or personalize a list.

The Condition Builder has three columns. You can add more than one condition on the Condition Builder. If you select All, all the conditions must be met. If you select Any, any one of the conditions must be met.

To build filter criteria:

In the left column, select field that you want to assign a condition to. For example, if you want to select job applications for HR organization 1000, select HROrganization.
In the middle column, select the condition operator, for example, Equal to.
In the right column, click the Literal checkbox and type a value. In this case, 1000. You could also select another field here.
To add another condition, click Build Another.
If applicable, add another condition in the second row. For example, if you want only candidates for job requisition 5, you can select JobRequisition, is equal to 5
Continue building your conditions until you are done.

Note: To remove a condition from the Condition Builder, click the delete icon next to the condition.
When you are done with your conditions, click OK. All the conditions you defined are added in the instance selection box separated by "and" or "or" (depending on whether you selected All or Any).
To remove a condition, delete it from the text box. You can also edit a condition within the text.
To add more conditions, click the Builder button, enter your conditions, and click OK.

When you click OK, the system asks you whether you want to replace the existing conditions with these conditions, or whether you want to append the conditions to the existing conditions. If you select Append, the conditions are added at the end of the other conditions.