...
- The Constant selection from the Type dropdown, allows you to either:
- Type the value(s) in the Value field.
- Highlight the line item in the left Value pane.
- Then click the double chevron to add it to the list of available options.
- Repeat these steps for each value that should be added.
OR, - Retrieve all the available values from the database, by clicking the Get Values dropdown.
- Select an option from the dropdown.
- Then click the respective double chevron.
- Repeat these steps for each option that should be added from the Get Values dropdown.
- Once the values appear on the right, within the Multiple Values: pane, select a value and click the up/down arrows to reorder, or click the red X to delete a value from the right.
- Click OK to confirm and return to the WHERE statement view.
Dynamic Filter Type
...
Parameter Filter Type
- Once Parameter is selected from the Type dropdown, available options include:
- Simple. This is used for prompts using Text Input. This is the default value.
- Static. This is used for prompts using Selection. This option allows you to select multiple values at run time.
Dynamic. This is used for prompts using Data Values. This option allows you to select multiple values at run time.
Tip You can also select Optional to indicate that the selected value (Simple, Static, or Dynamic) is optional.
- test
- test
...
Field Filter Type
- test
- test
- test
Note | ||
---|---|---|
| ||
...