Expressions in Condition Values

Complete reference of built-in expressions in the Conditions of the TIVITY platform.

{DateTime.Now}

Returns the current date and time.

Syntax

{DateTime.Now}

{DateTime.Now.Date}

Returns the current date.

Syntax

{DateTime.Now.Date}

{DateTime.Now.Add(<Parameters>)}

Returns the time calculated based on the current time (the span to be added is passed as a parameter(s)). You can add either years or quarters or months or weeks or days or hours or minutes or miliseconds or ticks. If the value is negative the resulting time will be in the past. The part to add is case insensitive and can be pluralized.

Syntax

{DateTime.Now.Add(YEARS, 1)}
{DateTime.Now.Add(QUARTER, 1)}
{DateTime.Now.Add(DAYS, -7)}
{DateTime.Now.Add(HOURS, 12)}
{DateTime.Now.Add(MINUTES, 60)}
{DateTime.Now.Add(SECONDS, 35)}
{DateTime.Now.Add(MILISECONDS, 50)}
{DateTime.Now.Add(TICKS, 2)}

Parameters

  • YEARS,<years> or

  • QUARTERS, <quarters> or

  • MONTHS, <months> or

  • WEEKS, <weeks> or

  • DAYS,<days> or

  • HOURS,<hours> or

  • MINUTES,<minutes>

  • SECONDS, <seconds>

  • MILISECONDS, <miliseconds>

  • TICKS, <ticks>

{DateTime.Now.Add(<Parameters>).BeginOf(<Parameters>)}

Returns the begin of the given part of the date and time (e.g. begin of the year 2021 would be '2021-01-01 00:00:00.000'). The part is case insensitive and can be pluralized.

Syntax

{DateTime.Now.Add(WEEK, -1).BeginOf(WEEK)}
{DateTime.Now.Add(YEAR, 1).BeginOf(MONTH)}

Parameters

  • YEARS,<years> or

  • QUARTERS, <quarters> or

  • MONTHS, <months> or

  • WEEKS, <weeks> or

  • DAYS,<days> or

  • HOURS,<hours> or

  • MINUTES,<minutes>

  • SECONDS, <seconds>

{DateTime.Now.Add(<Parameters>).EndOf(<Parameters>)}

Returns the end of the given part of the date and time (e.g. end of the year 2021 would be '2021-12-31 23:59:59.999'). It is possible to make expression with both parts 'BeginOf(<Parameters>)' and 'EndOf(<Parameters>)', e.g. 'DateTime.Now.Add(<Parameters>).BeginOf(<Parameters>).EndOf(<Parameters>)'.

Syntax

{DateTime.Now.Add(QUARTER, 2).EndOf(QUARTER)}
{DateTime.Now.Add(MONTH, 1).EndOf(MONTH)}

Parameters

  • YEARS,<years> or

  • QUARTERS, <quarters> or

  • MONTHS, <months> or

  • WEEKS, <weeks> or

  • DAYS,<days> or

  • HOURS,<hours> or

  • MINUTES,<minutes>

  • SECONDS, <seconds>

{CurrentLogin(<Parameters>)}

The value of the specified attribute received from the account information related to the source the user accessed to.

Syntax

{CurrentLogin(<Parameters>)}

Parameters

AttributeName

{CurrentObject.<FieldName>}

The value of the specified field of the current object (relevant for example for conditions defined for fields with a data source depending on some field of the current objects).

Syntax

{CurrentObject.<FieldName>}

{ParentObject.<FieldName>}

The value of the specified field of the parent object (relevant for example for conditions in selections with a context).

Syntax

{ParentObject.<FieldName>}

{MainObject.<FieldName>}

The value of the specified field of the main object (relevant for example for conditions in selections with a context).

Syntax

{MainObject.<FieldName>}

{<Type>Object.Attributes["<KeyName"]}

The value of the specified field by key name. Can also be the internal name. For vertical fields, the resolved value is output. Alternative to the expressions above (e.g. ParentObject.<FieldName>)

Syntax

{CurrentObject.Attributes["<KeyName"]}
{ParentObject.Attributes["<KeyName"]}
{MainObject.Attributes["<KeyName"]}

{<Type>Object.GetValueByKey["<KeyName>"]}

The value of the specified field by key name. The key name of the field must be entered (not internal name). With virtual fields, the resolved value is not output, but always the original value. To get the resolved value, the name must be specified explicitly (e.g. GetValueByKey["Name__RESOLVED"]). Can be used for any objects.

Syntax

{CurrentObject.GetValueByKey["<KeyName>"]}
{ParentObject.GetValueByKey["<KeyName>"]}
{MainObject.GetValueByKey["<KeyName>"]}

{Function.Name[([Parameter1:"Value1"[,Parameter2:"Value2"]])][:Format]}

Expression Function returns the result value of the executed function and is identified with the beginning text 'Function'.

Given a function expression has syntax errors, when the expression is evaluated, then an error message is shown (including the syntactically wrong expression). When a function with the given key or name is not found, then a null value is returned.

Given a function expression does not contain a format, when the expression is evaluated, then the function result value is returned as-is (not formatted in the user-specific language).

Given a function parameter is not specified as an expression parameter, when the expression is evaluated, then the parameter value is evaluated from the context. The following context variable providers are supported:

  • CurrentObject.<Field-Name>: Access to field values of the current object.

  • ParentObject.<Field-Name>: Access to field values of the parent object.

  • MainObject.<Field-Name>: Access to field values of the main object.

  • CurrentUser.<Field-Name>: Access to field values of the current user.

Function expressions are not supported in user-defined reports.

Syntax

{Function.Name[([Parameter1:"Value1"[,Parameter2:"Value2"]])][:Format]}
PreviousExpressions in ExpressionsNextPlatform

Last updated