Filter Data from Couchbase 6 Using N1QL

By the end of this course, you will have the skills required to run a variety of filter queries on the data you have stored in a couchbase database

Finally, you will delve into filtering documents based on the contents of nested structures such as arrays and objects

First, you will explore how documents can be searched using the couchbase web ui and how this interface allows you to define filters based a document key and also on the values of its attributes

In this course, filter data from couchbase using n1ql, you will get some hands on experience in writing queries to retrieve documents from a couchbase database using filters you have defined

Next, you will cover some of the basics of querying in the n1ql query language - such as the select, from and where clauses of a n1ql query - and will also take a brief look at adding and updating documents using insert and update queries

Then, you will move on to the filtering of documents based on the values of their attributes using a variety of comparison operators

These queries will be written in the n1ql query language which has a sql-like syntax to work with json data

This includes the use of collection operators, invoking built-in array functions and also generating slices of arrays