MongoDB and .NET: Filter on specific field in child array using FilterDefinition

Question

I have a class which creates a list of filters from an input. The filters are found by calling a function for each filter like this:

public void created_after(string date)
{
    DateTime convertedDate = Convert.ToDateTime(date);
    filters.Add(Builders<User>.Filter.Gte(x => x.Created, convertedDate));
}

Now i need to segment on a field on a child array on the user. In this case, i just need to know if any alert has a Created value higher than a given date. My data looks like this:

{ 
    "DisplayName" : "PestisanRadu", 
    "Alerts" : [
        {
            "UserId" : ObjectId("577a26a12b365917c4d67dd5"), 
            "Created" : ISODate("2016-10-05T09:17:44.382+0000")
        }, 
        {
            "UserId" : ObjectId("577a26a82b365917c4d68009"), 
            "Created" : ISODate("2016-10-05T18:44:45.743+0000")
        }
    ], 
    "Created" : ISODate("2016-10-05T09:17:43.423+0000")
}

For the class to work, i need to keep the FilterDefinition type.

vincentluth · Accepted Answer · 2016-10-06 11:46:53Z

1

Use other same method which take FieldDefinition as parameter, in your case would be

filters.Add(Builders<User>.Filter.Gt("Alerts.Created", convertedDate));

Note that the string "Alerts.Created" is FieldDefinition

answered Oct 6, 2016 at 11:46

vincentluth

1495 bronze badges

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

1 Comment

DalekSall Over a year ago

Thank you, this works. How come i dont have to specify that it only needs to have one alert which satisfy the criteria?

Collectives™ on Stack Overflow

MongoDB and .NET: Filter on specific field in child array using FilterDefinition

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