Complex query filtering of object arrays in MongoDb (C# Driver)

Question

Let's say I have this document.

"Id" : "lot1",
"Fruits" : [
       [{ "Id": "fruit1", "Name": "apple"}, { "Id": "fruit2", "Name": "carrot"}]
       [{ "Id": "fruit3", "Name": "banana"}]
     ]

Q: How can I query the Fruits array by a list of fruits names ?

I have tried like this:

var fruitNames = new List<string>(){ "apple", "banana" };
var builder = Builders<Lot>.Filter;
var filter = builder.AnyIn(l => l.Fruits.Select(f => f.Name), fruitNames); //TAKE 1
var filter = builder.Where(l => l.Fruits.Select(f => f.Name).Any(f => fruitNames.Contains(f)));//TAKE 2
var filter = builder.AnyIn("Fruits.Name", fruitNames );//TAKE 3
var results = mongoContext.Lots.Find(filter).ToList();

I have tried this in 3 different ways with no success.

BOR4 · Accepted Answer · 2017-09-27 09:29:04Z

2

Can you try this? It is a little hack but i am pretty sure it will work:

var filter= Builders<Lot>.Filter.ElemMatch(y => y.fruits, x => fruitNames.Contains(x.name));

answered Sep 27, 2017 at 9:29

BOR4

6304 silver badges9 bronze badges

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

2 Comments

Misi Over a year ago

If the current "Fruits" array would be an singular object, how would the query modify ? var filter = Builder<Lot>.In(l => l.Fruits.Name, fruitNames); // doesn't work

BOR4 Over a year ago

did you sort it out or you still need help @Misi?

Collectives™ on Stack Overflow

Complex query filtering of object arrays in MongoDb (C# Driver)

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related