Unable to query using date while passing through mongo data api. I would like to query the database to find fetch all entries at the time
The below code returns empty document
The sample db :
[{
sensorId:'1231541',
sensorTimestamp:'2022-01-28T20:14:26.223+00:00'
}]
await superagent.post(`${url}/action/${body.action}`)
.send({
dataSource: 'Cluster0',
database:'testDB',
collection: body.collection,
filter: body.filter,
sort: body.sort,
});
const config = {
action: 'find',
collection: 'testCollection',
filter: {
sensorId: '1231541',
sensorTimestamp: {
$gte: new Date('2022-01-28T20:14:26.223+00:00'),
$lt: new Date('2022-01-28T20:33:16.324+00:00'),
},
},
sort: {
name: 1,
},
};