iot.mongodb

// MongoDB Playground
// To disable this template go to Settings | MongoDB | Use Default Template For Playground.
// Make sure you are connected to enable completions and to be able to run a playground.
// Use Ctrl+Space inside a snippet or a string literal to trigger completions.

// Select the database to use.
use('iot');

// Find any bucket document with a measurement where pressure >= 1040
db.schema_demo5.find({'measurements.pressure' : { '$gte' : 1040 }})

// Find any bucket document with a measurement where pressure >= 1040 and filter the sub measurements to only include those readings
// db.schema_demo5.aggregate(
//     [
//       {
//         $match: { "measurements.pressure" : { $gte : 1040 } }
//       }, 
//       {
//         $project: 
//           {
//             measurement : 
//               {
//                   $filter : 
//                   {
//                     input : "$measurements",
//                     as : 'item',
//                     cond : { $gte : ['$$item.pressure', 1040] }
//                   }
//               },
//             sensor_id : 1,
//             count : 1
//           }
//         }
//       ]
// )