Sync Unchanged Records #705
-
|
Hello, I noticed that when I asked to sync tables, some of unchanged records synced whatever the version or updateAt was. this attached image shows one record has no changes since 2021 but it always exist in the synced items list. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 1 reply
-
|
Without some additional information about the way things are set up, I can't say. The search says "find records where updatedAt > 2021-05-19T08:46:40.547Z" However, some databases don't have a resolution for comparison that fine. Your database must be configured such that the comparison is on ms accuracy. Essentially, the database gets queried for this comparison and returns the record. The service just interprets this and returns it. |
Beta Was this translation helpful? Give feedback.
-
|
I really appreciate. |
Beta Was this translation helpful? Give feedback.
Without some additional information about the way things are set up, I can't say.
The search says "find records where updatedAt > 2021-05-19T08:46:40.547Z"
The record holds the exact same date. Since it's gt and not ge, it should not be included.
However, some databases don't have a resolution for comparison that fine. Your database must be configured such that the comparison is on ms accuracy. Essentially, the database gets queried for this comparison and returns the record. The service just interprets this and returns it.