38 results found

1. 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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Queries  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. 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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Queries  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. Disable the cache feature from Compass

   Every time I click some on some collection, I don't receive the actual data from the database but the cached data. In my opinion, that should not be like that, because that makes me clicking constantly on the refresh button.

   If I click a collection then I want the latest and updated data from the database.

   One example:
   - I open the Compass GUI tool and I click on some collection to see its data.
   - I switch to the application that is doing things and executing actions in the database using their own link.
   - I switch to Compass, then click some collection because I know the data was modified/inserted and I don't see the changes. I must to click on the refresh button to receive the latest data from the database.

   Thank you for these great tools.

   Every time I click some on some collection, I don't receive the actual data from the database but the cached data. In my opinion, that should not be like that, because that makes me clicking constantly on the refresh button.

   If I click a collection then I want the latest and updated data from the database.

   One example:
   - I open the Compass GUI tool and I click on some collection to see its data.
   - I switch to the application that is doing things and executing actions in the database using their own link.
   - I switch to Compass,… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Queries  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. Optional ID search fallback for ObjectID

   If I search { _id: 'd7hw803h2ihdf3h97298dh3' } and the query returns nothing, I should have the option to re-query but with this instead: { _id: ObjectId('d7hw803h2ihdf3h97298dh3') } and there should be a toggle switch to automatically do this re-querying when there's an empty result.

   There's no reason not to have this, it's very easy to implement, and it would be some nice quality of life.

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Queries  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. 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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Queries  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. 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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Queries  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

7. 按照当前的查询语句及索引生成查询优化建议
   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Queries  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. 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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Queries  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. 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

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Queries  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. 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

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Queries  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. 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 from the objectId.

    can we do anything that generation in the objectId based on the numbers or can we have anything like alphabetic have separate numbers like using the let variable like what we did for getting the months and days.

    if you do any one of them we can do auto-generation which is unique in numbers for every document either changing in the generation in objectId or adding the alphabetic to numbers like months and days

    I am sending the query that I have used in my organization for testing purposes but the result is unexpected so can you guide me on the correct to do it or any changes can you do in the upcoming release it can be appreciated. this is the basic suggestion from my side.I am thinking why don't we do it in the MongoDB other than going to python for random values.

    mongodb: For random numbers to generate based on the _id:

    If you insert the sample of 1k documents and test this query you will duplicates in the numbers and the count will also decrease.

    1st Method: [
    {
    $addFields: {
    numbers: {
    $regexFindAll: {
    input: {
    $toString: "$id",
    },
    regex: "[0-9]+",
    },
    },
    alpha: {
    $regexFindAll: {
    input: {
    $toString: "$id",
    },
    regex: "[a-z]+",
    },
    },
    },
    },
    {
    $project: {
    numbers: {
    $reduce: {
    input: "$numbers.match",
    initialValue: "",
    in: {
    $concat: ["$$value", "$$this"],
    },
    },
    },
    },
    },
    {
    $group: {
    _id: "$numbers",
    },
    },
    {
    $count: "string",
    },
    ]

    2nd Method:

    {
    $let: {
    vars: {
    monthsInString: [
    "",
    "JAN",
    "FEB",
    "MAR",
    "APR",
    "MAY",
    "JUN",
    "JUL",
    "SEP",
    "OCT",
    "NOV",
    "DEC",
    ],
    },
    in: {
    $arrayElemAt: [
    "$$monthsInString",
    {
    $toInt: {
    $dateToString: {
    format: "%m",
    date: "$dtCollected",
    },
    },
    },
    ],
    },
    },
    },

    Like this can you do for alphabetics so that we can convert the alphabetic to numbers then we can have random values which are unique in numbers .

    Can you please check and let me know if any changes I have done wrong from my side or any other way to generate the random values in numbers in the project stage.

    Why don't we do in mongodb instead of going to python for some random number which have unique values.

    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… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Queries  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

12. 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 from the objectId.

    can we do anything that generation in the objectId based on the numbers or can we have anything like alphabetic have separate numbers like using the let variable like what we did for getting the months and days.

    if you do any one of them we can do auto-generation which is unique in numbers for every document either changing in the generation in objectId or adding the alphabetic to numbers like months and days

    I am sending the query that I have used in my organization for testing purposes but the result is unexpected so can you guide me on the correct to do it or any changes can you do in the upcoming release it can be appreciated. this is the basic suggestion from my side.I am thinking why don't we do it in the MongoDB other than going to python for random values.

    mongodb: For random numbers to generate based on the _id:

    If you insert the sample of 1k documents and test this query you will duplicates in the numbers and the count will also decrease.

    1st Method: [
    {
    $addFields: {
    numbers: {
    $regexFindAll: {
    input: {
    $toString: "$id",
    },
    regex: "[0-9]+",
    },
    },
    alpha: {
    $regexFindAll: {
    input: {
    $toString: "$id",
    },
    regex: "[a-z]+",
    },
    },
    },
    },
    {
    $project: {
    numbers: {
    $reduce: {
    input: "$numbers.match",
    initialValue: "",
    in: {
    $concat: ["$$value", "$$this"],
    },
    },
    },
    },
    },
    {
    $group: {
    _id: "$numbers",
    },
    },
    {
    $count: "string",
    },
    ]

    2nd Method:

    {
    $let: {
    vars: {
    monthsInString: [
    "",
    "JAN",
    "FEB",
    "MAR",
    "APR",
    "MAY",
    "JUN",
    "JUL",
    "SEP",
    "OCT",
    "NOV",
    "DEC",
    ],
    },
    in: {
    $arrayElemAt: [
    "$$monthsInString",
    {
    $toInt: {
    $dateToString: {
    format: "%m",
    date: "$dtCollected",
    },
    },
    },
    ],
    },
    },
    },

    Like this can you do for alphabetics so that we can convert the alphabetic to numbers then we can have random values which are unique in numbers .

    Can you please check and let me know if any changes I have done wrong from my side or any other way to generate the random values in numbers in the project stage.

    Why don't we do in mongodb rather than python.

    can you please add this secenrio

    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… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Queries  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

13. 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

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Queries  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

14. 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 $in
    

    One should NOT have to change the query from what a client program naturally uses (the dollar signs) to

    { "_id" : { "$in": [ BinData(3, "6Uk1UVZWl+krPObxzA3wtg=="), BinData(3, "60Xp1sJ9nMiT6cPy3GA1ig==") ] } }
    

    I suspect that this change would be to augment the underlying query language, but, the exact implementation to having a tool which can tell me whether the exact query Java is using will be using the index is something which would be up to Mongo Corporation debate.

    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 $in
    

    One should NOT have… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Queries  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. 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 }.

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Queries  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. 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

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Queries  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

17. 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."
    }

    If I edit this document, e.g. changing the "." at the end of the text to a "!" it would be saved as "Hello,This is my message!"

    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."… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Queries  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

18. 点击按钮没反应

    点击Export To Language 白屏，无反应，系统信息：macos 10.14.6 (18G2022)

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Queries  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close