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

aggregation: need an array indexing operator

          Details

          • Type: New Feature
          • Status: Closed
          • Priority: Major - P3
          • Resolution: Fixed
          • Affects Version/s: None
          • Fix Version/s: 3.1.5
          • Component/s: Aggregation Framework
          • Labels:
            None
          • Backwards Compatibility:
            Minor Change
          • Sprint:
            Quint Iteration 4, Quint Iteration 5

            Description

            At present, there's no way to extract a specific element from an array-valued field. An operator should be added that could be used in a projection, e.g.:

            db.runCommand({aggregate:"c", pipeline:[
            { $project : {
            foo :

            { $at:["$arrayField", 5] }

            }}
            ]});

            The effect of this would be put add the computed field (virtual field) foo to the projection, and give it the value of arrayField[5].

              Attachments

                Issue Links

                is depended on by

                New Feature - A new feature of the product, which has yet to be developed. JAVA-2001 Projection builder support for array indexing operator

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

                Bug - A problem which impairs or prevents the functions of the product. SERVER-6075 Accessing array elements by position fails in $project

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

                Bug - A problem which impairs or prevents the functions of the product. SERVER-16462 Can't access specific array elements in $group

                • 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-6074 Allow $slice operator in $project

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

                Task - A task that needs to be done. DRIVERS-234 Aggregation Builder Support for 3.2

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

                Bug - A problem which impairs or prevents the functions of the product. SERVER-5299 array element selection syntax returns wrong result

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

                New Feature - A new feature of the product, which has yet to be developed. CSHARP-1400 Support the new array indexing operator

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

                  Activity

                    People

                    • Votes:
                      75 Vote for this issue
                      Watchers:
                      48 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: