The total number of sync rows with the web source is 136,614 but in the Record List there are only 82,874. After each sync with the web source the number of rows in list are different (80,000 - 90,000).What could be the reason?
Discussion posts and replies are publicly visible
Is it possible that you're using default filters or row-level security? Both of those could limit the number of records that are shown on the record list (even if all the data was synced).
No, because duplication of primary keys break a sync with the web source. All keys are unique
That's weird. Could it be that there are duplicate primary keys?
sync completed with green mark. I use batching:
pagingInfo: a!pagingInfo( startIndex: 1 + ((ri!batchNum - 1) * 1000), batchSize: 1000 )the number of rows in sync grid is equal to number of rows in external DB.But in the Record List I don`t see all of them. No filters applied.
Did you check for any error messages? Is the sync batched? Any more details ...?