Getting Started
Configuration guide
User guide
General
How to
Contents
Let us take a closer look at a condition block of a trigger configuration menu on the screenshot above.
The condition is a group of elements. Each element can be whether a separate boolean expression (that returns true
or false
) or a group of ones. The same is true for each group that is an element of the root one—it can consist of the separate expressions or groups of ones and so on. So, the condition has a tree structure that can branch out growing very complex.
A group unites several expressions inside. To determine what boolean value the group should return, the elements are united with a logical operator (AND
/OR
).
To the right of logical operators, there are links to create the elements. To delete the one, just click a pictogram of recycle bin for a separate expression or a whole group.
At the end of the day, the boolean expression is a basic element. It has three fields—two for operands and one for an operator of expression.
The operands receive data of expression by entering some values or referring to them (to properties of tickets or comments). Functions allow to process those data inside of the operand.
The operator can be selected from a predefined set only which contains not only comparison operators but also some of additional boolean functions.
Name |
Description |
Example |
---|---|---|
Integer |
It is represented using numbers and evaluated as Int32. |
|
Floating-point number |
Use the dot to define the decimal part. They are evaluated as Decimal. |
|
String |
Any character between single quotes is evaluated as String. You can escape special characters: |
|
Date and time |
Must be enclosed between sharps. The are evaluated as DateTime. NCalc uses the current Culture to evaluate them (the example is for |
|
Boolean |
It is a logical data type that can have only the values |
|
The operands of condition expressions can contain a reference to existing properties which is enclosed between square brackets []
. Its structure could be described as [Object.Property]
. If a property is not just a value but a reference to another object (lookup column), then it is also considered as an object that has own properties and the structure of the reference become a bit more complex: [Object.Property.SubProperty]
.
References to commonly used properties can be selected from the dropdown list of an operand:
The objects that are available depend on the event a trigger is configured on.
Object |
Description |
Available on Event |
Reference Syntax |
---|---|---|---|
Ticket |
Returns the current version of a ticket item and allow to get access to its properties defined in a “Tickets” list. |
Ticket has been created Ticket has been changed Comment has been created |
|
Last ticket version |
Returns the previous version of a ticket item and allow to get access to its properties defined in the “Tickets” list. |
Ticket has been changed |
|
Comment |
Returns a comment item and allow to get access to its properties defined in a “Comments” list. |
Comment has been created |
|
Using the described syntax, you can get access to other properties of tickets and comments that are not included in the dropdown list. Refering to such columns requires using of their internal names: [Ticket.CustomColumn]
.
Name |
Description |
Usage |
Result |
---|---|---|---|
Equal ( |
Compares two operands and return |
|
|
Not equal ( |
Compares two operands and return |
|
|
Greater than ( |
Compares two operands and return |
|
|
Greater than or equal ( |
Compares two operands and return ``true` if the first is greater than the second or equal to the last. |
|
|
Less than ( |
The operator compares two operands and return |
|
|
Less than or equal ( |
Compares two operands and return |
|
|
Name |
Description |
Usage |
Result |
---|---|---|---|
Addition or concatenation ( |
Adds values to each other and returns a sum of them. |
|
|
Subtraction ( |
Subtracts the second value from the firs one. |
|
|
Multiplication ( |
Multiplies one value by another. |
|
|
Division ( |
Divides the first value by the second one. |
|
|
Remainder ( |
Divides the first value by the second one and returns a remainder of the division. |
|
|
Name |
Description |
Usage |
Result |
---|---|---|---|
Logical AND ( |
The group of expressions returns |
|
|
Logical OR ( |
The group of expressions returns |
|
|
Logical NOT ( |
The operator changes the result of boolean expression to opposite. |
|
|
Name |
Description |
Usage |
Result |
---|---|---|---|
|
An argument of the function is a set of elements separated by comma. The function returns |
|
|
|
The function receives three arguments: condition expression, values to return depending on the the condition (whether it is true or false). |
|
|
|
Returns |
|
|
|
The function returns List of available options: x - allow whitespace and comments
s - single line mode
m - multi line mode
i - case insensitivity
n - only allow explicit capture
You can find additional information about inline options in this MSDN article. |
|
|
Name |
Description |
Usage |
Result |
---|---|---|---|
|
Returns the absolute value of a specified number. |
|
|
|
Returns the smallest integer greater than or equal to the specified number. |
|
|
|
Returns the largest integer less than or equal to the specified number. |
|
|
|
Returns the larger of two specified numbers. |
|
|
|
Returns the smaller of two numbers. |
|
|
|
Rounds a value to the nearest integer or specified a number of decimal places. |
|
|
Name |
Description |
Usage |
Result |
---|---|---|---|
|
Returns the current system date. |
|
|
|
Returns the current system date and time. |
|
|
|
Returns the date part of a particluar datetime value. |
|
|
|
Adds the specified number of minutes to the specified date parameter. |
|
|
|
Adds the specified number of hours to the specified date parameter. |
|
|
|
Adds the specified number of days to the specified date parameter. |
|
|
|
Adds the specified number of months to the specified date parameter. |
|
|
|
Adds the specified number of years to the specified date parameter. |
|
|