- Admin Console User Guide
- System Configuration
- Reports For Download
- Editing Report Attributes/Columns
- Creating Attribute Filters for Reports
Creating Attribute Filters for Reports
Filters allow you to include a specific set of data in the report using defined expressions.
You can define a filter expression for specific column(s) during
report generation.
To create a filter condition:
- Click Filter in the Report Details
page.The Filter Condition to include the required filters is displayed.
- On the Filter Condition page, enter the following
details:
- Select Column - Select a column from
the drop-down list for which you want to set a filter condition.
To search for a specific column name, type a few letters from the column name in the Select Column text box and press Enter.
- Conditions – Select one of the
following comparison operators to filter the data for the selected
column.
- Comparison - '=', '!=', '< >', '>', '<', >=, <=,'IN', 'NOT IN', 'ANY', 'BETWEEN', 'LIKE', 'IS NULL', and 'IS NOT NULL'.
- Value - Enter the condition value to
filter the data and generate the report.
For Date column, select the date using the calendar.
- Type - Select one of the following
filter types:
- Static - Select Static to enter a value and execute the filter using only one value. You cannot change the value at a later point.
- Dynamic - Select
Dynamic to change the filter value
when needed.
After setting the filter type to Dynamic, select the Placeholder and set one of the default seeded values to process the filter.
Note:
Only values that are already seeded in the database table are displayed in the Placeholder drop-down list.
- Select Column - Select a column from
the drop-down list for which you want to set a filter condition.
- After entering the required filter condition, click Add
to add the filter condition.The filter condition is added to the Expressions Built pane.
- Repeat steps 2 and 3 to enter multiple filter conditions for various columns.
- Click Validate to verify if the selected filter condition is valid.
- After entering the required filter conditions, click
Apply to add the filter condition to the
report.The filter conditions are included in the Attributes tab.At any point after validating/applying the filters, you can modify or delete the filter conditions using one of the following tasks:
- Click Update Filter Changes to update a filter expression.
- Click Reset to clear all the validated filters and add new filter conditions.
- Click Delete to delete a filter condition.