MongoJS find() returning only 10 results?

Question

i'm new to NodeJS and i'm using MongoJS to connect to my database.

All is working fine, but when i use db.collection.find() function, it returns only the first 10 results on the database.

function listMessages(from,to){
console.log("[REQ] User "+from+" asked chat with "+to);
var htext = 'Welcome to the chat<br/>';
db.messages2.find({$or:[{from_id: from, to_id: to}, {from_id: to, to_id: from}]},function(err, echoData) { 
  if( err || !echoData) console.log("No messages found");
  else echoData.forEach( function(returnData) {
  htext += returnData.from_id+": "+returnData.text+"<br/>";
  });
  io.sockets.emit('html message '+from, htext, to);
});
}

It works fine, but returns only the first 10 results on the database, even if i use limit.
I've tried to use this too, and it didnt worked:

db.messages2.find({$or:[{from_id: from, to_id: to}, {from_id: to, to_id: from}]},{},{limit: 50}, function(err, echoData) {

What I need to do to fix this? Thanks!

Scott Jungwirth · Accepted Answer · 2014-08-12T18:21:39.483

3

default limit in mongoDB is 10

from the documentation:

collection.find(query[[[, fields], options], callback]);

options - defines extra logic (sorting options, paging etc.)

Paging Paging can be achieved with option parameters limit and skip

so with a new limit:

db.messages2.find({}, {}, {limit: 1000}, function(err, echoData) {

edited Aug 12 '14 at 18:21

answered Aug 12 '14 at 18:10

Scott Jungwirth

6,105
3
38
35

I've tried, and it still returning only the first 10 results in the database. – user2241408 Aug 12 '14 at 18:12
are you sure you have more than 10 matching records? try removing your query conditions. – Scott Jungwirth Aug 12 '14 at 18:20
Yes, it have like 40 records. I've removed the or and put to search only for {from_id: from, to_id: to}. It worked fine, but with $or condition the error comes back. – user2241408 Aug 12 '14 at 18:23
It worked for now, i had a error in my from/to variables. Thanks. – user2241408 Aug 12 '14 at 18:25

MongoJS find() returning only 10 results?

1 Answers1