Mongovue Query Examples

Mongovue Query Examples.js

// Querying arrays by their size
{
  "Field1": {$size: 0}
  "Field2": {$not: {$size: 0}} 	
}

// Querying nested fields using a unique identifier
{
  "Events.Payload.Body._t" : "EventType",
  "Events.Payload.Body._id" : CSUUID("2267495d-63e3-4aa3-ae67-86372a7968fd")
}


// Aggregate with lots of examples of different queries.. 
{ $match : { "Risk.contactDetails.outBoundingOptIn" : "True" } },
{ $match : { "CommencedAt" : { $gte : ISODate("2014-01-14T00:00:00.000Z"),
							$lt: ISODate("2014-01-15T00:00:00.000Z")  }  }},
{ $unwind : "$Quotes" },
{ $match : { "Quotes.Brand" : { $in :["AHH3", "HLF3", "SNN3"] } } },
{ $match : { "Quotes.Position" : { $in :[1, 2] } } },
{ $group : { _id : "$Quotes.Brand",
			 count : { $sum : 1 }}},