Given that every sensorsData
document includes dates:
{
"_id": {"$oid":"5f1957c7cdf25116937ed3ef"},
"idSensor": {"$numberLong":"3"},
"idDevice":{"$numberLong":"48"},
...
"data":
{
"inicio":"2019-11-28T16:09:08+01:00",
"fin":"2019-11-28T16:09:18+01:00",
...
},
...
}
I’m trying to add them as filters to my original query, within the second $match
:
[
...
{
"$match":
{
"$expr":
{
"$and":
[
{"array.idSensor": 3},
{"$gt": ["array.data.inicio", "ISODate('2021-02-28T23:59:59+01:00')"]},
{"$lt": ["array.data.fin", "ISODate('2021-03-15T00:00:01+01:00')"]}
]
}
}
},
...
]
But I’m getting this error message:
“FieldPath field names may not contain ‘.’.”
What is it about?