Hello I need to insert a js variable in my projection. How to do ? The following statement does not work. Thanks for help :wink: let sensor = sensorName // I use node Driver. collection.find({ _id : ObjectID(boatId)} , { $project : { 'data.sensors.0.$$sensor' : 1} }).toArray((err , r…

[image] steevej: 'data.sensors.0.' + sensor Driver code (like the above js string concat) can be mixed with mongo code,but the driver code runs before sending the query to mongo. sensor is a js variable not a mongo variable Its helpful to use driver code to generate mongo queries many times…

Insert js variables in projection?

Working with Data

Upsylon_Developpemen (Upsylon Developpement) December 5, 2020, 7:33pm 4

Unfortunaltly no :-/ whith interpolation no more
data.sensors.0.${sensorName}

MongoDB $weeklyUpdate #14: Delightful DevHub