Bellow my code. Use MONGOOSE, NODEJS / TYPESCRIPT. The COMPANY parameter have a valid value to obtain the result, but I get empty array. Can anybody help me? Thanks in advanced.
company = company.replace('.', '');
company = company.replace('.', '');
company = company.replace('-', '');
company = company.replace('/', '');
try {
const result = await cteModel.aggregate([
{
$addFields': {
date': {
$dateFromString': { 'dateString': '$dataEmissao' }
}
}
},
{
$match: { 'empresa': company }
},
{
$sort: { date: -1, _id: 1 }
}]);
res.status(200).send(result);
} catch (error) {
console.log(error);
return res.status(500).json(error);
}