Data Types & Operators

Data Types

String

• eq - Equals to
• ne - Does not equals to
• like - Contains
• not-like - Does not contain
• begins-with - Begins with
• not-begin-with - Does not begin with
• ends-with - Ends with
• not-end-with - Does not end with
• not-null - Contains data
• null - Does not contain data

Number

• eq - Equals to
• ne - Does not equal to
• not-null - Contains data
• null - Does not contain data
• gt - Greater than
• gte - Greater than or equals to
• lt - Less than
• lte - Less than or equals to
• between - Between

Money

• eq - Equals to
• ne - Does not equal to
• not-null - Contains data
• null - Does not contain data
• gt - Greater than
• gte - Greater than or equals to
• lt - Less than
• lte - Less than or equals to
• between - Between

Date

• on - Date is equals to
• on-or-after - Date is on or after
• on-or-before - Date is on or before
• today - Today
• yesterday - Yesterday
• tomorrow - Tomorrow
• this-week - This week
• this-month - This month
• this-year - This year
• this-fiscal-year - This fiscal year
• next-week - Next week
• next-seven-days - In the next seven days
• next-month - Next month
• next-year - Next year
• next-fiscal-year - Next fiscal year
• next-x-hours - In the next x hours
• next-x-days - In the next x days
• next-x-weeks - In the next x weeks next-x-months - In the next x months
• next-x-years - In the next x years
• last-week - Last week
• last-seven-days - In the last seven days
• last-month - Last month
• last-year - Last year
• last-fiscal-year - Last fiscal year
• last-x-hours - In the last x hours
• last-x-days - In the last x days
• last-x-weeks - In the last x weeks
• last-x-months - In the last x months
• last-x-years - In the last x years
• olderthan-x-hours - Older than x hours
• olderthan-x-days - Older than x days
• olderthan-x-weeks - Older than x weeks
• olderthan-x-months - Older than x months
• olderthan-x-years - Older than x years
• in-fiscal-year - In the fiscal year
• between - Between two dates
• not-null - Contains data
• null - Does not contain data

Choice

• in - Equals to
• not-in - Does not equal to
• not-null - Contains data
• null - Does not contain data

Lookup

• in - Equals to
• not-in - Does not equal to
• not-null - Contains data
• null - Does not contain data

Boolean

• in - Equals to
• not-in - Does not equal to
• not-null - Contains data
• null - Does not contain data

Id

• not-null - Contains data
• null - Does not contain data

Attachment

• not-null - Contains data
• null - Does not contain data

Mixed

• not-null - Contains data
• null - Does not contain data

Operators

eq

Value is equal to the specified value.

{
  field: 'fieldName',
  operator: 'eq',
  value: 'value'
}

Data types: String, Number, Money

Note: String comparisons are case insensitive, while other data types should be compared as is.

ne

Value is not equal to the specified value.

{
  field: 'fieldName',
  operator: 'ne',
  value: 'value'
}

Data types: String, Number, Money

gt

{
  field: 'fieldName',
  operator: 'gt',
  value: 'value',
}

Data types: Number, Money

lt

{
  field: 'fieldName',
  operator: 'lt',
  value: 'value',
}

Data types: Number, Money

gte

{
  field: 'fieldName',
  operator: 'gte',
  value: 'value',
}

Data types: Number, Money

lte

{
  field: 'fieldName',
  operator: 'lte',
  value: 'value',
}

Data types: Number, Money

like

{
  field: 'fieldName',
  operator: 'like',
  value: 'value',
}

Data types: String

not-like

{
  field: 'fieldName',
  operator: 'not-like',
  value: 'value',
}

Data types: String

begins-with

{
  field: 'fieldName',
  operator: 'begins-with',
  value: 'value',
}

Data types: String

not-begin-with

{
  field: 'fieldName',
  operator: 'not-begin-with',
  value: 'value',
}

Data types: String

ends-with

{
  field: 'fieldName',
  operator: 'ends-with',
  value: 'value',
}

Data types: String

not-end-with

{
  field: 'fieldName',
  operator: 'not-end-with',
  value: 'value',
}

Data types: String

not-null

{
  field: 'fieldName',
  operator: 'not-null',
  value: 'value',
}

Data types: String, Number, Money, Date, Choice, Lookup, Boolean, Id, Attachment, Mixed

null

{
  field: 'fieldName',
  operator: 'null',
  value: 'value',
}

Data types: String, Number, Money, Date, Choice, Lookup, Boolean, Id, Attachment, Mixed

on

{
  field: 'fieldName',
  operator: 'on',
  value: 'value',
}

Data types: Date

on-or-after

{
  field: 'fieldName',
  operator: 'on-or-after',
  value: 'value',
}

