According to Between dates using the Waterline ORM SailsJS , you can query between dates in the Waterline adapter as follows:
User.find({
createdAt: { '>': dateFrom, '<': dateTo }
}).exec();
However, this only works with date formats such as 2018-04-11 . Somehow you can use the full ISO8601 date format in this query: for example. 2018-04-11T12: 45: 00.000Z
EDIT: Added a minimal working code example.
readDataInDateRange: function(req, res) {
var dateFrom = req.param("dateFrom");
if (dateFrom == null || dateFrom == ''){
return res.badRequest();
}
var dateTo = req.param("dateTo");
if (dateTo == null || dateTo == ''){
return res.badRequest();
}
User.find({createdAt: { '>=': dateFrom, '<=': dateTo}})
.exec(function afterwards(err, users) {
if (err) {
sails.log(err);
return res.serverError(err);
}
return res.ok(users);
});
}
source
share