Advanced Filter
Advanced Filter tool allows you to filter report data based on compound and complex filter conditions. Unlike Quick Filter, Advanced Filter gives the user the ability to create filter conditions that include one or more fields in the report and is also capable of reporting fields with empty values in the report.
ARKIIS allows for complete filter management for advanced filters. You can create new filters, edit existing ones to suit your needs and delete unwanted filters.
The Advanced Filter tool is available just below the report grid in the right pane as shown below:

To apply a filter to the current report, select the filter from the Advanced Filters drop-down and click on  button.

To remove a filter applied to the current report, select No Filter applied from the Advanced Filters drop-down and click on  button.

Create a new filter
Click on  to create a new advanced filter for the current report

The Filter dialog will be displayed.

To set a filter condition, follow these steps.
1. Click (Clear All) button and clear the filter.
2. Choose a field name, an operator and a possible value from the respective dropdown options.
3. Click Add to Filter button.
4.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).

5.Click Ok to apply the filter.

Use the   to customize the fields.
  • Use the , and to build enhanced filter condition as shown below:
  • (Field A = Value 1 AND Field B = Value 2) OR (Field C = Value 3 AND Field D = Value 4)
  • Use   to remove the parenthesis.

  • Use delete a selected condition.

    The title bar indicate the Filter applied/not applied whether the current data is filtered or not.

Edit an existing filter

To edit an existing saved filter, select the filter from the advanced filters drop-down list, and then click on  button. The filter window will appear on the screen. You may edit the fields-list and filter conditions. Also, you can choose to save the filter in a different name, retaining the original filter, or overwrite the existing filter with the new filter conditions and fields-list.

You can also edit the built-in filters provided in the application. However, once you overwrite a built-in filter with a new fields-list and/or filter conditions, you will loose the original built-in filter. So, it is advisable to save the modified built-in filter to a different name, which will allow you to retain the original filter and have a customized version of the filter that suits your needs.
Delete an existing filter
To delete an existing filter, select the filter from the advanced filters drop-down list and click on  button.  

However, if the filter, that you had deleted, had been applied to a report, ARKIIS removes the filter from being applied to that report, and then deletes the selected filter.

Built-in filters provided by ARKIIS cannot be deleted.