Get revision number in 5.1

[pankaj.sharma]

Hi All,

previously getting revision number in N1QL was easy by select _sync.rev but now its not available. We need to get min, max, avg revision number of every type of document in N1QL .

Please let me know how to extract _rev from XATTRs.

Regards
Pankaj Sharma

[pankaj.sharma]

I found that there is no way to do it.

[atom_yang]

FYI

To clarify, the recommendation applied more to pre SG 1.5/ CBS 5.0 . With SG 1.5 / CBS 5.0 (which is what you are presumably using), you don’t need to go through SG always . SG imports documents in CBS via DCP even if it is uploaded via web app and adds appropriate sync metadata in the document XAttr. The imported documents are processed via the sync function. These documents are available to mobile clients. So you shouldn’t have to re implement the sync function’s permissions rules within y…

Issue: [enhance] get rev info via N1QL when using XAtrr

[pankaj.sharma]

What if by running a query I want to find our Min, Max, Avg Revision numbers for a type of document to monitor the amount of data revisions getting created.