Fixed valuesOnly two values will be accepted / returned: Logical operatorsThe following logical operators can be used for linking logical terms in an expression, i.e., terms that return a boolean value type (true or false).
Logical connectives are case insensitive, i.e., they can also be written in lower case: Conditional operator: |
The conditional operator basically allows you to construct the following expression: IF boolean_expression true THEN term_1 ELSE term_2. The format to be used is: <boolean_expression> ? <term_1> : <term_2> Both term_1 and term_2 need to be of the same data type (boolean, number, string, issue list, string list or number list). |
Expression | Output |
---|---|
{...duedate} != null
?
({...duedate} - {...currentDateTime}) / {HOUR}
:
0 | If the Due Date is not null , this function will return the number of hours from the current date-time to Due Date, otherwise it will return 0 . |
timePart({...currentDateTime}, LOCAL) > 21:00 AND timePart({...currentDateTime}, LOCAL) < 7:00
?
"Night"
:
"Day" | If the current time is between 21:00 and 7:00 this function will return "Night " , otherwise it will return "Day ". |
Input | Output |
---|---|
%{...somefield} = "Yes" | True if the value of the field is "Yes", otherwise False . |
%{...somefield1} != null AND %{...somefield2} = null | True only if {...somefield1} field has a value and field {...somefield2} does NOT have a value. |
datePart({...duedate}, LOCAL) > datePart({...currentDateTime}, LOCAL) | True only if Due Date (field code {...duedate}) is later than Current date (field code {...currentDateTime}) in server's local timezone. |