Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-5947

Add ability to project key names as values and values as key names

    XMLWordPrintableJSON

Details

    • Query

    Description

      Aggregation framework could be a powerful way to transform one shape of document schema into another if values could be turned into keys and vice versa.

      Example schema:

      { userId: "xxx", attributeName: "yyy", attributeValue: "zzz"}

      could be projected into

      { userId: "xxx", "yyy": "zzz"}

      for a subset of attribute names where now we can do simple $match for our criteria.

      Conversely, ability to turn keys into values would allow aggregation based on existence of certain keys.
      It would also allow aggregating by key rather than by value.

      Attachments

        Issue Links

          duplicates

          New Feature - A new feature of the product, which has yet to be developed. SERVER-18794 Add an aggregation expression to convert an object to an array of key, value pairs

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-23310 Add an expression to convert an array of pairs to an object

          • Major - P3 - Major loss of function.
          • Closed
          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. SERVER-6429 $unwind keys in a document or subdocument and group by them without knowing all the field names beforehand.

          • Major - P3 - Major loss of function.
          • Closed
          is related to

          New Feature - A new feature of the product, which has yet to be developed. SERVER-11392 $unwind on subdocuments

          • Major - P3 - Major loss of function.
          • Closed
          related to

          New Feature - A new feature of the product, which has yet to be developed. SERVER-8582 Extend document expression language in aggregation to support advanced document filtering.

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-13928 Iteration over Map support

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              backlog-server-query Backlog - Query Team (Inactive)
              asya.kamsky@mongodb.com Asya Kamsky
              Votes:
              28 Vote for this issue
              Watchers:
              31 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: