Function: Field

Syntax

Field(fieldName)

Description

Field takes a single string argument and returns the value of the field. This function is normally implicitly declared when using comparison functions such as Equal, so for example this:

Equal(Priority,High)

Automatically becomes this during query compilation:

Equal(Field(Priority), High)

Field is useful when passing values to non-comparison functions, such as DateAdd, DateSubtract etc. or when comparing one field to another.

Examples

Count of items where the DueDate (custom date field) is after the last updated date:

Faceted GreaterThan(DueDate, Field(LastUpdatedAt)) AS "Changed after due" { COUNT } WHERE EntityType = Incident
  • No labels