How to Search for an array value in MongoDB

Question

I have my collection like below

{
    "_id" : NumberLong(366),
    "_class" : "com.cts.adpart.domain.DBData",
    "file" : "xyz",
    "sample" : [
                   "a",
                   "b",
                   "c"
             ]
}

I want to search sample array based on list values Suppose now 1. my List is having values "a","c" then i want above document to be returned but, 2. if my list contains "a","d" It should not return above document.

I have tried below code but it is returning me the document even if one match is found.

List<String> sampleList = new ArrayList<String>();
sampleList.add("a");
sampleList.add("d");

query.addCriteria(Criteria.where("sample").in(sampleList));

How to change the query so that it returns document only if all values in list matches the field?

felix · Accepted Answer · 2016-12-13 07:49:22Z

1

you should use the $all operator

query.addCriteria(Criteria.where("sample").all(sampleList));

answered Dec 13, 2016 at 7:49

felix

9,3158 gold badges44 silver badges65 bronze badges

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

Comments

user1211 · Accepted Answer · 2016-12-13 07:52:53Z

0

In order to have exact match, you should query just by the elements in the array. For eg:

{"sample":['a','b','c']}

Refer here

answered Dec 13, 2016 at 7:52

user1211

1,5151 gold badge18 silver badges27 bronze badges

Comments

Wasi Ahmad · Accepted Answer · 2016-12-13 07:58:10Z

0

You should use all method of class Criteria. As this document says:

The $all operator selects the documents where the value of a field is an array that contains all the specified elements.

So, you should modify your statement as follows.

query.addCriteria(Criteria.where("sample").all(sampleList));

answered Dec 13, 2016 at 7:58

Wasi Ahmad

38.1k34 gold badges129 silver badges169 bronze badges

Collectives™ on Stack Overflow

How to Search for an array value in MongoDB

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related