Get revision number in 5.1

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.

Pankaj Sharma

I found that there is no way to do it.


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.