[Enhancement] Sync receipt

[mimetis]

[Enhancement] Sync receipt

[gentledepp]

Yeah that perfectly makes sense. Thank you!

[Mimetis]

I don't think we can add a bit on the tracking tables.
A row in the tracking table is not related to one client.

You can have this information, at least, an approximation.
If you take the [scope_infog].[scope_timestamp] related to your client, you can compare with the table_tracking.[timestamp] value and determine if the row has been sent to the client.

Actually, this is how the selectchanges stored procedure is working.
Here is an extract:

([side] represents the tracking table)

WHERE (
	-- Update made by the local instance
	[side].[update_scope_id] IS NULL
	-- Or Update different from remote
	OR [side].[update_scope_id] <> @sync_scope_id
	-- Or we are in reinit mode so we take rows even thoses updated by the scope
	OR @sync_scope_is_reinit = 1
    )
AND (
	-- And Timestamp is > from remote timestamp
	[side].[timestamp] > @sync_min_timestamp
	OR
	-- remote instance is new, so we don't take the last timestamp
	@sync_scope_is_new = 1
	)
AND (
	[side].[sync_row_is_tombstone] = 1 
	OR
	([side].[sync_row_is_tombstone] = 0 AND [base].[CustomerID] is not null	)
)

Is that make senses ?