Compass
36 results found
-
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.
37 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.
32 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')}
14 votes -
Date Tags for Easier Querying of Date Fields
I propose adding a feature called "Date Tags" to MongoDB Compass, which would allow users to query date fields more easily. Date Tags would serve as shorthand for commonly used date queries, enhancing user efficiency and readability.
Example Use-Case:
Consider the task of finding all documents where the createdAt field was set to "yesterday". Normally, the query would look something like:{ "createdAt": { "$gte": ISODate("2023-10-17T00:00:00"), "$lt": ISODate("2023-10-18T00:00:00") } }With Date Tags, this could be simplified to:
{ "createdAt": #yesterday }Proposed Date Tags:
#today
#yesterday
#lastNDays
#lastNHours
#lastNMinutes
#othersEach tag would automatically be translated to the corresponding…
10 votes -
Support Legacy CSUUID in filters and in view instead of BinData type 3
support CSUUID like robo 3t does that, because its very hard to see the real string with this BinData type 3
i have a script that convert bin data to CSUUID and CSUUID to bin data in js if you can include that in compass code it will help a lot of users that used robo 3t instead of compass only because of this uid
this is the script
https://github.com/barnuri/mongo-uuid-helper/blob/master/uuidHelpers.js10 votes -
9 votes
-
I would like to paste a Mongo ObjectId and it automatically query on it
I would like to paste a Mongo ObjectId and it automatically query on it.
Right now when I go to type something into the query filter field it'll automatically add {}
A great next step is if I [ctrl} + [v] paste in a MongoDB ID, then it automatically turns it into an _id query.Step 1: Copy "64f046fb304cee6fa007d935"
Step 2: Paste int othe filter (Query) field
Step 2b: MongoDB compass converts my text into the query{_id: ObjectId('64f046fb304cee6fa007d935')}
Step 3: Click [Find] (or maybe it can even automatically do that?Currently I have to type"
_id: ObjectId('<now paste in…5 votes -
Make the filter editor expandable to multiple lines
Problem: The filter edit is a 1 line text box. It is no good for creating and editing queries with multiple terms... you can only see a small part of the query
Solution: make the filter edit expandable, so you can see 1 line or many lines.
4 votes -
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 -
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 -
Support for distinct
Add support distinct queries in Compass.
https://docs.mongodb.com/manual/reference/method/db.collection.distinct/4 votes -
Sync queries across multiple computers or installations of Compass
I work on multiple computers and I find my self missing queries that I have already created on other computers. It would be nice to have queries that are linked to a collection to be synced when using Compass on other computers. Maybe something like Github can be used as the central storage for the queries or allow users to selected popular storage options if Compass can't provide the storage natively.
3 votes -
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 -
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 -
add refresh button in the collection tab
when you click on a collection it open a tab right ? what if you want to refresh it
let's say you are in development stage and you want to see what's being stored and all
my idea is to add hot key like CTRL R or a refresh button it will be very usefull2 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 -
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 -
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 -
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 -
Please make a feature to set specific sorting query as a default .
I always put ' {createdAt: -1} to sort the data in a descending order. Could you make a feature that can set some default custom query setting ??
1 vote
- Don't see your idea?