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

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