C# MongoDB Driver filter subdocument list based on incoming array

Question

I have the following C# model structure:

public class Box
{
    [BsonId]
    [BsonRepresentation(BsonType.ObjectId)]
    public string? Id { get; set; }

    [BsonElement("relatedJobs")]
    public List<BoxJobs> RelatedJobs { get; init; } = default!;

    //more properties

    public class BoxJobs
    {
        [BsonElement("partnerId")]
        public string PartnerId { get; init; } = null!;
        
        //more properties
    }
}

There is a need to filter all the boxes based in an incoming partnerIds array. In other words I want to retrieve every single box that has at least one relatedJob with its partnerId present in the incoming array.

I've tried the following:

var builder = Builders<Box>.Filter;
var filter = new FilterDefinitionBuilder<Box>().Empty;
filter &= !partnerIds.Any()
        ? new FilterDefinitionBuilder<Box>().Empty
        : builder.AnyIn(box => box.RelatedJobs.Select(relatedJob => relatedJob.PartnerId), partnerIds);
var cursor = Collection.Find(filter);

This results in the following error:

Unable to determine the serialization information for box => box.RelatedJobs.Select(relatedJob => relatedJob.PartnerId).

I have also tried creating a PartnerIds property in Box which returns the same Select result, and use it in the AnyIn function but it didn't help either.

How can I do this filtering?

Vadim Martynov · Accepted Answer · 2023-02-13 08:50:13Z

1

As I can see you need to check that RelatedJobs contains a job pith PartnerId from partnerIds list. Fields.ElemMatch method returns the first matching element in the array specified by name.

var builder = Builders<Box>.Filter;
var filter = new FilterDefinitionBuilder<Box>().Empty;
filter &= !partnerIds.Any()
        ? new FilterDefinitionBuilder<Box>().Empty
        : builder.ElemMatch(x => x.RelatedJobs, j => partnerIds.Contains(j.PartnerId));
var cursor = Collection.Find(filter);

answered Feb 13, 2023 at 8:50

Vadim Martynov

8,9705 gold badges37 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

C# MongoDB Driver filter subdocument list based on incoming array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related