com.mongodb.MongoException: invalid operator: $or

Question

I want to run a query, which returns all elements of a collection, in which

the fields wasProposed and markedByUser are true and
the field recipientEmail is either [email protected] or [email protected].

In my Java code, I create a BasicDBObject, whose toString returns this:

{ 
    "wasProposed" : true , 
    "recipientEmail" : 
    { 
        "$or" : 
            [ 
                { "recipientEmail" : "[email protected]" } , 
                { "recipientEmail" : "[email protected]" }
            ]
    }, 
    "markedByUser" : true
}

When I run this query (rcoll.find(query).sort(sortclause).limit(ITEMS_TO_SHOW)), I get the error com.mongodb.MongoException: invalid operator: $or.

How can I modify the query above in order to get rid of this error?

JohnnyHK · Accepted Answer · 2015-01-14 20:43:23Z

1

It's probably cleaner to use $in here instead of an $or:

{ 
    "wasProposed" : true , 
    "recipientEmail" : { "$in" : ["[email protected]", "[email protected]"] },
    "markedByUser" : true
}

answered Jan 14, 2015 at 20:43

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

Collectives™ on Stack Overflow

com.mongodb.MongoException: invalid operator: $or

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related