Itgenoda061 error when retrieving rows from SyncDeleted

Questions (nl)
,
1

With the following query:

select *
from   ExactOnlineREST.Sync.SyncDeleted
where  EntityKey in 
       ( '4a60f321-8b96-4faf-845c-4aee487a6466'
       , '7c9765da-c094-4814-a8df-0b77c7e086dd'
       )

I get an error message:

itgenoda061
Filtering on these fields is not supported: EntityKey.

2

Please use the following workaround for now, which effectively disables server-side filtering:

select *
from   ExactOnlineREST.Sync.SyncDeleted
where  to_char(EntityKey) || 'x' 
       in 
       ( '4a60f321-8b96-4faf-845c-4aee487a6466x'
       , '7c9765da-c094-4814-a8df-0b77c7e086ddx'
       )
3

A new release is available that should resolve this issue. The required changes are available from release 25.0.196 and in all future BETA versions.

This new release has been deployed to production on Invantive Cloud.

For more information, see:

4

This question was automatically closed after 1 week of inactivity. The last answer given has been marked as the solution.

Please ask a new question in a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.