How to use "$or" operator using documents in mongodb using java

Question

Document query = new Document();
            query.put("firstName", "abc");
            query.put("firstName", "xyz");

Here,"abc" is overrided by the "xyz".So,in the query I'm getting only one value i.e,xyz.I don't know,why the query getting overrided.can u please help me out...

My code:

MongoClient mongo = new MongoClient("localhost",27017);
        MongoDatabase db = mongo.getDatabase("sample");
        MongoCollection<Document> coll = db.getCollection("users");


        Document query = new Document();
        query.put("firstName", "abc");
        query.put("firstName", "xyz");

        Document docStatus =new Document("$or",query );
        try (MongoCursor<Document> cursor = coll.find(query).iterator()) {
            while (cursor.hasNext()) {
            System.out.println(cursor.next());
            }
        }

Possible duplicate of Creating a mongodb query in Java with $or and $in — ΦXocę 웃 Пepeúpa ツ
– ΦXocę 웃 Пepeúpa ツ, Commented Mar 14, 2016 at 8:27

Blakes Seven · Accepted Answer · 2016-03-14 08:32:38Z

2

The arguments to the $or operator are a List, therefore you are just contructing a List of Document:

Document query = new Document(
  "$or", Arrays.asList(
    new Document("firstname", "abc"),
    new Document("firstname", "xyz")
  )
)

But really, when you want an $or condition on the same property, use $in instead. Which is of course another List but just of values:

Document query = new Document(
    "firstname",
    new Document(
        "$in", Arrays.asList("abc","xyz")
    )
)

Which is much shorter syntax for the selection of "either" value on the same document property.

answered Mar 14, 2016 at 8:32

Blakes Seven

50.5k14 gold badges132 silver badges136 bronze badges

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

1 Comment

dev777 Over a year ago

Thanks a lot for ur help.

Rahul · Accepted Answer · 2016-03-14 08:27:54Z

1

You need to construct your query as below :

DBObject clause1 = new BasicDBObject("firstName", "abc");  
DBObject clause2 = new BasicDBObject("firstName", "xyz");    
BasicDBList or = new BasicDBList();
or.add(clause1);
or.add(clause2);
DBObject query = new BasicDBObject("$or", or);

answered Mar 14, 2016 at 8:27

Rahul

16.4k4 gold badges45 silver badges64 bronze badges

Comments

Tamil Arasi · Accepted Answer · 2016-03-14 08:53:49Z

0

BasicDBList orList = new BasicDBList();

orList.add(new BasicDBObject("FirstName","xxx"));

orList.add(new BasicDBObject("LastName","yyy"));

BasicDBObject dbObj = new BasicDBObject("$or",orList);

answered Mar 14, 2016 at 8:53

Tamil Arasi

1795 bronze badges

Collectives™ on Stack Overflow

How to use "$or" operator using documents in mongodb using java

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related