Couchbase queries

9 views
Skip to first unread message

os...@crowdcomfort.com

unread,
Jul 13, 2017, 11:02:56 PM7/13/17
to SlamData-User
I was able to connect to one of my buckets. I can see the list of documents and I want to do a test query. For example, How do I query documents by a document type? 

I tried something like it is described in the documentation with no luck, the query finishes but there are no results or error messages. 

SELECT * from `\myDocumentType`

* Do not worry, this particular document type only has few documents. 

Damon LaCaille

unread,
Jul 18, 2017, 3:04:50 PM7/18/17
to SlamData-User
Oscar,

When you create a new Couchbase mount, it will usually have the value "type" inserted into the "Document type" field in the Mount dialog. This allows SlamData to present a logical file to you in the UI, and each file will represent one document type.

So if you had document types of Customer and Car, after you mounted Couchbase you could query them like

SELECT * FROM `/mybucket/Customer`

because each document type will appear as a logical grouping or file in the SlamData UI.
Reply all
Reply to author
Forward
0 new messages