Defining a Column Filter in Information Designer

Column filters are automatically applied when the column is retrieved. Such filters, unlike filters that are defined and saved as separate elements (filter elements), cannot be disabled by the user.

Column filters are defined while the column element is being created. The following steps should be taken in addition to what is described in Creating a Column Element.

To define a column filter:

1. In Information Designer, in the Filter section, click to show the filtering controls.

2. In the Data Sources tree, select a column and then click Add > to add the column to use in the filter expression.

   Comment: Repeat this step if you need to include more columns in your filter expression.

3. In the Expression field, define a filter condition based on the chosen column or columns. For example, %1<2000, or if you are using two columns, %1<%2.

   Comment: To combine conditions, use the AND or OR operators, for example %1>2000 AND %2<1000.

   Comment: You can also add a personalized filter expression that limits data depending on the currently logged in user. See Personalized Information Links for more information.
   Comment: You can also add a parameterized filter expression. See Parameterized Information Links for more information.

4. Write a clear description of how the column is filtered. This is important, since the user will not be able to disable the filter when using this column element.

Note: When an information link is executed, aggregation is always applied before the filter.