Filter
Apply filter conditions (query statements) to reports to customize the report results according to your requirements. Filter conditions are useful when you have large and complex report schema tables.
- Current filter
- Contains filters that you can use for generating a custom report. However, it is not mandatory to apply filters to a report.
- Function
- Provides a list of functions that you can apply to a row in a
report:
- None: No character casing must be applied.
- Lower: Lowercase character casing must be applied.
- Upper: Uppercase character casing must be applied.
- Entity
- Provides a list of report schema tables that are defined by using Security Identity Manager.
- Attribute
- Provides a list of attributes that are mapped with the entity that you selected earlier. Attributes appear as column names in the report.
- Operator
- Provides a list of relational operators. Use the following operators
to define a relation between two entities:
- Equals
- Like
- Greater than
- Not equal to
- Greater than or equal to
- Less than
- Not like
- Less than or equal to
Note: The Like operator is case-sensitive. - Condition
- Provides a list of conditions to use for constructing query statements:
- None: Indicates that no more filter condition can be added to the report.
- AND: Generates results only if all the specified filter conditions meet.
- OR: Generates results if either of the specified filter conditions meet.
Use these buttons:
- Add Row
- Click this button add the query statement that you defined as a row in the current filter.
- Apply
- Click to save your changes and continue.
- Preview
- Click this button to preview the report in a new browser window.
Click other tabs to specify additional information.