Skip to content

AdminKatya (Product Manager, Query, MongoDB)

My feedback

13 results found

  1. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Database » Change Streams  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminKatya (Product Manager, Query, MongoDB) commented  · 

    In MongoDB 6.0 there will be an ability to watch for views and indexes with showExpandedEvents option.
    https://jira.mongodb.org/browse/SERVER-46414
    There's nothing planned as of today regarding the users and roles.

    Could you tell a little bit more about your need for users and roles, what is the use case?

  2. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Database » Query and Aggregation Pipeline  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminKatya (Product Manager, Query, MongoDB) commented  · 

    Expressions are not allowed because bounds have to be constant for the entire densification process. Potentially support for constant expressions can be added, e.g. range: {bounds: [{$dateTrunc: { date: ISODate("2022-05-13T07:00:00.000Z"), unit: "hour", binSize: 1 }}, ISODate("2022-05-20T07:00:00.000Z")], step: 1}. But something like this still will not be supported: range: {bounds: [{$dateTrunc: { date: '$dateFieldOne', unit: "hour", binSize: 1 }}, '$dateFieldTwo')], step: 1}

    Would that work for your use case?

  3. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Database » Query and Aggregation Pipeline  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminKatya (Product Manager, Query, MongoDB) commented  · 

    Thank you for the feedback!
    While as of today $lookup still always produces an array, even if there's only one document found in the 'from' collection, starting MongoDB 5.0 you can use `localField` and `foreignField` with the `pipeline`, so $match is not necessary
    https://docs.mongodb.com/manual/reference/operator/aggregation/lookup/#correlated-subqueries-using-concise-syntax
    [
    {
    "$lookup": {
    "from": "categories",
    "localField": "category",
    "foreignField": "_id",
    "pipeline": [
    {
    "$project": {
    "_id": 0,
    "cat_name": "$category",
    "cat_description": "$description"
    }
    }
    ],
    "as": "category_details"
    }
    },
    {
    "$replaceRoot": {
    "newRoot": {
    "$mergeObjects": [
    "$$ROOT",
    {
    "$first": "$category_details"
    }
    ]
    }
    }
    },
    {
    "$project": {
    "category_details": 0
    }
    }
    ]

  4. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Database » Query and Aggregation Pipeline  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminKatya (Product Manager, Query, MongoDB) commented  · 

    How about aggregation with $merge? Would this achieve what you are looking for?
    db.tasks.aggregate([
    {$match: {
    'user.id': '1234'
    }},
    {$lookup: {
    from: 'users',
    localField: 'user.id',
    foreignField: '_id',
    as: 'user',
    pipeline: [{$set: {id: "$_id"}}, {$unset: "_id"}]
    }},
    {$set: {
    user: {$first: '$user'}
    }},
    {$merge: {
    into: 'tasks',
    on: '_id'
    }}
    ])

  5. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Database » Indexes  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminKatya (Product Manager, Query, MongoDB) commented  · 

    We recommend using Atlas Search for this https://docs.atlas.mongodb.com/atlas-search/. It supports multiple indexes.

  6. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Compass  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminKatya (Product Manager, Query, MongoDB) commented  · 

    I'm moving this request to Compass, since it seems that the request is about usability fo representation

    An error occurred while saving the comment
    AdminKatya (Product Manager, Query, MongoDB) commented  · 

    You can run explain() for your aggregation to see number of documents and execution time
    db.collection.explain('executionStats').aggregate([...])

    https://docs.mongodb.com/manual/reference/explain-results/

  7. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    started  ·  1 comment  ·  Database » Change Streams  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminKatya (Product Manager, Query, MongoDB) commented  · 

    This project is planned for implementation, stay tuned for the upcoming releases.

  8. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  1 comment  ·  Database  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminKatya (Product Manager, Query, MongoDB) commented  · 

    This feature is on the roadmap, however, the target release is not known yet.

  9. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Database  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminKatya (Product Manager, Query, MongoDB) commented  · 

    Could you expand on this a little, why would this be preferred over adding a filter on unique field, e.g.
    db.test.find({"creationDate" : {$gte:ISODate('2021-08-27T07:25:00Z')}, "_id" : {$gte: lastSeenId}).sort({"creationDate":1, _id: 1}).limit(20)

  10. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Database  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminKatya (Product Manager, Query, MongoDB) commented  · 

    (moved this request to the Database section)

    You are correct, this would not work, `from` and `as` only accept static strings. There are no short-term plans to support this feature, it would require a revamp of the security model and query optimization.

    A similar request is also tracked here https://jira.mongodb.org/browse/SERVER-22497

  11. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Database  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminKatya (Product Manager, Query, MongoDB) commented  · 

    Hello, Arthur, could you provide more details, and describe the use case.

  12. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Database  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminKatya (Product Manager, Query, MongoDB) commented  · 

    Hi Ali, in MongoDB 4.4 you can run JavaScript function inside the aggregation stage, so you can avoid the network roundtrip for each document. For example:

    {$set: {
    user: {
    $function: {
    arguments: ["$user"],
    body: function(user) {
    return JSON.parse(user);
    },
    language: 'js'
    }
    }
    }}

    Also, there are $replaceOne and $replaceAll operators for strings, and $merge can now output to the same collection.

    Release Notes: https://docs.mongodb.com/manual/release-notes/4.4/index.html#aggregation

  13. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Database  ·  Flag idea as inappropriate…  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminKatya (Product Manager, Query, MongoDB) commented  · 

    Hi Julien, what kind of geometries do you store? 2d index only supports storing data as points.

Feedback and Knowledge Base