Filters

Server Side

Server side filtering is enabled by checking the Filter (Server-Side) check box. When this check box is checked the server side filtering controls will become enabled. The first drop down selects the column on whose values to filter. The second drop down selects the operation to perform on the values. The last text box is used to input the operand to filter against. The column drop down will not be populated with values until at least one refresh is done on the panel. Server side filters are positive; the server will only return the rows that PASS the filter.

Server side filters share the same operations as client side filters, operations are described below.

Client Side

In order to do client side filtering you must first open the trigger and filter tool by click its open button

The Filter Tool

The table is used to apply the filters. By clicking the check box under the Main column you enable/disable that filter on the main table. By clicking the check box under the History column you enable/disable that filter on the history table.

Filter Creation and Editing

Clicking the new filter button or selecting a filter and clicking the edit filter button will open the filter editing tool (above).

You can specify the name of your filter in the Name text field.
When building your operation the first drop down selects the column on whose values to filter. The second drop down selects the operation to perform on the values. The last text box is used to input the operand to filter against. The column drop down will not be populated with values until at least one refresh is done on the panel. Client side filters are positive; the server will only return the rows that PASS the filter.

Client side filters share the same operations as client side filters, operations are described below.

Operations

Operation Operand Type Description
== String or numerical Equals - Checks if the value is equal to the operand
!= String or numerical Does not equal - Opposite of equals
contains String or numerical (treats number as a string) Contains - Checks if the value contains the operand
not contains String or numerical (treats number as a string) Does not contain - Opposite of contains
starts with String or numerical (treats number as a string) Starts with - Checks if the value starts with the operand
not starts with String or numerical (treats number as a string) Does not start with - Opposite of starts with
> Numerical Greater than - Checks if the value is greater than the operand
>= Numerical Greater than or equals - Checks if the value if greater than or equal to the operand
< Numerical Less than - Checks if the value is less than the operand
<= Numerical Less than or equals - Checks if the value is less than or equal to the operand