Applying a Dynamic Filter
This topic provides an example that illustrates use of the Compare Filter, with dynamic filtering criteria.
1. Developers can use two or more consecutive Compare Filter elements:
In this case, the comparisons will be evaluated sequentially, based on their arrangement from top to bottom in the element tree. So, after the first Compare Filter is applied, only records that meet its criteria will remain in the datalayer to be evaluated for the second Compare Filter.
2. Developers can make Compare Filter elements dynamic by using tokens:
As shown above, Compare Value attribute 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 token.
3. The Compare Filter element also 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 developers to dynamically determine if the datalayer will be filtered or not.
Please sign in to leave a comment.