Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Operator

Syntax

Syntax example

Description

LIKE

ILIKE

LIKE

ILIKE

advertiser.name LIKE '%Test'

Compares field data and value. The % sign can be used to match any character any number of times. The ‘LIKE’ operator matches case sensitive whereas the ‘ILIKE’ operator does not.

EQUALS

NOT_EQUALS

=

!=

advertiser.name = 'Test'

webhook.log.responseCode = 200

Field data and value for equality / inequality.

IN

IN

advertiser.name IN ('TEST', 'MyAdvertiser')

Checks whether the field's value data is equal to any of the given values.

LESS_THEN

GREATER_THEN

GREATER_OR_EQUAL

LESS_OR_EQUAL

<

>

>=

<=

webhook.log.responseCode >= 200

advertiser_startDate < '2019-09-29T16:19'

Checks whether field data is greater, greater equal, less, less or equal than the value given.

CONTAINS

CONTAINS

advertiser.attributes CONTAINS ('BASKET_FREEZE', 'CREATIVE_IMAGE')

Checks that all given values are contained in the field data

Conjunctions

Conjunction

Example

Description

AND

advertiser.status = 'ACTIVE' AND advertiser.phase = 'TESTING'

Result must match both the left-hand and the right-hand part of the IQL

OR

advertiser.status = 'ACTIVE' OR advertiser.phase = 'TESTING'

Result must match either the left-hand or the right-hand part of the IQL

...