41 results found

1. Is it possible to let the user choose when editing an aggregation whether they want it to be displayed directly at the bottom or disabled?

   Is it possible to let the user choose when editing an aggregation whether they want it to be displayed directly at the bottom or disabled?

   Because currently, when you open an aggregation, it automatically scrolls to the bottom, and/or if you need to search for or modify a Stage that is in the middle or at the beginning, you still have to scroll up and search for it.

   If possible, give the user the option to configure this themselves: automatic scrolling to the bottom or manual scrolling.

   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  ·  Aggregation pipeline builder  ·  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

   Submit Rating

2. aggregation pipeline save setting for limit

   For aggregation pipeline settings, the ability to save and persist the chosen "Limit" setting that "Limits input documents before $group, $bucket, and $bucketAuto stages". This setting could be saved for a particular collection, or as a default setting (similar to the "General" Compass setting that can persist for "Upper Limit for maxTimeMS".

   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  ·  Aggregation pipeline builder  ·  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

   Submit Rating

3. Be able to use natural language to update / add to an existing aggregation pipeline (currently only able to create new ones)
   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  ·  Aggregation pipeline builder  ·  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

   Submit Rating

4. Improving user experience of Aggregation pipeline builder

   Today, when I describe extensive aggregations, I need to use the "</> TEXT" method in the interface because it is the only way I have to comment on what each step does and to efficiently locate myself in each step. In such a way that these comments would be visually displayed before each stage in the "{} STAGES" option of the "Aggregations" tab.

   It would be great if it were possible to not only comment on the steps but perhaps group them (only visually). One of the things that can be done is to use "// #regions" as it happens in vscode to group

   Today, when I describe extensive aggregations, I need to use the "</> TEXT" method in the interface because it is the only way I have to comment on what each step does and to efficiently locate myself in each step. In such a way that these comments would be visually displayed before each stage in the "{} STAGES" option of the "Aggregations" tab.

   It would be great if it were possible to not only comment on the steps but perhaps group them (only visually). One of the things that can be done is to use "// #regions" as it happens… 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  ·  Aggregation pipeline builder  ·  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

   Submit Rating

5. Add unwind as part of the Lookup it self

   it's cumbersome to lookup for one document in a other collection just to write unwind after it.

   it will be handy if a boolean field will return an array or object.

   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  ·  Aggregation pipeline builder  ·  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

   Submit Rating

6. Smart Index Optimization for Aggregation Queries in Compass

   When building aggregation pipelines in Compass, sometimes queries can slow down if they’re missing the right indexes or opt out.

   1. Creating Temporary Indexes Automatically: If the aggregation query doesn’t have an optimal index, Compass will automatically build a temporary one just for that specific operation.
   2. Suggesting Permanent Indexes: After running the aggregation with the temporary index, Compass will notify you and suggest saving the index permanently if it’s likely to be useful for future queries. Maybe even showing time saved with the index or without.
   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  ·  Aggregation pipeline builder  ·  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

   Submit Rating

7. Export or save in the acount the saved aggregations.

   Just a simple way to save the aggregations.

   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  ·  Aggregation pipeline builder  ·  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

   Submit Rating

8. Aggregation Pipeline builder, allow hints

   Allow setting hint to enable index debugging and optimizations

   6 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

   3 comments  ·  Aggregation pipeline builder  ·  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

   Submit Rating

9. Enable us to see values of expressions in aggregation pipelines

   I've got a pipeline that often does a lot of collecting and combining values. What I get out of it is wrong but I have no way of knowing which part is broken since I can't see the values its collecting and the results of its maths until the final outcome.

   Could you add some sort of value reading to the aggregation pipeline builder?

   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  ·  Aggregation pipeline builder  ·  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

   Submit Rating

10. Remember "Expand all fields" output option between pages

    When viewing documents returned by the aggregation pipeline, selecting the Output option of "Expand all fields" works for the page you are currently viewing, but changing pages means you need to click "Expand all fields" again for each page.

    It would be good if Compass remembered that "Expand all fields" was active, and kept this on for all pages in the results.

    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  ·  Aggregation pipeline builder  ·  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

    Submit Rating

11. Aggregation pipelines history for recently used aggregations.

    Aggregation pipelines that have been used recently should also be saved similar to how search queries are stored.

    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

    1 comment  ·  Aggregation pipeline builder  ·  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

    Submit Rating

12. CRUD in recursion

    i have to do some operations like delete in recursion. Any operations also may be required in recursion.

    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  ·  Aggregation pipeline builder  ·  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

    Submit Rating

13. A bug in aggregation's Wizard $lookup : It is not showing the accurate values for local & foreign fields.

    A bug in aggregation's Wizard $lookup as it is not showing the accurate values for local & foreign fields. See the attached image

    db.orders.insertMany([
    { "id" : 1, "item" : "almonds", "price" : 12, "quantity" : 2 },
    { "id" : 2, "item" : "pecans", "price" : 20, "quantity" : 1 },
    { "_id" : 3 }
    ])

    db.inventory.insertMany([
    { "id" : 1, "sku" : "almonds", "description": "product 1", "instock" : 120 },
    { "id" : 2, "sku" : "bread", "description": "product 2", "instock" : 80 },
    { "id" : 3, "sku" : "cashews", "description": "product 3", "instock" : 60 },
    { "id" : 4, "sku" : "pecans", "description": "product 4", "instock" : 70 },
    { "id" : 5, "sku": null, "description": "Incomplete" },
    { "id" : 6 }
    ])

    db.orders.aggregate([
    {
    $lookup:
    {
    from: "inventory",
    localField: "item",
    foreignField: "sku",
    as: "inventory_docs"
    }
    }
    ])

    A bug in aggregation's Wizard $lookup as it is not showing the accurate values for local & foreign fields. See the attached image

    db.orders.insertMany([
    { "id" : 1, "item" : "almonds", "price" : 12, "quantity" : 2 },
    { "id" : 2, "item" : "pecans", "price" : 20, "quantity" : 1 },
    { "_id" : 3 }
    ])

    db.inventory.insertMany([
    { "id" : 1, "sku" : "almonds", "description": "product 1", "instock" : 120 },
    { "id" : 2, "sku" : "bread", "description": "product 2", "instock" : 80 },
    { "id" : 3, "sku" : "cashews", "description":… 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  ·  Aggregation pipeline builder  ·  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

    Submit Rating

14. Autogenerated random values in numbers based on 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 do we have to go with Python for this why don't we do it in MongoDB?

    can you suggest to me if I am wrong

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

    6 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

    2 comments  ·  Aggregation pipeline builder  ·  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

    Submit Rating

15. Add Ai to stage wizard

    currently stage wizard has built in suggestions, maybe if it becomes integrated with AI would become much more amazing

    3 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  ·  Aggregation pipeline builder  ·  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

    Submit Rating

16. Changestream support!

    On each collection, right next to the aggregation tab (or inside aggregation tab), just add a tab for changestream! And similar to the aggregation tab, where u can see all the previews for each aggregation step, users should be able to do same based on the oplogs.

    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  ·  Aggregation pipeline builder  ·  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

    Submit Rating

17. Aggregation editor improvements

    settings for the following:
    - Turn off auto-pairs (some people really are not used to typing with it)
    - Vim keybinds (somewhat joking, but also not)
    - View full documentation within Compass.
    - Currently it seems the website manual is the only place to view documentation, being able to see it within Compass would be helpful
    - Quick reference for operators / expressions
    - Font settings (increase, boldness, change font).

    Really just turning off auto-closing brackets would be great.

    4 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

    2 comments  ·  Aggregation pipeline builder  ·  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

    Submit Rating

18. Array Function

    Just like Javascript array functions such as filter, map having some option in drag and drop wizard with match and project stage will be more useful.

    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  ·  Aggregation pipeline builder  ·  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

    Submit Rating

19. I would like to be able to export an aggregation pipeline to Kotlin
    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  ·  Aggregation pipeline builder  ·  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

    Submit Rating

20. Add the possibility to export a pipeline to java using Spring Data MongoDB

    Spring Data for mongoDB support aggregation for use with their MongoTemplate, and it is less verbose and more readable than an aggregation to use with MongoClient.

    It would be nice to be able to export a pipeline to Java language for this framework. Maybe an additional check box on the export popup.

    Also, if checked, maybe replace the "Include Driver Syntax" checkbox by a "Include Spring Template syntax"

    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  ·  Aggregation pipeline builder  ·  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

    Submit Rating