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