How to use Filter?


ARKES can filter the report data based on a filter condition. The Filter criteria can be specified based on columns in the report to match certain values of the data.
 
You can apply a report filter condition by following the steps given below:
 
  1.  
Click Filter button in the toolbar available in the report window or press F3 to launch Filter window. Filter window will be displayed as shown below:

 
  1.  
In the Filter window, select any column from the Field dropdown. 
  1.  
Select any operator from the Operator dropdown.
  1.  
Select any value from the Value dropdown.
  1.  
Click Add to Filter button to add condition to the Filter list.
  1.  
The Add to Filter will change to AND to Filter. The OR to Filter button will be enabled. The selected condition will be set as a filter and displayed (as shown below).

 
  1.  
Use 'AND to Filter' and 'OR to Filter' , parenthesis (, ) etc., to build an enhanced filter condition as shown in the above figure  
  1.  
Click OK to apply the given filter settings and generate the filtered report output.
  1.  
Click Cancel to abort the filter action.
  1.  
The various operators available in ARKES are given below:

Operator

Applicable Data types

Description

Example

=

String, Numeric, Boolean, Date

Value of Column name matching exactly with the specified value data

[Display Name] = 'Administrator'

<>

String, Numeric, Boolean, Date

Value of Column name not matching exactly with the specified value data

[Display Name] <> 'Administrator'

>

Numeric, Date

Value of Column name greater than the specified value data

[Incoming message size (KB)] > 1024

>=

Numeric, Date

Value of Column name greater than or equal to the specified value data

[Outgoing message size (KB)] >= 1024

<

Numeric, Date

Value of Column name lesser than to the specified value data

[Issue warning at (KB)] < 5000

<=

Numeric, Date

Value of Column name lesser than or equal to the specified value data

[Prohibit send at (KB)] <= 3000

starts with

String

Value of Column name starts with the specified value data

[Member of] starts with 'Admin'

ends with

String

Value of Column name ends with the specified value data

[Member of] ends with 'Admins'

does not start with

String

Value of Column name does not start with the specified value data

[Member of] does not start with 'Domain'

does not end with

String

Value of Column name does not end with the specified value data

[Member of] does not end with 'Admins'

contains String Value of Column name contains specified value data Member of] contains 'A'
does not contains String Value of Column name does not contains specified value data Member of] does not contains 'A'

Is Null

String, Numeric, Boolean, Date

Value of Column name is null

[Alias Name] Is Null

Is Not Null

String, Numeric, Boolean, Date

Value of Column name is not null

[Alias Name] Is Not Null

The various operations that can be performed in the Filter window are given below:
 

Operation  Description
Add to Filter Click Add to Filter button to add a condition to filter list, if the filter list is empty.
AND to Filter Click AND to Filter button to add a condition with logical 'AND' operator to filter list.
OR to Filter Click OR to Filter button to add a condition with logical 'OR' operator to filter list.
Insert '(' Select any condition in the filter list and Click button to insert an open parenthesis at the start of the condition.
Insert ')' Select any condition in the filter list and Click button to insert a close parenthesis at the end of the condition.
Delete '(' Select any condition in the filter list and Click button to delete an existing open parenthesis in the selected condition.
Delete ')' Select any condition in the filter list and Click button to insert a existing close parenthesis in the selected condition.
Delete Condition Select any condition in the filter list and Click button to delete the selected condition.
Delete All Click button to delete all the conditions in the filter list.