Extended $lookup

[steevej (Steeve Juneau)]

Both worded differently but meaning the same.

@steevej

But if it is a frequent use-case you might consider adding the group field to the data historic.

@NeNaD

You are currently storing idDevice in the sensorsDataHistoric collection. But in additional, you can also add one new field which will be groupDevice . It will duplicate the date from devices collection, but that will be big optimization since you can query everything that you need without the $lookup to the devices collection.