Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added less greator or equal condition

...

TokenUseDescription
#CURRENTUSER#PlaceholderDuring runtime, the logged-in user name is used for filtering
#CURRENTYEAR#PlaceholderDuring runtime, the current year is used for filtering

#LASTYEAR#

PlaceholderDuring runtime, the last year is used for filtering
#TODAY#PlaceholderDuring runtime, today is used for filtering
#YESTERDAY#PlaceholderDuring runtime, yesterday is used for filtering
#THISWEEK#Placeholder

During runtime, this week is used for filtering. Example:


Code Block
languagejs
{
  "title": "Edited by me this year",
  "key": "EditedByMeThisYear",
  "condition": "modifier=#CURRENTUSER# AND modified=#THISWEEK#"
}


#LASTWEEK#PlaceholderDuring runtime, the last week is used for filtering
#THISMONTH#PlaceholderDuring runtime, this month is used for filtering
#LASTMONTH#PlaceholderDuring runtime, the last month is used for filtering
YEARModifier

A field modifier that can be used on datetime or date fields. It provides access to the year value of the field.
Example:


Code Block
languagejs
{
  "title": "Edited in 2016",
  "key": "Edited2016",
  "condition": "modified(YEAR)=2016"
}


PARENTModifier

A field modifier that can be used to resolve a hierarchical catalogue node.
This example shows all children of nodes with the value Europe which may be its countries:

Code Block
languagejs
{
  "title": "Employees in Europe",
  "key": "EmpEurope",
  "condition": "personalfile.continent(PARENT)='Europe'"
}

It can be used for catalogue fields. The parent node itself is always included.

=Operator

Comparing equability.
Example:

Code Block
languagejs
"codition":"modifier=#CURRENTUSER#"


!=Operator

Compares two values. Result is true if they are not equal.
Example:

Code Block
languagejs
"condition": "modifier!=#CURRENTUSER"


<Operator

Compares two values, result . Result is true if first value is less than the second one.
Example:

Code Block
languagejs
"condition": "version<4"


>Operator

Compares two values, result . Result is true if first value is greater than the second one.
Example:

Code Block
languagejs
"condition": "version>1"


>=Operator

Compares two values. Result is true if first value is greater or equal than the second one.
Example:

Code Block
languagejs
"condition": "version>=1"

Since version 5.4.3.

<=Operator

Compares two values. Result is true if first value is less or equal than the second one.
Example:

Code Block
languagejs
"condition": "version<=1"

Since version 5.4.3.

ANDOperator

Logically combines two terms.
Example:

Code Block
languagejs
"condition": "doc.status!='new' AND doc.status!=null"


OROperator

Logically combines two terms.
Example:

Code Block
languagejs
"condition": "doc.status='started' OR doc.status='tobereworked'"


nullValue

Without value.
Example:

Code Block
languagejs
"condition": "doc.active=null"


falseValue

For comparing Boolean fields.
Example:

Code Block
languagejs
"condition": "doc.active=false"


trueValue

For comparing Boolean fields.
Example:

Code Block
languagejs
"condition": "doc.active=true"


[0-9]Value

Integer value.
Example:

Code Block
languagejs
"condition": "doc.amount>4711"


...