The MongoJS Query Analyzer is another powerful tool in Aqua Data Studio that can execute JavaScript commands against one of the most widely adopted NoSQL database management systems. The JavaScript statements and queries normally run within a MongoDB shell command-line interface and can be typed and executed within the MongoJS Query Analyzer (CTRL+E). The MongoJS Query Analyzer shows the results in a tree hierarchy, grid, and text results. We've combined all of our easy-to-use and features in Query Analyzer functionality to MongoJS Query Analyzer. This includes statement auto-completion and syntax highlighting. The MongoJS Pretty Print JSON is another new feature that allows you to display the JSON result in an easy-to-read format.

When queries are executed in the Query Analyzer, their results can be displayed in several ways: text, text history, grid, and pivot grid. The contents of the Query Analyzer can be saved in different formats and encodings, allowing it to be re-used as scripts within Aqua Data Studio or for emailing and sharing. Any of the commands executed from within the Query Analyzer can also automatically be stored in The SQL History.

Shortcuts:

  • CTRL+E to execute the JavaScript commands in the Query Analyzer
  • CTRL+ALT + ENTER to execute edits in the current query, it allows the use of Table Data Editor

Tree View Results

MongoDB uses JSON documents to store records which automatically creates a hierarchy of your data. We've created a tree view to help you navigate your document hierarchy. We also offer options to Expand Recursively and Collapse Recursively, the hierarchy along with a Copy JSON feature.

Commands not supported for MongoDB 4.4.7 and 4.4.8 - $indexStats, $planCacheStats, setIndexCommitQuorum, balancerCollectionStatus, $meta, shouldMultiDocTxnCreateCollectionAndIndexes, db.collection.hideIndex, and db.collection.unhideIndex.



  • No labels