I don’t know how to use N1QL (there are other forums here for that), but I can say that any key in the bucket that starts with _sync: is for internal use by Sync Gateway and should be ignored. (Just like anything in the _sync property in a document.)
1 Like