How to sum in a json field that contains an array of objects with Eloquent

Question

[
  {"id":4,"sum":19},
  {"id":3,"sum":9},
  {"id":6,"sum":32}, 
  {"id":2,"sum":32}
]

I'm trying this, but it finds only by 1 value, how to find by sum of "sum" values?

 $query->whereJsonContains('programs', [['sum' => intval($search)]]);

your query has a where clause, so it will find the row where it has the integer you defined, and only that value. — Emad Ha
– Emad Ha, Commented Jan 22, 2020 at 15:40

Amir Hossein Abdollahi · Accepted Answer · 2021-12-23 16:42:30Z

3

This is now supported on eloquent. This worked for me on Laravel 8 using MySQL 5.7:

Entity::sum('json_column->field')

answered Dec 23, 2021 at 16:42

1,4032 gold badges10 silver badges14 bronze badges

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

Comments

Foued MOUSSI · Accepted Answer · 2020-01-22 16:18:35Z

0

You may use

//...
->whereRaw(
'JSON_CONTAINS(programs->"$[*].sum", "' . intval($search) . '")')->get();

answered Jan 22, 2020 at 16:08

Foued MOUSSI

4,8334 gold badges21 silver badges40 bronze badges