Please enable JavaScript to view this site.

Process Designer

You can define a free condition for your rule after selecting the entry define query in the picklist in the condition section of the edit mask of your rule. The following form box will be displayed:

Define a query

Define a query

Fill in the name of the process field enclosed in parentheses (FIELDNAME) or the name of the form field enclosed in brackets [fieldname] to compare against.

You can use parentheses to group parts of the query and use the logical operators AND or OR (See the following examples).

And if you wish to use Process and system fields for comparison, click the icon-lupe symbol (See Define rule conditions).

The following logical operators are available:

Logical operator

Description

==

is equal to

!= or <>

not equal to

<

less than

<=

is less than or equal to

>

greater than

>=

is greater than or equal to

Please note: The relational operators usable in the query differ to some extent from those listed in chapter Define rule conditions.

Via the checkbox Case sensitive you can control the value comparison procedure.

Please note: Comparisons with string and date values must always be masked with double quotes.

Examples:

Comparison

Result

"Thomas and Peter" == Thomas and Peter

Invalid

"Thomas and Peter" == "Thomas and Peter"

Valid

Please note: Comparisons with system or form fields must always be masked with double quotes.

Examples:

Comparison

Result

(FORMFIELD) == Thomas and Peter

Invalid

(FORMFIELD) == "Thomas and Peter"

Valid

(textbox1) == 12345 OR (textbox1) == "0815"

Valid

[jr_username] == Thomas

Invalid

[jr_username] == "Thomas"

Valid

((textbox1) == "12345" OR (textbox1) == "0815") AND [checkbox1] != "1"

Valid

Please note: For comparisons with numbers, masking with inverted commas is not necessary.

Examples:

Comparison

Result

3 == 3

Valid

3 >= 2

Valid  

(userfield) <= 3

Valid only if the input is a number

[tablefield] <= 3

Valid only if the result is a number

Please note: A size comparison of strings "A" < "B" does not work. Strings are converted to hashed strings for comparison and thus cannot be compared in size or length.