Hi, I need to fetch a lot of documents ids to send them to a microservice that updates said document with SG _bulk_update. To do this I need to include their rev field, but I cannot seems to be able to retreive it using N1QL. I’m doing: SELECT docId, META(bucket)._sync.rev FROM bucket The other p…

I want to retreive the current rev value of my objects via N1QL

vsr1 October 12, 2018, 2:38am 2

_sync is not part of the regular document Meta data. So it is not supported directly. You can checkout N1ql + sync gateway

1 Like

Topic		Replies	Views
How to get "rev" id on N1QL query? Couchbase Lite	11	4523	November 29, 2018
How to get doc's rev info? SQL++ n1ql	2	2023	February 24, 2016
Get REV from n1ql SQL++	2	981	December 1, 2017
How to skip "_sync:rev:<docID>:<rev>" data from N1QL Sync Gateway n1ql	5	2881	October 18, 2017
Should N1QL update queries always add where meta().id not like '_sync%'? Sync Gateway	5	1015	September 14, 2018