How to find record matching the nested key laravel mongodb jenssegers

Question

I am using jenssegers mongodb package in laravel for querying mongodb. How to retrieve the records matching only the games as cricket in the below json document.

      {
       "_id": ObjectId("53402597d852426020000002"),
       "contact": "987654321",
       "dob": "01-01-1991",
       "gender": "M",
       "name": "Tom Benzamin",
       "user_name": “tombenzamin”,   
       “Personal_info”:[
            hobbies:{
                "games": "cricket",
                "favfilms": "lotr",
                "favfood": "burger"
            }
]
       }

    }

Could you share your relationship configuration (model class)? — krisanalfa, Oct 27 '17 at 08:56

score 2 · Answer 1 · answered Oct 27 '17 at 09:07

2

$crickets = DB::collection('games')->where('Personal_info.hobbies.games', 'cricket')->get();

something like this should work

answered Oct 27 '17 at 09:07

ariawan

198
1
8

if Personal_info info is an array like this Personal_info[] then how can i access the inner level key – oldrock Oct 27 '17 at 09:38
...->where('Personal_info["hobbies"].games', 'cricket')->get(); – ariawan Oct 27 '17 at 09:59
Hey, the answer which is given by @Alfa was working. Thanks so much for your help. – oldrock Nov 06 '17 at 06:57

krisanalfa · Accepted Answer · 2017-10-27T11:37:26.233

2

You can use whereRaw method combined with elemMatch:

DB::collection('users')->where(
    'Personal_info.hobbies',
    'elemMatch',
    [ 'games' => 'cricket' ]
)->get()

edited Oct 27 '17 at 11:37

answered Oct 27 '17 at 09:09

krisanalfa

6,268
2
29
38

Suppose if Personal_info has array of json. edited the question – oldrock Oct 27 '17 at 09:18
@oldrock I've updated the answer, please kindly check – krisanalfa Oct 27 '17 at 11:37

How to find record matching the nested key laravel mongodb jenssegers

2 Answers2