Filter Elements Overview 


Filters are conditions that limit the amount of data returned by an information link. For example, a filter could set the conditions "X > 10 AND Y < 100". There are three ways of filtering data when working with information links:

id_filter_elements.png

Filter elements appear in the Elements tree of Information Designer. They can be added to any information link, just like column elements. See Creating an information link to find out how to include a filter element.

id_hard_filters.png

Hard filters are set up as you define the information link, and are saved with the link. This means that they cannot be reused in other links. Also, hard filters can only specify a range or a list of values, and so are less versatile than filter elements. See Adding Hard Filters for more details.

id_run_time_filters.png

Prompts are also set up when you create an information link. However, the actual conditions are entered by the person running the information link only when the link is opened (executed). For each column that has been set up like this, a dialog will appear allowing the user to enter threshold values or select individual values. See Adding Prompts for more details.

Filters correspond to the WHERE clauses in SQL, and are used to specify that only certain rows of a table shall be retrieved from the data source, based on the criteria described in the filtering condition.

Filter elements can be applied as required by the person creating information links. In the Elements tree, they are represented by this icon: id_filter_i.png

See also:

Creating a Filter Element

Editing a Filter

Deleting a Filter

Relational Operators

Personalized Information Links

Parameterized Information Links