...
Token | Use | Description | |||||
---|---|---|---|---|---|---|---|
#CURRENTUSER# | Placeholder | During runtime, the logged-in user name is used for filtering | |||||
#CURRENTYEAR# | Placeholder | During runtime, the current year is used for filtering | |||||
#LASTYEAR# | Placeholder | During runtime, the last year is used for filtering | |||||
#TODAY# | Placeholder | During runtime, today is used for filtering | |||||
#YESTERDAY# | Placeholder | During runtime, yesterday is used for filtering | |||||
#THISWEEK# | Placeholder | During runtime, this week is used for filtering. Example:
| |||||
#LASTWEEK# | Placeholder | During runtime, the last week is used for filtering | |||||
#THISMONTH# | Placeholder | During runtime, this month is used for filtering | |||||
#LASTMONTH# | Placeholder | During runtime, the last month is used for filtering | |||||
YEAR | Modifier | A field modifier that can be used on datetime or date fields. It provides access to the year value of the field.
| |||||
PARENT | Modifier | A field modifier that can be used to resolve a hierarchical catalogue node.
It can be used for catalogue fields. The parent node itself is always included. | |||||
= | Operator | Comparing equability.
| |||||
!= | Operator | Compares two values. Result is true if they are not equal.
| |||||
< | Operator | Compares two values, result . Result is true if first value is less than the second one.
| |||||
> | Operator | Compares two values, result . Result is true if first value is greater than the second one.
| |||||
>= | Operator | Compares two values. Result is true if first value is greater or equal than the second one.
Since version 5.4.3. | |||||
<= | Operator | Compares two values. Result is true if first value is less or equal than the second one.
Since version 5.4.3. | |||||
AND | Operator | Logically combines two terms.
| |||||
OR | Operator | Logically combines two terms.
| |||||
null | Value | Without value.
| |||||
false | Value | For comparing Boolean fields.
| |||||
true | Value | For comparing Boolean fields.
| |||||
[0-9] | Value | Integer value.
|
...