C# Mongo Filter Builder - nested array of objects - filter any docs where value of a specific property matches with one of the values in an array

Question

I have a mongo collection (of <BsonDocument>) who could look like this:

{
  "someProperty1": "someValue1",
  "users": [
   { "name": "[email protected]", "displayName" : "Sample User" }
   { "name": "[email protected]", "displayName" : "Another User" }
  ]
},
  "someProperty2": "someValue2",
  "users": [
   { "name": "[email protected]", "displayName" : "Test User" },
   { "name": "[email protected]", "displayName" : "Another User" },
  ]
},
  "someProperty3": "someValue3",
  "users": [
   { "name": "[email protected]", "displayName" : "Another User" }
  ]
}

I want to filter with an IEnumerable of strings, that contains a set of name and want to get every document where at least one of the names in users is matching.

For example i would have Array filterArray with the following Value:

["[email protected]", "[email protected]"]

with this i want to build a FilterDefinition filter and after appling it:

await mongoColletion.Find(filter).ToListAsync()

It should have the following output (as IEnumerable<BsonDocument>):

[
  {
  "someProperty1": "someValue1",
  "users": [
     { "name": "[email protected]", "displayName" : "Sample User" }
     { "name": "[email protected]", "displayName" : "Another User" }
   ]
  },
  "someProperty2": "someValue2",
  "users": [
     { "name": "[email protected]", "displayName" : "Test User" },
     { "name": "[email protected]", "displayName" : "Another User" },
    ]
  }
]

How can I build this FilterDefinition?

Murat Acarsoy · Accepted Answer · 2022-06-10 13:39:37Z

You can use $elemMatch and $in

db.productList.find({
    users: {
        $elemMatch: { 
            name: {
                $in: ['[email protected]', '[email protected]' ]
            }
        }
    }
});

In C#

var coll = db.GetCollection<BsonDocument>("collection_name");
var result = coll.Find("{ users: { $elemMatch: {name: { $in: ['[email protected]', '[email protected]' ] }  }  } }").ToList();

Or with Builder

List<string> list = new List<string>() { "[email protected]", "[email protected]" };
var filter = Builders<BsonDocument>.Filter.ElemMatch("users",
        Builders<BsonDocument>.Filter.In("name", list));

Or with data model:

[BsonIgnoreExtraElements]
public class Model
{
    [BsonElement("users")]
    public User[] Users { get; set; }
}

public class User
{
    [BsonElement("name")]
    public string Name { get; set; }
    [BsonElement("displayName")]
    public string DisplayName { get; set; }
}

You can use this filter with data model

List<string> list = new List<string>() { "[email protected]", "[email protected]" };
var filter = Builders<Model>.Filter.ElemMatch(m => m.Users, 
    Builders<User>.Filter.In(u => u.Name, list));
var coll = db.GetCollection<Model>("collection_name");
var result = coll.Find(filter).ToList();

DaveVentura · Accepted Answer · 2022-06-10 13:00:18Z

0

I found it out by myself:

var filter = Builders<BsonDocument>.Filter.AnyIn("users.name", filterArray);

answered Jun 10, 2022 at 13:00

DaveVentura

8001 gold badge12 silver badges24 bronze badges

Collectives™ on Stack Overflow

C# Mongo Filter Builder - nested array of objects - filter any docs where value of a specific property matches with one of the values in an array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related