Akshay A
0
const search = await searchAgent.aggregate([
{$match: {id: Number(fid), status: {$regex: status, $options: 'i'}}},
{$sort: {[order_by]: order == 'desc' ? -1 : 1}},
{$skip: skip},
{$limit: pagelimit},
])
Here I need to get the total number of documents matching the query. As I am using the limit I can't get the total count of documents.
The common approach to solve this is to use the $facet stage, then one pipeline is used to match with the proper skip and limit and one pipeline for the count.
like so:
const searchResults = await searchAgent.aggregate([
{
$match: {
id: Number(fid),
status: {$regex: status, $options: 'i'}
}
},
{
$facet: {
results: [
{
$sort: {
[order_by]: order == 'desc' ? -1 : 1
}
},
{
$skip: skip
},
{
$limit: pagelimit
},
],
count: [
{
$group: {
_id: null,
count: {
$sum: 1
}
}
}
]
}
}
])
const search = searchResults[0]?.results;
const searchCount = searchResults[0].count[0].count
const search = await searchAgent.aggregate([
{ $match: { fid: Number(fid), ...agent_details, } },
{ $facet: {
data: [{
$sort: {
[filter.order_by]: order == 'desc' ? -1 : 1 }
}, {
$skip: skip
}, {
$limit: pagelimit
}
],
total: [{$count: "total"}]
}}
])