Hello, I am developing an integration based on EmpJob using HTTP OData query, I need to select only modified, created and the ones that became "current" because of statDate records between now and the last run.
But when a record is modified between the delta time but with a startDate in the future it appears in the query result.
This is an example with the critical part of the filter:
(employmentNav/personNav/personalInfoNav/lastModifiedDateTime ge datetimeoffset'2021-01-22T11:22:53Z' ) and (employmentNav/personNav/personalInfoNav/startDate le datetime'2021-01-22T11:22:53Z')
I changed some Personal Info on 2021-01-22T14:00:00Z but with a future date, the asOfDate is set at 2021-01-22.
I did not expect the modified record to show in the result but it appears, with this data:
This is really strange, a record with this data should not match the filter but it does.
So I can't understand how to not make appear in the delta query that record, that is unchanged until startDate comes.