|
All empty
|
\[Short description\]\[ALL\_EMPTY\]
|
ALL\_EMPTY
|
short\_descriptionALL\_EMPTY
|
All records in which there is no value in the **Short description** field.
|
|
All equal
|
\[Short description\]\[ALL\_EQ\]\[Network storage unavailable\]
|
ALL\_EQ
|
short\_description=network storage unavailable
|
All records in which the value for the **Short description** field is equal to "Network storage is unavailable."
|
|
All greater than
|
\[Impact\]\[ALL\_GT\]\[2 - Medium\]
|
>
|
impact>2
|
All records in which the **Impact** field has a value of **3 - Low**
|
|
All greater than or equal
|
\[Impact\]\[ALL\_GTE\]\[2 - Medium\]
|
>=
|
impact>=2
|
All records in which the **Impact** field has a value of **2 - Medium** or **3 - Low**.
|
|
All less than
|
\[Reassignment count\]\[ALL\_LT\]\[2\]
|
<
|
reassignment\_count<2
|
All records in which the value in the **Reassignment count** field is any number less than \(but not equal to\) **2**.
|
|
All less than or equal
|
\[Reassignment count\]\[ALL\_LTE\]\[2\]
|
<=
|
reassignment\_count<=2
|
All records in which the value in the **Reassignment count** field is one of the following:- a number less than 2
- 2
|
|
All not equal to
|
\[Impact\]\[ALL\_NEQ\]\[1 - High\]
|
!=
|
impact!=1
|
All records in which the value in the **Impact** field is anything but **1 - High**.
|
|
All not empty
|
\[Impact\]\[ALL\_NOTEMPTY\]
|
ALL\_NOTEMPTY
|
impactALL\_NOTEMPTY
|
All records in which the **Impact** field has any value.
|
|
All not one of
|
\[Impact\]\[ALL\_NOTONEOF\]\[1 - High, 2 - Medium\]
|
ALL\_NOTONEOF
|
impactALL\_NOTONEOF1,2
|
All records in which the **Impact** field is populated by anything except the following values:- **1 - High**
- **2 - Medium**
|
|
All one of
|
\[Impact\]\[ALL\_ONEOF\]\[1 - High, 2 - Medium\]
|
ALL\_ONEOF
|
impactALL\_ONEOF1,2
|
All records in which the **Impact** field is populated by one of the following values:- **1 - High**
- **2 - Medium**
|
|
Any empty
|
\[Short description\]\[ANY\_EMPTY\]
|
ANY\_EMPTY
|
short\_descriptionANY\_EMPTY
|
Any record in which there is no value in the **Short description** field.
|
|
Any equal
|
\[Short description\]\[ANY\_EQ\]\[Network storage unavailable\]
|
ANY\_EQ
|
short\_description=network storage unavailable
|
Any record in which the value for the **Short description** field is equal to "Network storage is unavailable."
|
|
Any greater than
|
\[Impact\]\[ANY\_GT\]\[2 - Medium\]
|
ANY\_GT
|
impactANY\_GT2
|
Any records in which the **Impact** field has a value of **3 - Low**
|
|
Any greater than or equal
|
\[Impact\]\[ANY\_GTE\]\[2 - Medium\]
|
ANY\_GTE
|
impactANY\_GTE2
|
Any record in which the **Impact** field has a value of **2 - Medium** or **3 - Low**.
|
|
Any less than
|
\[Reassignment count\]\[ANY\_LT\]\[2\]
|
ANY\_LT
|
reassignment\_countANY\_LT2
|
Any record in which the value in the **Reassignment count** field is any number less than \(but not equal to\) **2**.
|
|
Any less than or equal
|
\[Reassignment count\]\[ANY\_LTE\]\[2\]
|
ANY\_LTE
|
reassignment\_countANY\_LTE2
|
Any record in which the value in the **Reassignment count** field is one of the following:- a number less than 2
- 2
|
|
Any not equal
|
\[Impact\]\[ANY\_NEQ\]\[1 - High\]
|
ANY\_NEQ
|
impactANY\_NEQ1
|
Any record in which the value in the **Impact** field is anything but **1 - High**.
|
|
Any not empty
|
\[Impact\]\[ANY\_NOTEMPTY\]
|
ANY\_NOTEMPTY
|
impactANY\_NOTEMPTY
|
Any record in which the **Impact** field has any value.
|
|
Any not one of
|
\[Impact\]\[ANY\_NOTONEOF\]\[1 - High, 2 - Medium\]
|
ANY\_NOTONEOF
|
impactANY\_NOTONEOF1,2
|
Any record in which the **Impact** field is populated by anything except the following values:- **1 - High**
- **2 - Medium**
|
|
Any one of
|
\[Impact\]\[ANY\_ONEOF\]\[1 - High, 2 - Medium\]
|
ANY\_ONEOF
|
impactANY\_ONEOF1,2
|
Any record in which the **Impact** field is populated by one of the following values:- **1 - High**
- **2 - Medium**
|
|
CONCAT
|
CONCAT\(value\)
|
CONCAT
|
CONCAT\("Welcome, ",@context.session.user.firstName\)
|
Create a new string that combines all supplied strings into one
|
|
EMPTY
|
EMPTY\(value\)
|
EMPTY
|
EMPTY\(@context.session.user.roles\)
|
Returns true if value is null or undefined
|
|
IF
|
IF\(if, then, else\)
|
IF
|
IF\(@context.props.bare,"bare page","not bare page"\)
|
If condition is true, return the value then. If condition is false, return the value else.
|
|
LEN
|
LEN\(list\)
|
LEN
|
LEN\(\[1,2,3\]\)
|
Returns the number of items in the array
|
|
Pick
|
PICK\(array, field\)
|
Pick
|
PICK\(@context.session.user.preferences,"name"\)
|
Creates a new array where each item is picked from field in each item in the array. If the field does not exist, the item in the new array will be EMPTY
|
|
Range
|
RANGE\(from, to\)
|
Range
|
RANGE\(1,10\)
|
Creates an array of numbers, starting with from, up to, incrementing by step
|
|
Sum
|
SUM\(array\)
|
Sum
|
SUM\(\[1,2,3\]\)
|
Starting at 0, add the number value of each item in the array and return the resulting summation
|
|
Translate
|
TRANSLATE\(text\)
|
Translate
|
TRANSLATE\("Welcome back"\)
|
Returns the string from the first argument after the characters specified in the second argument are translated into the characters specified in the third argument.
|
|
Where empty
|
\[Short description\]\[WHERE\_EMPTY\]
|
WHERE\_EMPTY
|
short\_descriptionWHERE\_EMPTY
|
Extract records where there is no value in the **Short description** field.
|
|
Where equal
|
\[Short description\]\[WHERE\_EQ\]\[Network storage unavailable\]
|
WHERE\_EQ
|
short\_descriptionWHERE\_EQnetwork storage unavailable
|
Extract records where the **Short description** field is equal to "Network storage is unavailable."
|
|
Where greater than
|
\[Impact\]\[WHERE\_GT\]\[2 - Medium\]
|
WHERE\_GT
|
impactWHERE\_GT2
|
Extract records where the **Impact** field has a value of **3 - Low**
|
|
Where greater than or equal
|
\[Impact\]\[WHERE\_GTE\]\[2 - Medium\]
|
WHERE\_GTE
|
impactWHERE\_GTE2
|
Extract records where the **Impact** field has a value of **2 - Medium** or **3 - Low**.
|
|
Where less than
|
\[Reassignment count\]\[WHERE\_LT\]\[2\]
|
WHERE\_LT
|
reassignment\_countWHERE\_LT2
|
Extract records where the value in the **Reassignment count** field is any number less than \(but not equal to\) **2**.
|
|
Where less than or equal
|
\[Reassignment count\]\[WHERE\_LTE\]\[2\]
|
WHERE\_LTE
|
reassignment\_countWHERE\_LTE2
|
Extract records where the value in the **Reassignment count** field is one of the following:- a number less than 2
- 2
|
|
Where not equal
|
\[Impact\]\[WHERE\_NEQ\]\[1 - High\]
|
WHERE\_NEQ
|
impactWHERE\_NEQ1
|
Extract records where the value in the **Impact** field is anything but **1 - High**.
|
|
Where not empty
|
\[Impact\]\[WHERE\_NOTEMPTY\]
|
WHERE\_NOTEMPTY
|
impactWHERE\_NOTEMPTY
|
Extract records where the **Impact** field has any value.
|
|
Where not one of
|
\[Impact\]\[WHERE\_NOTONEOF\]\[1 - High, 2 - Medium\]
|
WHERE\_NOTONEOF
|
impactWHERE\_NOTONEOF1,2
|
Extract records where the **Impact** field is populated by anything except the following values:- **1 - High**
- **2 - Medium**
|
|
Where one of
|
\[Impact\]\[WHERE\_ONEOF\]\[1 - High, 2 - Medium\]
|
WHERE\_ONEOF
|
impactWHERE\_ONEOF1,2
|
Extract records where the **Impact** field is populated by one of the following values:- **1 - High**
- **2 - Medium**
|