Compass
41 results found
-
Changes in the objectID which is unique.1
Hi,
This is the basic suggestion from my side.we have a unique "_id" in each document while inserting the data can we make any changes in your code for example in our company we have one scenario while working on the aggregation query they need auto-generated value in numbers so it is not possible in the MongoDB.
so I thought we can do that thing based on the _id. because we have a unique field then i converted the _id to string and separated the numbers and alphabetic separately but we don't have unique values the after separating the numbers…
1 vote -
saved queries with date difference
When saving a query that was performed wit ha relative time
( e.g.,
{$gt:new Date(Date.now() - 246060 * 1000)}}
)
Save it (to history and to favorites) with the relative expression. Currently, the expression is first calculated to an actual date and only than is it saved (so the queries are saved with actual date and are less useful)3 votes -
Do not load collection data by default (new setting)
When selecting a collection, Compass currently loads data for that collection. I would like there to be a setting that says that no data is loaded until I click Find.
Why?
- because some default data loading takes a looong time (>30s) and clicking Stop doesn't give the user back control (fixing this might be another way to resolve this issue)
- almost always the data loaded by default is not relevant to my task
- almost always I want to enter a specific query first and then hit search
- in the rare cases where I just want to…2 votes -
Query console like the one in Datagrip
We need a query console like the one in the Datagrip IDE from JetBrains so that we can make any query as well as add comments or saving all these queries in the MongoDB Compass
1 vote -
copy query to shell
Copy Find or Aggregation Pipeline queries directly to embedded shell. I realize you can export the query then paste it in the shell, but a nice helper would be to click a button which tells the shell to use the current collection and pastes a well-formatted query from the Documents, Schema, or Aggregation tabs of Compass directly into the shell (without executing). At least a copy to clipboard (shell format as default) button.
4 votes -
Explain Plan and query to work on all valid queries -- if an official driver works the Compass should be able to help debugging
Mongo Compass Explain Plan cannot work on queries which are using common Java available syntax. Having no way to use Explain Plan on valid queries, without modifying the query, should be a feature.
{ "_id" : { "$in": [{ "$binary" : "6Uk1UVZWl+krPObxzA3wtg==", "$type" : "03" },{ "$binary" : "60Xp1sJ9nMiT6cPy3GA1ig==", "$type" : "03" }] } }should be a valid query in Mongo Compass since it is in Java AND the following error which is returned from both query area and Mongo Compass Explain Plan should not occur for such a query:
cannot nest $ under $inOne should NOT have…
1 vote -
Make it easier to search by _id
More then half of my queries in Compass is searching by id. Each time I have to add both curly brackets, then type 'id:' then 'Obj', select ObjectId from autocomplete and paste id.
I propose to add 'id' field in OPTIONS, where I could just paste _id string to fire mongoose-like 'findById'2 votes -
New query from text
It would great to have a feature that allows importing a query from text in compass similar to the aggregation pipeline from text feature. Currently if someone has a long multiline find query which includes filter, project, sort methods then the user needs to copy each of the query segments separately and paste them into designated lines in the expanded query options view.
Importing queries from text would improve support team's efficiency that utilise the compass when trying to analyse application queries manually.1 vote -
Include curly brackets by default in query bar
By default, the query editor is blank. In order to write a query, curly brackets must be added {query: "here"} in order to make a query.
Event the suggestion for writing a query recommends adding curly brackets. (see suggested.png)
If there is a use case where users may want the query bar to remain blank (how it is now), I recommend adding a setting to put in curly brackets by default. Having to add curly brackets every time I want to create and run a query is tedious and counterproductive.
2 votes -
Execute Raw query with query editor
Currently there is no query editor for executing raw queries, like for batch update and batch delete. Consider to add a query editor.
48 votes -
Enabling LUUID, NUUID in filters
With https://jira.mongodb.org/browse/COMPASS-1083, support was added for the UUID in filters and expressions, as well as the bindata type. It would be very useful to also have direct support for NUUID and LUUID identifiers in filters, so that you don't have to do manual conversion before querying such data.
An example query could be {uuid: NUUID('e6e71462-a5a6-4348-b4b5-22d4763462d1')}
15 votes -
Reverse sort order by default
I was a big RockMongo user and am now trying to switch over to Compass. I found it extremely convenient that in RockMongo, the default sort order was {_id: -1} because that means that you see the most recent records first. I didn't realize how useful this was until I discovered that Compass sorts in forward order. Either a "reverse order" button or simply a change to the default would be highly desireable.
63 votes -
Filter By Hexadecimal
When filtering by number, it would be nice to be able to filter by Hex (Base16) and Binary (Base2) values (ie. { field: 0x12345678 } or { field: 0b10101010 }.
2 votes -
10 votes
-
As a developer using extended JSON strict mode queries, I need Compass to also support queries in strict mode
Compass should support extended JSON strict mode queries in queries on the Documents, Schema and Explain Plan tabs.
As an example, the error message in Compass 1.14.7 for an "$oid" query is:
unknown operator: $oid
4 votes -
Kill switch for Aggregation Pipeline queries
This would be useful for working with big collections(10 mil+).
When i define aggregation pipeline in Compass, and increase timeout to some high value(because it's big collection so the pipeline can easily run for minutes and let it run, and than while it's running i change some of the stages to something else - due to that intentionally big timeout, i have to now wait before the first query ends, and then try to run the new one.
A kill switch, either manual or automatic on stage change would help with this
2 votes -
Cast _id: number to string
Every time I type { _id: 12345 } in the Filter, I get zero results, until I realize that I forgot the quotes. Could Compass automatically convert numeric _id values to strings before running the query?
1 vote -
Add a "expand all" button in front a of a document
The idea is to be able to see a document completely with a single click. When a document has a lot of arrays and object it's very long to drill down to find correct data.
3 votes -
Support for distinct
Add support distinct queries in Compass.
https://docs.mongodb.com/manual/reference/method/db.collection.distinct/5 votes -
Display/use escaped characters like "\n" for line break in document editor
I have text fields that may contain "invisible" special characters like a line-break, which is commonly represented as "\n". Another example might be "\t" for tab, but there may also be other invisible unicode characters.
I would like to be able to edit/save documents in MongoDB Compass that contain such characters.
The current behaviour is that these characters are completely lost when the document is in edit mode and saved (updated). Manually inserting "\n" in a text field does not insert a line break, but literally a backslash + "n".
Example document:
{
"_id": "***",
"text": "Hello,\n\nThis is my message."…1 vote
- Don't see your idea?