aggregation framework should have a $find expression

XMLWordPrintableJSON

    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Aggregation framework has a filter, which filters an array (and returns an array).

      I wish there was an equivalent to do a javascript Array.find(), where the filter would return the first match inside of the array

      db.test.insert({people: [{name: 'bob', value: 1}, {name: 'fred', value: 2}]});

db.test.aggregate([{$addFields: {
  person: {
    $find: {
      input: '$people',
      cond: {$eq: ['$$this.name', 'fred']}
    }
  },
  people: '$$REMOVE'
}}]);

##returns
{person: {name: 'fred', value: 2}}

       

            Assignee:
            [DO NOT USE] Backlog - Query Optimization
            Reporter:
            Ben Rotz
            Votes:
            2 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: