Filters, Creating a New

Step 1

Select a field to filter on. Click on “<Click here to add new condition>” and you will see a drop down list of all the tables associated with this grid. Next, click on the table you want from this list and you will see a list of all the fields for the selected table. Finally, click on the field you want to filter on and the field will be displayed in the Query Selection form after the condition number.

Step 2

Select an operator. The operator will usually default to “is equal to” which you want in most cases. But, if not, click on the condition operator and you will see a drop down list of all possible operators associated with this field. Finally, click on the operator you want to use with the field.

Step 3

Select a condition. Once you’ve selected the field and operator, you will see a blank condition associated with the field. So, click on the condition and enter the condition value.

Step 4

Repeat steps 1 to 3 for any more conditions, then click Ok to apply the query to your grid.

Step 1

Click on the number bubble for a drop down list of your options for this condition.

Step 2

Click “Delete row”.