Known issue: ServiceNow doesn't Support OR Operators in Trigger Queries

This article applies to Exalate Classic only. If you're using the New Exalate experience, please refer to the New Exalate documentation.

Problem

Exalate does not support queries containing OR (and, conversely, ^NQ) operator, like in the following query:

sys_created_on>javascript:gs.dateGenerate('2021-04-01','00:00:00')ORassignment_group.nameSTARTSWITHfoo

Cause

Exalate keeps track of the last time when it executed a query and with every next sync, it only takes into account changes that were made since the previous sync.

To do that Exalate adds sys_updated_on>= a clause to the original trigger query. 

In case the query contains OR , sys_updated_on>= only affects the left-hand side part of the query.

Solution

There are 2 possible workarounds for this issue.

Workaround 1: 

You may split the query into 2 separate triggers:

sys_created_on>javascript:gs.dateGenerate('2021-04-01','00:00:00')

and

assignment_group.nameSTARTSWITHfoo

Workaround 2: 

As a solution, you can use a conditional checkbox field and reference it from the trigger query

u_my_checkbox=true