CODEWITHSUNDEEP
couchbasesql++
P T
P T

Reputation: 75

Couchbase N1QL: How to get complete Document including ID and CAS with SELECT

I am using Couchbase 4.0 beta with java-client 2.1.3.

The Bucket.get(id) returns JsonDocument from which I can get id and cas as well as the content. Now I want to query on secondary indices using N1QL (select *). However, the QueryResult only returns rows of JsonObjects which are just the document contents. Is there anyway I can get the meta data (id and cas) too?

Upvotes: 6

Views: 4639

Answers (1)

geraldss
geraldss

Reputation: 2445

You can do the following:

SELECT b, meta(b) AS meta FROM my_bucket b;

Upvotes: 10

Related Questions