TotalDocs returning 0 while there is result

[yuqing630]

    when trying to run this 

somthing.paginate(filters, options, (error, result) => {
if (error) {
errorHandler(res, error);
} else {
res.status(statuses("ok")).send({
result.docs,
result.totalDocs
});
}

option={ populate: [ 'images' ],
sort: { 'date.created': 'desc' },
limit: 100,
offset: 0 }

mongoose version
"mongoose": "~5.6.9",
"mongoose-paginate-v2": "^1.3.0",

as you can see from the screen shot they are returning 2 result but the total docs 0

[aravindnc]

@yuqing630 Can you share the query used in filters.

The format is: Model.paginate([query], [options], [callback])

[yuqing630]

 "filters": {
                    "id": {"$in": ["0123456789abcdef01234567", "1123456789abcdef01234567"]},
                    "product": { "$in": ["4839"]}
                },

[aravindnc]

@yuqing630 Can you try this in the new version.

[yuqing630]

ok will do

[ingvarr6]

Hi @aravindnc. I ran into a similar problem. If in the option add

collation: {
  locale: 'en_US',
  numericOrdering: true
}

My query looks like this:
{'price.forsale': {'$gte': '0', '$lte': '1000000'}}

then the number of documents is calculated incorrectly, it seems that because when the counting of the found documents is in progress, the collation does not apply

mongoose-paginate-v2/src/index.js

Line 105 in 05a8a98

const countPromise = this.find(query).exec();

The idea should be like this:
const countPromise = this.find(query).collation(collation).exec();

[aravindnc]

@ingvarr6 I've just tested with 1,00,000 rows of data and it is working fine with v1.3.1.
I'm correctly getting the totalDocs count.

[aravindnc]

@ingvarr6 I've added collation to the new version. Thanks for pointing out.

[aravindnc]

@yuqing630 @ingvarr6 Please feel to reopen this thread if the issue exists.

[lingo]

I'm seeing the same problem as @ingvarr6 with version 1.3.14. When I ensured the collation is applied before the count call, then the results are correct. Otherwise, I get 0 results.