MongoDB C# Driver Find Object which contains an Obj in an Array with a certain value that meets certain criteria

Question

I've got a mongo object that follows this pattern. Actions is an array of objects. I've excluded the irrelevant fields.

{
  "_id" : 141,
  ...
  "Actions" : [{
      ...
      "Modified" : new Date("Thu, 29 Nov 2012 14:41:20 GMT -08:00"),
      ...
    }]
  ...
}

How do I query this so that I can get a list of objects which contain an object in the actions array who's modified property falls between a date range using the C# Mongo Driver.

TGardner · Accepted Answer · 2013-02-26 21:43:53Z

1

I figured this out myself.

Query.ElemMatch("Actions",
    Query.And(
        Query.GTE("Modified", start),
        Query.LTE("Modified", end)
    )
)

Using a Query.ElemMatch against the Actions field passing in the Query for the Sub Elements.

Worked like a charm.

answered Feb 26, 2013 at 21:43

TGardner

1763 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

MongoDB C# Driver Find Object which contains an Obj in an Array with a certain value that meets certain criteria

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