Using where in jenssegers/laravel-mongodb

user_4111599 0
Viewed 1150

I am using jenssegers/laravel-mongodb in laravel :

The structure of my data in the mongodb is as follows. Suppose there are 100 rows like this

click show image

I need a query to show me all the data whose finance.selling_type status is 1

My attempt to write code

finances::where('finance.selling_types.$$status', 1)->get();

or

finances::where('finance.selling_types.*.status', 1)->get();
laravel mongodb where-clause
2 Answers

Use an aggregation pipeline.

Convert the objects embedded in selling_types to an array

 $convertSellingTypesToArray = [
    '$project' => [
      'finance.selling_types' => [
        '$objectToArray' => '$finance.selling_types'
      ]
    ]
  ];

Then unwind the array to individual documents

$sellingTypesAsDocuments =   [
    '$unwind' => '$finance.selling_types'
];

Filter where status is 1.

$selectOnlyActiveStatus = [
    '$match' => [
      'finance.selling_types.v.status' => [
        '$eq' => 1
      ]
    ]
  ];

Convert selling_types back as an object.

$convertSellingTypesToObject = [
    '$project' => [
      'finance.selling_types' => [
        '$arrayToObject' => [
          [
            '$finance.selling_types'
          ],
        ]
      ]
    ]
  ];

finances::raw()->aggregate([
  $convertSellingTypesToArray,
  $sellingTypesAsDocuments,
  $selectOnlyActiveStatus,
  $convertSellingTypesToObject,
])

Note that you'll need to support pagination on the query

user_51898110

thanks to Oluwafemi Sule, I found the solution :

\DB::connection('mongodb')
            ->collection('finances')
            ->raw(function($collection) {
                return $collection->aggregate(
                    [
                        [
                            '$project' => [
                                'finance'=> [
                                    'selling_types'=> [
                                        '$objectToArray'=>  '$finance.selling_types'
                                    ]
                                ],
                              
                            ]
                        ],
                        [
                            '$unwind' => '$finance.selling_types'
                        ],
                        [
                            '$match'=> [
                                '$and' => [
                                    [
                                        'finance.selling_types.v.status' => [
                                            '$eq' => 1
                                        ],
                                    ],
                                ]
                            ]
                        ],

                    ]
                );
            });
user_41115990
Related