aggregate mongodb search in array

Question

my documents in mongodb collection :

{ 
  'id' : 'ID1',
  'status' : 'ST1',
  'logs' : [
    {
      'id' : 'ID2',
      'status_old' : 'ST2',
      'status_new' : 'ST3',
    },
    {
      'id' : 'ID3',
      'status_old' : 'ST3',
      'status_new' : 'ST4',
    }
  ]
},
{ 
  'id' : 'ID4',
  'status' : 'ST4',
  'logs' : [
    {
      'id' : 'ID5',
      'status_old' : 'ST2',
      'status_new' : 'ST3',
    }
  ]
}

I want to pass the documents through the following two filters

filter1 : 
where
   ( status    = 'ST1'  OR
    status_old = 'ST1'  OR
    status_new = 'ST1'  )

Then the answer obtained should be placed in the following filter (condition):

filter2 : 
where
   ( status    = 'ST2'  OR
    status_old = 'ST2'  OR
    status_new = 'ST2'  )

The answer is stated with two conditions and according to the documents provided above, the following is the case:

{ 
  'id' : 'ID1',
  'status' : 'ST1',
  'logs' : [
    {
      'id' : 'ID2',
      'status_old' : 'ST2',
      'status_new' : 'ST3',
    },
    {
      'id' : 'ID3',
      'status_old' : 'ST3',
      'status_new' : 'ST4',
    }
  ]
},

logs is an array right? So would the filters match any item in the array ? — Dharmaraj
– Dharmaraj, Commented Feb 26, 2022 at 15:51

cmgchess · Accepted Answer · 2022-02-26 17:01:54Z

1

since you are not filtering out any elements from the logs array this looks like an aggregation with 2 $match stages with $or in it

db.collection.aggregate([
  {
    $match: {
      $or: [
        {
          "status": "ST1"
        },
        {
          "logs.status_old": "ST1"
        },
        {
          "logs.status_new": "ST1"
        }
      ]
    }
  },
  {
    $match: {
      $or: [
        {
          "status": "ST2"
        },
        {
          "logs.status_old": "ST2"
        },
        {
          "logs.status_new": "ST2"
        }
      ]
    }
  }
])

demo

answered Feb 26, 2022 at 17:01

cmgchess

10.3k42 gold badges55 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Hossein Over a year ago

We also have other filters so that it is not crowded and complicated, it is not mentioned in the question, does this method work properly with other filters?

cmgchess Over a year ago

can you do some checks with some sample data in mongoplayground.net/p/VYpzgAUl6qa

Collectives™ on Stack Overflow

aggregate mongodb search in array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related