36 results found

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

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

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

   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. 按照当前的查询语句及索引生成查询优化建议
   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. 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

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

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

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

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

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

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

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

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

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

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

16. 点击按钮没反应

    点击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