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

The Value of Value Search – A Christmas Tale

Posted on: 14/12/2021 (last updated: 22/06/2022) by Dj Walker-Morgan

Twas the night before Christmas and all through the Data warehouse there was yelling and shouting. 

“Why did you let this happen?” cried one voice. 

“Head office said the AI-powered schema designer would just take all our incoming documents and structure them in a MongoDB database efficiently,” a more patient voice explained, pointing at the screen.

“I can see! We now have hundreds of databases, thousands of collections and”, clicking on a mouse which had been barely stirring, “The most bizzare higgledy piggledy mess of arrays and embedded documents you’ve ever seen”.

“But surely we can query them somehow? We have to find all the records for Project Santa so we can get them to our client by tonight.”

“It’ll take too long!”

“Ah, but I have just the thing here” a third voice said.

“Studio 3T’s new Value Search. If I just point it at the server, enter “Santa” in the search field and…” he paused “… there… every reference to Santa anywhere in any database, collection, document, array or object….”

The Search for Values

It may sound like a Christmas miracle but Value Search has arrived in Studio 3T. In the just -released version, 2021.10, this new feature changes everything about how you search for data in your MongoDB. So what is Value Search? Essentially, it’s a powerful way to search everything on your server.

Your MongoDB server contains databases and within those, collections. You’ll be used to searching in collections for data using the Collections view in Studio 3T. Or you’ll be familiar with the find() command at the MongoDB API level. Searching like that sets a scope on where to look, the collection itself, and the named fields. When you are writing code for an application, that’s logical and great. 

Is that value you are looking for is buried deep inside an array or embedded document? Or is it inside an embedded document in an array in an embedded document. It could be in a rarely queried collection created and forgotten? … If it is, then your query gets more complex. As it does so it becomes harder to come up with queries that will catch everything. If you are just browsing for data, that is a lot of work.

Let’s take this further. Imagine you have a mess of unstructured data, scattered through collections and even spread across multiple databases. And then you need to find where some string is stored throughout that data, where do you even start? 

Enter Value Search

With Value Search, you can now search through everything. Go to the server, database, or collection you are interested in in Studio 3T and open the Value Search tab using the right click menu. That selection sets the initial scope of your search. Open Value Search on a server and you will search all databases and collections. When you open it on a database the you’ll search all collections in that database. Opening it on just a collection will search all all documents in that collection.

You can now give the search something to search for. Use the toggle button to the right of the search field to control Search options. The regular expression option lets you be super precise about what you want to match with, while the case sensitivity option lets your search match things in upper and lower case. And if you are wondering about numeric values and other non-string types, we convert all the values to string representations and search the string. Once you’ve entered your search term, hit return or click search and the clever bit happens.

The results you get back will come from every nook and cranny of the MongoDB databases you’ve selected. It’ll dig down into any arrays or embedded documents checking every value in the documents it searches for a match and returns to you what it found. That includes what database, collection and document it was in and the path to find that data within the JSON document. No element will be left unsearched. 

Beyond Value Search

Results start appearing as soon as the search locates them. You don’t need to wait for the search to complete and Value Search doesn’t block you from working with the results as soon as you have them. You can click the stop button next to the progress meter if you have found what you are looking for. Or you can inspect the results as it searches. Double clicking on any result zooms in on the enclosing document’s JSON. That means you view a result immediately and in context.  And remember,  if you want you can copy the JSON results into another application or another collection in Studio 3T. The latter is especially useful if you are restructuring all Project Santa’s collections. 

If you want to zoom out to the enclosing collection the document is in, right click on the result and select Open in Collections Tab. A new Collections view will open with a query selecting the particular result. You can now use the Visual Query Builder and the resulting document to explore the collection.

When you are developing queries for a newly imported collection of data, Value Search can help you explore just that collection and help you map out the underlying structure in your data. That’s what helped our friends at the data warehouse work out where the misfiring AI put all the data and with the help of Studio 3T’s Reschema, they set about getting it all in the right shape for Project Santa’s gift delivery system.

So in this tale, Value Search saved Christmas, and it’s already in your latest Studio 3T 2021.10 update so it could help you everyday too. Enjoy the magic of searching everything inside a MongoDB server this Christmas. 

Download and try all of Studio 3T’s features today with the 30 day free trial.

Try Studio 3T


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.

Related articles

  • Search In… (aka Value Search)
  • What’s New in Studio 3T 2021.10 | Value Search, Better Task Scheduling and Import Data Masking
  • Studio 3T Christmas Competition: Win a year of Ultimate
  • The Value of a Regular Expression: #Studio3T_AMA
  • What’s New In Studio 3T 2022.8 – IntelliShell Script Tasks and Enhanced Value Searches

Tags

2022 academy aggregation AMA atlas Certification christmas community connections culture date tags events export features hackolade import intellishell In Use JSON knowledge base migration modelling mongodb mongoodb mongosh My 3T productivity product management query regex releases schema security SQL Studio 3T tasks time series tips updates webinar windows

Browse by MongoDB topic

  • Connecting to MongoDB
  • Database Administration & Security
  • Getting Started with MongoDB
  • Getting Started with Studio 3T
  • Import/Export
  • Job Automation & Scheduling
  • MongoDB Aggregation Framework
  • MongoDB/Studio 3T Workshops
  • Performance
  • Query & CRUD Operations
  • Reference
  • Schema
  • Studio 3T Licensing
  • Support and other resources
  • Working with MongoDB & SQL
  • Working with MongoDB Atlas

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

Reddit

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