An alternative to setting filter conditions in the Filters section (see Adding Hard Filters) is to configure your information link to prompt for filter values as the columns are retrieved. This way you do not have to specify filter conditions in advance. The data table will be pared down before the next column in sequence is processed (unless you have specified prompt groups to treat the columns as independent). See Prompted Information Link Example for further information.
To enable prompts:
On the Information Link tab, go to the Prompts section.
Click Add.
Response: The Add Column dialog is displayed.
Select the column for which you wish to add a prompt from the drop-down list.
Click OK.
Response: The column is added to the Prompts list.
Repeat steps 3 to 5 add prompts for more columns.
For each column, use the Prompt Type drop-down list to select how you want to be prompted for filter conditions during data retrieval.
Comment: Selecting Values will let you enter a list of values to include. Range will let you specify a range of values. Multiple selection will present a list of available values from which you can select multiple values. Single selection will present a list of available values from which you can select a single value.
Note: When opening a prompted information link, the prompts will appear in the order that the columns appear in the Information Link tab. You can use the Move Up and Move Down buttons to move columns up or down. (Filter elements are always applied before any prompts, regardless of order.)
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:
Prompted Information Link Example