Find items in nested list using C# Mongodb driver

Question

I have a model like this:

Class1 
{
    public List<Class2> Class2List { get; set; }
}

Class2 
{
    public List<Class3> Class3List { get; set; }
}

Class3 
{
    public List<Class4> Class4List { get; set; }
}

Class4 
{
    public int Value { get; set; }
    public DateTime CreateDate{ get; set; }
}

I need to find a list of items of Class4 which are between two dates. I try to use below code but I need to return list of type Class4:

public async Task<IList<Class1>> GetClass4BetweenDates(string Id, DateTime fromDate, DateTime toDate)
{
    var builder = Builders<Class1>.Filter;
    var filter = builder.Eq("Id", Id) & builder.Gte("Class2.Class3.Class4.CreateDate", fromDate) & builder.Lte("Class2.Class3.Class4.CreateDate", toDate);
    return await _context.GetCollection<Class1>().Find(filter).ToListAsync();            
}

I know this is wrong. I need to know the correct way

Reza Taba · Accepted Answer · 2023-06-15 06:32:34Z

2

I think you should try this:

The only problem is in your example that you only give a create date witch elements should be bigger then and smaller then the CreateDate. This is kind off imposible.

public async Task<IList<Class1>> GetClass4BetweenDates(string id, DateTime fromDate, DateTime toDate)
{
    var filterDefinition = Builders<Class1>.Filter.Where(x => x.Id == id &&
                                                              x.Class2List.Any(a => a.Class3List.Any(b => b.Class4List.Any(c => c.CreateDate >= fromDate && 
                                                                                                                                c.CreateDate <= toDate))));
    return await _context.GetCollection<Class1>().Find(filterDefinition).ToListAsync();            
}

Also, to only return the class4 types you can do the following:

public async Task<IList<Class4>> GetClass4BetweenDates(string id, DateTime fromDate, DateTime toDate)
{
    var filterDefinition = Builders<Class1>.Filter.Where(x => x.Id == id &&
                                                              x.Class2List.Any(a => a.Class3List.Any(b => b.Class4List.Any(c => c.CreateDate >= fromDate && 
                                                                                                                                c.CreateDate <= toDate))));
    var class1 = await _context.GetCollection<Class1>().Find(filterDefinition).ToListAsync();  

    var class4List = new List<Class4>();

    if (class1 == null)
        return class4List; 

    foreach (var class2 in class1.Class2List)
    {
        foreach (var class3 in class2.Class3List)
        {
            if (class3.Class4List.Any())
                class4List.AddRange(class3.Class4List);
        }
    }

    return class4List;       
}

edited Jun 15, 2023 at 6:32

Reza Taba

2,0441 gold badge22 silver badges24 bronze badges

answered Mar 16, 2019 at 10:33

StuiterSlurf

2,5906 gold badges42 silver badges60 bronze badges

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

4 Comments

amin mohammadi Over a year ago

Great!! how can I convert the return type to List<Class4>?

StuiterSlurf Over a year ago

you want to combine all list 4 elements?

StuiterSlurf Over a year ago

Or only the first list4 you encounter?

amin mohammadi Over a year ago

Yes, I want to gather all Class4 types of all Class3 types

Collectives™ on Stack Overflow

Find items in nested list using C# Mongodb driver

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related