Adding Hard Filters 

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 are therefore less complex than filter elements.

  1. Create an information link.

  2. Go to the Filters section on the Information Link tab for that information link.

  3. Click Add.

    Response: The Add Column dialog is displayed.

  4. Select the column for which you wish to add a hard filter from the drop-down list.

  5. Click OK.

    Response: The column is added to the Filters list.

  6. Repeat steps 3 to 5 add filters for more columns.

  7. For each column, use the Filter Type drop-down list to select whether to filter by range or by values.

    Comment: Filtering by range means entering the upper and lower limits of the desired range. Filtering by values means entering the exact values that you want to include in the returned data, separated by semicolon.

  8. Set the upper and lower limits (range) in the Min Value and Max Value fields, or type the desired values, separated with semicolons in the Values field. You can also type ?param_name in the Values field to use a parameter as the filter for the chosen column, where param_name is the name to identify the parameter by.

    Comment 1: Limits are inclusive. In other words, if the lower limit is set to 1000, the value 1000 will be included in the data table.

    Comment 2: When setting upper and lower limits on columns of type String, 'A' is considered to come before 'AA', and 'S' comes before 'Smith'. This means that the name 'Smith' will not be present when choosing names from 'D' to 'S'. The order of characters is standard ASCII.

Tip: When entering values for filtering you are allowed to use wildcard characters. These are:


Matches any characters (example: '*mber' would return the following months: September, November and December).


Matches any single character (example: '???ember' would only return the months November and December).

See also:

Creating an Information Link

Adding Prompts

Information Link Tab

Parameterized Information Links