Using Multiple and Dynamic Condition Filters
You can use two or more Condition Filter elements together:
In this case, the conditions will be evaluated sequentially, based on their arrangement from top to bottom in the element tree. So, in the example above, after the first condition filter is applied, only records that meet its criteria will remain in the datalayer to be evaluated by the second condition filter.
You can also make Condition Filter elements dynamic by using tokens within expressions:
As shown above, condition formulae can contain tokens such as @Request, so that comparison values are dynamic at runtime.
Sometimes it is necessary to ensure that tokens have default values when running a report. When using @Request tokens, the Default Request Params element can be used to create default values for each Request variable.
Like other filter elements, the Condition Filter has an Include Condition attribute:
If the value of this attribute is left blank or contains a formula that evaluates to True, the element is applied to the datalayer. If the value evaluates to False, the element is ignored and does not affect the datalayer. This powerful feature allows you to dynamically determine if the datalayer will be filtered or not.