Data types: Date

on-or-before

{
  field: 'fieldName',
  operator: 'on-or-before',
  value: 'value',
}

Data types: Date

today

{
  field: 'fieldName',
  operator: 'today',
  value: 'value',
}

Data types: Date

yesterday

{
  field: 'fieldName',
  operator: 'yesterday',
  value: 'value',
}

Data types: Date

tomorrow

{
  field: 'fieldName',
  operator: 'tomorrow',
  value: 'value',
}

Data types: Date

this-week

{
  field: 'fieldName',
  operator: 'this-week',
  value: 'value',
}

Data types: Date

this-month

{
  field: 'fieldName',
  operator: 'this-month',
  value: 'value',
}

Data types: Date

this-year

{
  field: 'fieldName',
  operator: 'this-year',
  value: 'value',
}

Data types: Date

this-fiscal-year

{
  field: 'fieldName',
  operator: 'this-fiscal-year',
  value: 'value',
}

Data types: Date

next-week

{
  field: 'fieldName',
  operator: 'next-week',
  value: 'value',
}

Data types: Date

next-seven-days

{
  field: 'fieldName',
  operator: 'next-seven-days',
  value: 'value',
}

Data types: Date

next-month

{
  field: 'fieldName',
  operator: 'next-month',
  value: 'value',
}

Data types: Date

next-year

{
  field: 'fieldName',
  operator: 'next-year',
  value: 'value',
}

Data types: Date

next-fiscal-year

{
  field: 'fieldName',
  operator: 'next-fiscal-year',
  value: 'value',
}

Data types: Date

next-x-hours

{
  field: 'fieldName',
  operator: 'next-x-hours',
  value: 'value',
}

Data types: Date

next-x-days

{
  field: 'fieldName',
  operator: 'next-x-days',
  value: 'value',
}

Data types: Date

next-x-weeks

{
  field: 'fieldName',
  operator: 'next-x-weeks',
  value: 'value',
}

Data types: Date

next-x-months

{
  field: 'fieldName',
  operator: 'next-x-months',
  value: 'value',
}

Data types: Date

next-x-years

{
  field: 'fieldName',
  operator: 'next-x-years',
  value: 'value',
}

Data types: Date

last-week

{
  field: 'fieldName',
  operator: 'last-week',
  value: 'value',
}

Data types: Date

last-seven-days

{
  field: 'fieldName',
  operator: 'last-seven-days',
  value: 'value',
}

Data types: Date

last-month

{
  field: 'fieldName',
  operator: 'last-month',
  value: 'value',
}

Data types: Date

last-year

{
  field: 'fieldName',
  operator: 'last-year',
  value: 'value',
}

Data types: Date

last-fiscal-year

{
  field: 'fieldName',
  operator: 'last-fiscal-year',
  value: 'value',
}

Data types: Date

last-x-hours

{
  field: 'fieldName',
  operator: 'last-x-hours',
  value: 'value',
}

Data types: Date

last-x-days

{
  field: 'fieldName',
  operator: 'last-x-days',
  value: 'value',
}

Data types: Date

last-x-weeks

{
  field: 'fieldName',
  operator: 'last-x-weeks',
  value: 'value',
}

Data types: Date

last-x-months

{
  field: 'fieldName',
  operator: 'last-x-months',
  value: 'value',
}

Data types: Date

last-x-years

{
  field: 'fieldName',
  operator: 'last-x-years',
  value: 'value',
}

Data types: Date

olderthan-x-hours

{
  field: 'fieldName',
  operator: 'olderthan-x-hours',
  value: 'value',
}

Data types: Date

olderthan-x-days

{
  field: 'fieldName',
  operator: 'olderthan-x-days',
  value: 'value',
}

Data types: Date

olderthan-x-weeks

{
  field: 'fieldName',
  operator: 'olderthan-x-weeks',
  value: 'value',
}

Data types: Date

olderthan-x-months

{
  field: 'fieldName',
  operator: 'olderthan-x-months',
  value: 'value',
}

Data types: Date

olderthan-x-years

{
  field: 'fieldName',
  operator: 'olderthan-x-years',
  value: 'value',
}

Data types: Date

in-fiscal-year

{
  field: 'fieldName',
  operator: 'in-fiscal-year',
  value: 'value',
}

Data types: Date

between

{
  field: 'fieldName',
  operator: 'between',
  value: 'value',
}

Data types: Date, Number, Money

in

{
  field: 'fieldName',
  operator: 'in',
  value: 'value',
}

Data types: Choice, Lookup, Boolean

not-in'

{
  field: 'fieldName',
  operator: 'not-in'',
  value: 'value',
}

Data types: Choice, Lookup, Boolean