5. Introducing N1QL | Couchbase Essentials

Null or missing properties

Throughout our exercises in writing map functions, it was common to test properties before attempting to emit them to a view index. N1QL also provides the capability to check for null or missing properties.

In JavaScript map functions, to check whether a property contains a null value, you simply compare the value to null:

if (doc.property == null) // do something

Missing properties are not null; rather, they don't exist. In order to check for a missing property with JavaScript, you can compare it to the undefined literal string or simply apply the bang (!) operator to your check. Using the latter test will allow for both a null check and a missing check:

if (! doc.property) // do something

There are two separate operators in N1QL used to test null and missing property values. The first query in the following snippet tests whether the value for style is Null:

SELECT *
FROM beer-sample
WHERE type = "beer"
AND style IS NULL

The second tests whether the style property was...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Couchbase Essentials

By : John C Zablocki

Couchbase Essentials

By: John C Zablocki

Overview of this book

Null or missing properties

Couchbase Essentials

By : John C Zablocki

Couchbase Essentials

By: John C Zablocki

Overview of this book

Null or missing properties

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access