How can I use JSON Where Clauses on laravel mongodb? (Laravel 5.3)

Question

My data on mongodb compass is like this :

I try to implement json where clauses like this :

Message::where('information->seller_id', 1)
       ->get();

The results are not showing. Whereas the data exist

This query seems still wrong

But, I don't find it

How can I solve this problem?

I think column data type should be json. In your case information column should be data type of json. — Vikash
– Vikash, Commented Mar 15, 2017 at 9:33

Hollings · Accepted Answer · 2017-03-24 12:58:38Z

1

To select data from inside JSON, use a . instead of ->

Message::where('information.seller_id', 1)
       ->get();

Also, your data is currently a string, and you need it to be JSON. Just remove the quotes around it:

information : {"store_id":6,"some_other_data":"123", "seller_id":1}

answered Mar 24, 2017 at 12:58

Hollings

5325 silver badges14 bronze badges

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

1 Comment

That is worked for laravel (5.8.36) mongodb (4.0.14)