How to print out more than 20 items documents in MongoDB s shell

Question

db foo find   limit 300    won t do it  It still prints out only 20 documents   db foo find   toArray   db foo find   forEach printjson    will both print out very expanded view of each document instead of the 1-line version for find

User · Answer

You can use it inside of the shell to iterate over the next 20 results  Just type it if you see  has more  and you will see the next 20 items

User · Answer

DBQuery shellBatchSize   300     will do   MongoDB Docs - Configure the mongo Shell - Change the mongo Shell Batch Size

User · Answer

In the mongo shell  if the returned cursor is not assigned to a variable using the var keyword  the cursor is automatically iterated to access up to the first 20 documents that match the query  You can set the DBQuery shellBatchSize variable to change the number of automatically iterated documents   Reference - https   docs mongodb com v3 2 reference method db collection find

User · Answer

I suggest you to have a    mongorc js file so you do not have to set the default size everytime      execute in your terminal  touch    mongorc js  echo  DBQuery shellBatchSize   100    gt     mongorc js    add one more line to always prettyprint the ouput  echo  DBQuery prototype  prettyShell   true     gt  gt     mongorc js   To know more about what else you can do  I suggest you to look at this article  http   mo github io 2017 01 22 mongo-db-tips-and-tricks html

User · Answer

Could always do   db foo find   forEach function f  print tojson f      true         To get that compact view   Also  I find it very useful to limit the fields returned by the find so   db foo find     name 1   forEach function f  print tojson f      true         which would return only the  id and name field from foo

User · Answer

From the shell if you want to show all results you could do db collection find   toArray   to get all results without it

[mongodb] How to print out more than 20 items (documents) in MongoDB's shell?

Examples related to mongodb