Compass
36 results found
-
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 -
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 -
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 -
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 -
Global search query filter
Use case: When we work on Mutli tenant-based system, we have Account Id is common in all collections. When we search multiple collections needs to add filter accounted in every search.
Feature: If we have global filter, we can add common filters and easily search in every collections.1 vote -
Filtering option for Nested objects
actually, as per now it's difficult to handle {column. Fieldname: value}, by using like {column _fieldname: value} it's better to handle in c# with the help of LINQ.
1 vote -
Show created timestamp for ObjectId fields
It would be really useful to see the timestamp from ObjectId fields while hovering over the ObjectId values in query results. Well designed documents have a field for the creation time, but not all documents have it and then need to go into hoops to take the ObjectId and call the getTimestamp() function for it to see when the document was created.
The ObjectId also contains machine identifier, process id and a counter. They're not that interesting, but could be shown as well.
1 vote -
1 vote
-
Evalute numbers as 64bit instead of 53bit of JavaScript
Compass seems to evalute everything with JS, so if you enter {um:-2583493467308876869} it will treat the number as -2583493467308877000 and of course won't find what I'm looking for.
So the fix is to use {um:NumberLong('-2583493467308876869')}, which is a bit painful to type, and even if I do that, the Query History still saves {um: -2583493467308877000}, so basically it's broken ...
1 vote -
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 -
Remove the Insight badge blocking the view to my query
There is a insight badge that does not merit that location(see attachment), and stands on the way to modify the queries.
1 vote -
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 -
Change collection on a saved query
In the My Queries section it would be nice to be able to select which collection you want to be able to run the query against or to be able to copy the query to another collection.
At the moment each query is 'locked' to the collection it was oringally created for.
This means if i want to run the same query against another collection i have to open it and copy the text from the aggregation pipeline from the query then open the collection i want to run it on and copy the text into the aggregation pipline.
1 vote -
RANDOM VALUES USING THE OBJECTID
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 -
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 -
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 -
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
- Don't see your idea?