Parameters can have single values, intervals and complex selections.
All kinds of parameters can be edited and entered with the help of the editor.

If the parameter is a complex selection, use the Edit link to open an additional dialogue.
As shown in the screenshot, variables can also be used. Please add an @ right before the value to mark it as an variable.

The following screenshot shows the dialogue for entering complex selections.


The field Sign hast 2 Options: Include - Exclude. This selection determines for every row whether the result of the condition is included or excluded in the entire resulting set for all rows.

The field Option contains the selection option for the condition of the row in form of logical operators:

operator description
’=’ Equal
’!=’ Not Equal
’<’ Lower Than
’<=’ Lower Equal Than
’>’ Greater Than
’>=’ Greater Equal Than
’[]’ Between
’][’ NotBetween
‘*’ Contains Pattern (Like)

Low Value column is designated for the comparison value or the lower interval limitation.
High Value column is designated for the upper interval limitation.

Variables and script expressions are supported too. Parameters are not allowed with the Delta Update Mode, since the parameters of the Init mode will be automatically applied.