What is the syntax for MongoDB query for boolean values?

Question

The values for the key is_agent is TRUE or blank.

I have the following query:

db.users.find( { $not: {is_agent:TRUE} }, {email:1} )

I get the following error:

ReferenceError: TRUE is not defined

When I used "TRUE" I got the following error:

"$err" : "Can't canonicalize query: BadValue unknown top level operator: $not",
"code" : 17287

What is the correct syntax?

mate64 · Accepted Answer · 2015-04-16 02:09:53Z

22

$eq Matches values that are equal to a specified value.

$ne Matches all values that are not equal to a specified value.

Example:

db.users.find({is_agent: {$ne: true}})

or

db.users.find({is_agent: {$eq: true}})

answered Apr 16, 2015 at 2:09

mate64

10.1k17 gold badges67 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1