Skip to content
Studio 3T - The professional GUI, IDE and client for MongoDB
  • Tools
    • Aggregation Editor
    • IntelliShell
    • Visual Query Builder
    • Export Wizard
    • Import Wizard
    • Query Code
    • SQL Query
    • Connect
    • Schema Explorer
    • Compare
    • SQL ⇔ MongoDB Migration
    • Data Masking
    • Task Scheduler
    • Reschema
    • More Tools and Features
  • Solutions
  • Resources
    • Knowledge Base
    • MongoDB Tutorials & Courses
    • Tool/Feature Documentation
    • Blog
    • Community
    • Testimonials
    • Whitepapers
    • Reports
  • Contact us
    • Contact
    • Sales Support
    • Feedback and Support
    • Careers
    • About Us
  • Store
    • Buy Now
    • Preferred Resellers
    • Team Pricing
  • Download
  • My 3T
search

Studio 3T Knowledge Base

  • Documentation
  • Tutorials
  • Workshops
Take the fastest route to learning MongoDB. Cover the basics in two hours with MongoDB 101, no registration required.
Start the free course

IntelliShell: Working with Query Assist off

Posted on: 15/09/2022 (last updated: 12/01/2023) by Dj Walker-Morgan

There are situations that require you to turn off IntelliShell’s Query Assist in Studio 3T. As we have noted in previous articles this can put a number of limitations on how you can interact with the resulting data.

The biggest issue however, is the limitation of un-assisted queries only being able to show the first set of results that Mongo’s shells return. The MongoDB engineers limited the results to 20 documents by default, and thus you can only see up to 20 results in the Studio 3T table. 

Take this query on our example customers collection:

Query Assist off and only 20 documents returned from this query

This will only return the first 20 customers.

Adjusting the number of results retrieved

But, we can tell the underlying Mongo shell that it should display more than 20 items. That is controlled by the DBQuery.shellBatchSize variable. If we set it to our required page size, we can then view that many results.

Let’s prefix our find with:

DBQuery.shellBatchSize=200

Setting the DBQuery.shellBatchSize with Query Assist off results in 200 documents returned

Now, the find will return and display 200 results in one page.

Do note that this is not paged or downloaded on demand as a query assisted query. You should therefore be aware of how much memory and network you may be use as you select a batch size for un-assisted queries.

Setting the number of results displayed


You will also find that the number of results displayed in a page is limited to 50 by default. That’s easy to change in Preferences.

Changing the displayed number of results

The shellBatchSize will still determine the maximum number of documents retrieved. Studio 3T will discard any documents over the Initial page size setting. For simplicity, consider synchronizing the two values when setting them.

Ideally, you should be able to use Query Assist in all circumstances. We are working hard to remove those times when you can’t. But when you can’t we hope this tip will allow you to see a lot more of your data in the Studio 3T JSON, Tree or Table views.


How helpful was this article?
This article was hideous
This article was bad
This article was ok
This article was good
This article was great
Thank you for your feedback!

About The Author

Dj Walker-Morgan

Dj has been around since Commodore had Pets and Apples grew everywhere. With a background in Unix and development, he's been around the technology business writing code or writing content ever since.

Article navigation

Related articles

  • What is Query Assist in Studio 3T? #Studio3T_AMA
  • Working with MongoDB Collections: CRUD, Count, Sort, Limit Collection Size & More
  • Working with MongoDB Data? Use These Data Masking Techniques
  • Test your skills: Working with MongoDB Views
  • Test your skills: Working with the MongoDB Aggregation Pipeline

Studio 3T

MongoDB Enterprise Certified Technology PartnerSince 2014, 3T has been helping thousands of MongoDB developers and administrators with their everyday jobs by providing the finest MongoDB tools on the market. We guarantee the best compatibility with current and legacy releases of MongoDB, continue to deliver new features with every new software release, and provide high quality support.

Find us on FacebookFind us on TwitterFind us on YouTubeFind us on LinkedIn

Education

  • Free MongoDB Tutorials
  • Connect to MongoDB
  • Connect to MongoDB Atlas
  • Import Data to MongoDB
  • Export MongoDB Data
  • Build Aggregation Queries
  • Query MongoDB with SQL
  • Migrate from SQL to MongoDB

Resources

  • Feedback and Support
  • Sales Support
  • Knowledge Base
  • FAQ
  • Reports
  • White Papers
  • Testimonials
  • Discounts

Company

  • About Us
  • Blog
  • Careers
  • Legal
  • Press
  • Privacy Policy
  • EULA

© 2023 3T Software Labs Ltd. All rights reserved.

  • Privacy Policy
  • Cookie settings
  • Impressum

We value your privacy

With your consent, we and third-party providers use cookies and similar technologies on our website to analyse your use of our site for market research or advertising purposes ("analytics and marketing") and to provide you with additional functions (“functional”). This may result in the creation of pseudonymous usage profiles and the transfer of personal data to third countries, including the USA, which may have no adequate level of protection for the processing of personal data.

By clicking “Accept all”, you consent to the storage of cookies and the processing of personal data for these purposes, including any transfers to third countries. By clicking on “Decline all”, you do not give your consent and we will only store cookies that are necessary for our website. You can customize the cookies we store on your device or change your selection at any time - thus also revoking your consent with effect for the future - under “Manage Cookies”, or “Cookie Settings” at the bottom of the page. You can find further information in our Privacy Policy.
Accept all
Decline all
Manage cookies
✕

Privacy Preference Center

With your consent, we and third-party providers use cookies and similar technologies on our website to analyse your use of our site for market research or advertising purposes ("analytics and marketing") and to provide you with additional functions (“functional”). This may result in the creation of pseudonymous usage profiles and the transfer of personal data to third countries, including the USA, which may have no adequate level of protection for the processing of personal data. Please choose for which purposes you wish to give us your consent and store your preferences by clicking on “Accept selected”. You can find further information in our Privacy Policy.

Accept all cookies

Manage consent preferences

Essential cookies are strictly necessary to provide an online service such as our website or a service on our website which you have requested. The website or service will not work without them.

Performance cookies allow us to collect information such as number of visits and sources of traffic. This information is used in aggregate form to help us understand how our websites are being used, allowing us to improve both our website’s performance and your experience.

Google Analytics

Google Ads

Bing Ads

Facebook

LinkedIn

Quora

Hotjar

Functional cookies collect information about your preferences and choices and make using the website a lot easier and more relevant. Without these cookies, some of the site functionality may not work as intended.

HubSpot

Social media cookies are cookies used to share user behaviour information with a third-party social media platform. They may consequently effect how social media sites present you with information in the future.

Accept selected