Robomongo: Document Limit

[johntom]

Hi,
Not sure if I'm doing anything wrong but how can I change the 50 documents limit when I try to view documents.
I have 1200 documents in my podetail collection and db.podetail .find() retrieves 50 docs as does db.podetail .find().limit(500). FYI, the navagtor options (0,50.. 51,100) wont bring up the records either.
TIA
John

[johntom]

I just noticed that the navigator displays the next 50 records when pressing > but the documents remain numbered 0 thru 49 which is somewhat confusing, Can the limit be changed?

[schetnikovich]

Hi John,

Currently, this limit is hardcoded to 50. Thanks for giving us this remainder! We will remove this limit in next releases.

As temporary workaround, you can execute the following command:

DBQuery.shellBatchSize = 500;

This will make batch size equal to 500, but you still be unable to use < and > buttons - they will do paging using 50 as max number of documents to fetch.

This command needs to be executed in every tab, where you want to extend this limit.

[schetnikovich]

In just released 0.8.1 you now able to set Batch Size (globally and for specific query).

Read more about it here:
http://robomongo.org/whats-new-in/robomongo-0.8.1.html

Let me know if this does not work for you.

[claudiuconstantin]

"what's new in 081" link is broken, the correct one is here.

[juliashibalko]

@claudiuconstantin thanks a lot for for reporting!
Version 0.8.1 is not currently supported. So let me advise to check the latest Robomongo version 0.9.0.
Please see the features list here: http://blog.robomongo.org/robomongo-0-9-0-final/

[jcollum]

For anyone who finds this thread, even though this issue is closed, the batchSize setting appears to be ignored. Set it to 200 in the json, closed rm, reopened, no change when I ran a query, still get 50 records.

v0.9.0

Issue should be reopened.

[simsekgokhan]

Hi @jcollum, I have just tested with 0.9.0, and it worked fine for me.
Make sure Robomongo closed, change batchSize to 200, open Robobomongo, run a query e.e. find all documents.

Can you share the steps to reproduce your problem?
Please also specify your OS version.

[glynj-bsquare]

I have tried to change the default batch size, and found it makes no difference. I had to create the config file as it doesn't exist by default.
$ cat ~/.config/robomongo.json
{
"batch_size":100
}
Start version robo3t-1.1.1-linux-x86_64-c93c6b0.
Query all records on any collection with > 50 documents, and I still see only 50 on the first page.

Running on Ubuntu 16.04.3
Note - I had to run a hack to get the program to start at all:

mkdir ~/robo-backup
mv robo3t-1.1.1-linux-x86_64-c93c6b0/lib/libstdc++* ~/robo-backup/
robo3t-1.1.1-linux-x86_64-c93c6b0/bin/robo3t

as described at https://github.com/Studio3T/robomongo/issues/1384

[davidm06]

DBQuery.shellBatchSize = 500; worked for me thanks !

[sudeepdk]

DBQuery.shellBatchSize=500; its working in only case where shell is not closed every time you open shell in Robomongo , it will be 50 by default
to check default BatchSize run DBQuery.shellBatchSize it will return 50 then run DBQuery.shellBatchSize=500; it will return => 500 then fire your get collection get query in same shell => db.getCollection('users').find({})

ref= https://docs.mongodb.com/manual/tutorial/configure-mongo-shell/

[Rustam-Nych]

This issue is actual for me, tried to launch this _DBQuery.shellBatchSize=500;_ command several times but the pagination is still 50. Can someone help me with it, it so annoying.

[simsekgokhan]

@Rustam-Nych
Have you tried changing "batchSize" : 50, in Robo config file "robo3t.json"?

See:
https://github.com/Studio3T/robomongo/wiki/Robomongo-Config-File-Guide

Important: Make a copy of config file before editing it.
Close Robo 3T
Change "batchSize" in config file and save file. 
Open Robo 3T 

[deeTEEcee]

@Rustam-Nych So I could be wrong but at this point, here's my interpretation. You have the following:

1. Some pagination default setting (This is not something we can configure)
2. Some internal mongo shell size (either DBQuery.shellBatchSize=500 or the new update specifying you add batchSize to ~/.config/robomongo.json (https://github.com/Studio3T/robomongo/issues/203#issuecomment-257282439))

You've likely configured #2 but #1 is still something you have to manually change once you open Robomongo. I personally would've fixed that as well if I was a developer here but 🤷‍♂

[deeTEEcee]

From the update link:

Specifying more than 100 for Batch Size is highly debatable

That seems like an unusually low number to be concerned about. I have some pretty hefty docs with over 400 million rows. I bump up to 1000 and don't recognize any issues.

[deeTEEcee]

Okay, here's another issue. I just tried an aggregate pipeline query with the pagination past 50 and it just craps out.