N1QL Queries from the SDK

You can query for documents in Couchbase using the N1QL query language, a language based on SQL, but designed for structured and flexible JSON documents. Querying can solve typical programming tasks such as finding a user profile by email address, facebook login, or user ID.

Our query service uses N1QL, which will be fairly familiar to anyone who’s used any dialect of SQL. Further resources for learning about N1QL are listed at the bottom of the page. Before you get started you may wish to checkout the N1QL intro page, or just dive in with a query against our travel sample data set. In this case, the one thing that you need to know is that in order to make a Bucket queryable, it must have at least one index defined. You can define a _primary index on a bucket. When a primary index is defined you can issue non-covered queries on the bucket as well.

Use cbq, our interactive Query shell. Open it, and enter the following:

CREATE PRIMARY INDEX ON `travel-sample`

or replace travel-sample with a different Bucket name to build an index on a different dataset.

The default installation places cbq in /opt/couchbase/bin/ on Linux, /Applications/Couchbase Server.app/Contents/Resources/couchbase-core/bin/cbq on OS X, and C:\Program Files\Couchbase\Server\bin\cbq.exe on Microsoft Windows.

Queries & Placeholders

Placeholders allow you to specify variable constraints for an otherwise constant query. There are two variants of placeholders: postional and named parameters. Positional parameters use an ordinal placeholder for substitution and named parameters use variables. A named or positional parameter is a placeholder for a value in the WHERE, LIMIT or OFFSET clause of a query. Note that both parameters and options are optional.

Positional parameter example:
var query = "SELECT airportname, city, country FROM `travel-sample` " +
    "WHERE type=$1 AND city=$2";

// Issue Query with parameters passed in array

var result=await cluster.query(query, {parameters: ["airport", "Reno"]}, function (err, res) {
    console.log(err);
    if (err) throw err;
    console.log("Result:", res);
});
Named parameter example:
var query = "SELECT airportname, city, country FROM `travel-sample` WHERE type=$TYPE and city=$CITY";

// Issue Query with parameters passed in objects

const opts = { parameters : {  TYPE:"airport", CITY:"Reno"} };
var result=await cluster.query(query, opts, function(err,res){
        console.log(err);
        if (err) throw err;
        console.log("Result:",res);
});

Handling Results

In most cases your query will return more than one result, and you may be looking to iterate over those results:

var query = "SELECT airportname, city, country FROM `travel-sample` WHERE type=$TYPE and city=$CITY";

// Issue Query with parameters passed in objects

const opts = { parameters : {  TYPE:"airport", CITY:"Reno"} };
var result=await cluster.query(query, opts, function(err,res){
        console.log(err);
        if (err) throw err;
        console.log("Result:",res);
});

//// create / update document (mutation) //// create mutation state from mutation results

Additional Resources

N1QL is not the only query option in Couchbase. Be sure to check that your use case fits your selection of query service.

The Server doc N1QL intro introduces up a complete guide to the N1QL language, including all of the latest additions.

The N1QL interactive tutorial is a good introduction to the basics of N1QL use.