MongoDB Java search array size

Question

Using MongoDB Java driver, I would like to find all entries where an array field contains at least 2 entries. What I have tried:

myCollection.find(new Document("arrayFieldname.length", new Document("$gt", 1)));

Unfortunately this returns no entry.

Should the approach be different?

Many thanks, Tom

helmy · Accepted Answer · 2016-06-25 22:20:19Z

2

Use can the $size operator, but that doesn't work for ranges.

The best thing to do is to add a field to the document that tracks the array size, and query based on that. The bonus with that approach is that you could index on that field.

answered Jun 25, 2016 at 22:20

helmy

9,5673 gold badges36 silver badges31 bronze badges

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

1 Comment

K. Symbol Over a year ago

But how to query in Java?

Collectives™ on Stack Overflow

MongoDB Java search array size

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related