Thanks JuneT, here the detail follows:
First Snapshot of the central database:
UserAccess
UserID Name ProductID CreatedDateStamp
UserX XYZ PID001 01/14/2011
Product
ProductID ProductName CreatedDateStamp
PID001 Desktop 01/14/2011
PID002 Laptop 01/14/2011
PID003 Printer 01/14/2011
UserX synced the data, PID001 got downloaded from central server to local .sdf file.
Second Snapshot of the central database:
UserAccess
UserID Name ProductID CreatedDateStamp
UserX XYZ PID001 01/14/2011
UserX XYZ PID002 01/20/2011
Product
ProductID ProductName CreatedDateStamp
PID001 Desktop 01/10/2011
PID002 Laptop 01/10/2011
PID003 Printer 01/10/2011
When UserX syncs the data, PID002 is not downloaded. But UserAccess table records is synced, i think since there are no changes on the Product table from the first sync the records are not getting synced to local db.
The _selectchanges sp as follows
ALTER PROCEDURE [dbo].[Product_selectchanges]
@sync_min_timestamp BigInt,
@sync_scope_local_id Int,
@sync_scope_restore_count Int,
@sync_update_peer_key Int,
@LoggedInUserId Int
AS
BEGIN
SELECT [side].[ProductID], [base].[ProductName], [base].[ CreatedDateStamp], [side].[sync_row_is_tombstone], [side].[local_update_peer_timestamp] as sync_row_timestamp, case when ([side].[update_scope_local_id] is null or [side].[update_scope_local_id] <> @sync_scope_local_id) then COALESCE([side].[restore_timestamp], [side].[local_update_peer_timestamp]) else [side].[scope_update_peer_timestamp] end as sync_update_peer_timestamp, case when ([side].[update_scope_local_id] is null or [side].[update_scope_local_id] <> @sync_scope_local_id) then case when ([side].[local_update_peer_key] > @sync_scope_restore_count) then @sync_scope_restore_count else [side].[local_update_peer_key] end else [side].[scope_update_peer_key] end as sync_update_peer_key, case when ([side].[create_scope_local_id] is null or [side].[create_scope_local_id] <> @sync_scope_local_id) then [side].[local_create_peer_timestamp] else [side].[scope_create_peer_timestamp] end as sync_create_peer_timestamp, case when ([side].[create_scope_local_id] is null or [side].[create_scope_local_id] <> @sync_scope_local_id) then case when ([side].[local_create_peer_key] > @sync_scope_restore_count) then @sync_scope_restore_count else [side].[local_create_peer_key] end else [side].[scope_create_peer_key] end as sync_create_peer_key FROM [Product] [base] RIGHT JOIN [Product_tracking] [side] ON [base].[ ProductID] = [side].[ ProductID] WHERE (([side].[ProductID] IN (SELECT [UserAccess].[ProductID] FROM UserAccess WHERE [UserAccess].[UserID] = @LoggedInUserId)) OR ([side].[sync_row_is_tombstone] = 1 AND ([side].[update_scope_local_id] = @sync_scope_local_id OR [side].[update_scope_local_id] IS NULL) AND [side].[SubTopicID] IS NULL)) AND ([side].[update_scope_local_id] IS NULL OR [side].[update_scope_local_id] <> @sync_scope_local_id OR ([side].[update_scope_local_id] = @sync_scope_local_id AND [side].[scope_update_peer_key] <> @sync_update_peer_key)) AND [side].[local_update_peer_timestamp] > @sync_min_timestamp
END
