How to write the following mongo lookup query in Yii2

Question

I am using this mongo extension in Yii2.

I have 2 collections named ServiceProvider and Parents. In ServiceProvider there is subdocument (PostCommentIDs) containing IDs of parents.

Another collection Parents contains all parent information.

I wanted to join the 2 collection. I have achieved it through the following mongo query.

But using the above extension how do I write this query in Yii2.

db.ServiceProvider.aggregate([
   {
      $unwind: "$PostCommentIDs"
   },
   {
      $lookup:
         {
            from: "Parents",
            localField: "PostCommentIDs",
            foreignField: "ID",
            as: "ParentDetails"
        }
   },
   {
      $match: { "ParentDetails": { $ne: [] } }
   }
])

Please help. Thanks!

Chinmay Waghmare · Accepted Answer · 2019-12-10 06:36:47Z

3

Found the solution. It may help someone.

$collection = Yii::$app->mongodb->getCollection('ServiceProvider');
$result = $collection->aggregate([
            ['$unwind' => '$PostCommentUserIDs'],
            [ 
                '$lookup' => 
                    [
                        'from' => 'Parents',
                        'localField' => 'PostCommentUserIDs',
                        'foreignField' => 'ID',
                        'as' => 'ParentDetails'
                    ] 
            ],
            [
                '$match' => [
                    'ParentDetails' => [ '$ne' => []  ]
                ]
            ]
]);

edited Dec 10, 2019 at 6:36

answered Apr 30, 2016 at 6:34

Chinmay Waghmare

5,4563 gold badges47 silver badges72 bronze badges

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

1 Comment

innovative kundan Over a year ago

I am getting 'pipeline' option must be specified as an array error

Shubham · Accepted Answer · 2019-12-10 05:41:01Z

1

Use this way in current explanation: Pipeline must be in an array always

$collection = Yii::$app->mongodb->getCollection('ServiceProvider');
$result = $collection->aggregate([
        ['$unwind' => '$PostCommentUserIDs'],
        [ 
            '$lookup' => 
                [
                    'from' => 'Parents',
                    'localField' => 'PostCommentUserIDs',
                    'foreignField' => 'ID',
                    'as' => 'ParentDetails'
                ] 
        ],
        [
            '$match' => [
                'ParentDetails' => [ '$ne' => []  ]
            ]
        ]
      ]);

answered Dec 10, 2019 at 5:41

Shubham

374 bronze badges

Collectives™ on Stack Overflow

How to write the following mongo lookup query in Yii2

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related