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

Add an expression to convert an array of pairs to an object

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major - P3
    • Resolution: Done
    • None
    • 3.4.4, 3.5.5
    • Aggregation Framework
    • None
    • Fully Compatible
    • v3.4
    • Query 2017-03-27

    Description

      In many cases, it would be useful to construct an object from an array of key/value pairs. The new expression should be designed to work with the expression requested in SERVER-18794. For example, we could add an $arrayToObject expression, which could do the following:

      db.foo.drop();
      		 
      db.foo.insert({
      		 
        myArray: [ ["price", 200], ["item", "mango"] ],
      		 
        document: {x: 1, y: 2, z: 2},
      		 
        docs: [
      		 
          {email: "charlie", count: 4, blah: "foo"},
      		 
          {email: "eliot", count: 500, blah: "bar"},
      		 
        ]
      		 
      });
      		 
      db.foo.aggregate([{
      		 
          $project: {
      		 
              convertedFrom2dArray: {$arrayToObject: "$myArray"},
      		 
              noOp: {$arrayToObject: {$objectToArray: "$document"}},
      		 
                    aggregated: {$arrayToObject: {$zip: ["$docs.email", 
                                                         "$docs.count"]}}}
      		 
          }
      		 
      }]);
      		 
       
      		 
      // Output:
      		 
      {
      		 
        _id: xxx,
      		 
        convertedFrom2dArray: {"price": 200, "item": "mango"},
      		 
        noOp: {x: 1, y: 2, z: 2},
      		 
        aggregated: {charlie: 4, eliot: 500},
      		 
      }

      The expression should accept an array of pairs either represented as

      1. an array of two-element arrays (like [ ["price", 200], ["item", "mango"] ] above), or
      2. an array of two-field objects with key names k and v.

      In the latter case, the expression would permit conversion of [{k: "price", v: 200}, {k: "item", v: "mango"}] to {price: 200, item: "mango"}.

      Attachments

        Issue Links

          is depended on by

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

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

          New Feature - A new feature of the product, which has yet to be developed. SERVER-5947 Add ability to project key names as values and values as key names

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

          New Feature - A new feature of the product, which has yet to be developed. SERVER-23729 Crafting subdocuments with the aggregation framework

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

          Bug - A problem which impairs or prevents the functions of the product. DOCS-10459 The documentation for $objectToArray and $arrayToObject is missing

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

          New Feature - A new feature of the product, which has yet to be developed. DRIVERS-358 Aggregation Framework Support for 3.6

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

          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
          links to

          Web Link Pull Request

          Activity

            People

              tess.avitabile@mongodb.com Tess Avitabile (Inactive)
              charlie.swanson@mongodb.com Charlie Swanson
              Votes:
              6 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: