How can i filter nested object in array using Laravel 5.5

Question

This is json object from database

{
  "id": 1,
  "price_role": [
     {"id": 1, price:20, role:"HQ"},
     {"id": 2, price:10, role:"AG"}
   ]
}

My question is how to filter a specific price_role by a given role and convert it to an object instead of returning list?

Try using this way but it is not worked :

$role = "HQ"; 
$query = Product::with('price_role',  function ($q) use ($role) {
      $q->where('role', '=', $role);
  })
  ->where('user_id', '=', $user->id)->get();

Expected output if $role = "HQ" :

 {
  "id": 1,
  "price_role": {"id": 1, price:20, role:"HQ"},
 }

FYI: I'm using Laravel 5.5

your json object have you received it from database, please? — Thamer
– Thamer, Commented Feb 9, 2019 at 0:25
Possible duplicate of Laravel Nested Eager Loading how to use eloquent where condition from inside with nested — Will B.
– Will B., Commented Feb 9, 2019 at 0:29

MONSTEEEER · Accepted Answer · 2019-02-09 01:24:04Z

2

$role = "HQ"; 
$query = Product::with(['price_role' => function ($q) use ($role) {
     $q->where('role', '=', $role);
}])
->where('user_id', '=', $user->id)->get();

Can you try this?

answered Feb 9, 2019 at 1:24

MONSTEEEER

5707 silver badges23 bronze badges

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

2 Comments

MONSTEEEER Over a year ago

You also forgot the square brackets. []

MONSTEEEER Over a year ago

Nice, Keep coding mate.

CodeBoyCode · Accepted Answer · 2019-02-09 00:50:09Z

0

you have forgotten to get all of the results with the get() method.

your request should be like this :

$query = Product::with('price_role',  function ($q) use ($role) {
    $q->where('role', '=', $role);
 })->where('user_id', '=', $user->id)->get();

edited Feb 9, 2019 at 0:50

CodeBoyCode

2,27715 silver badges29 bronze badges

answered Feb 9, 2019 at 0:28

Thamer

1,9442 gold badges13 silver badges21 bronze badges

2 Comments

digit Over a year ago

It is still not working. I forgot to put get() in my question before.

Thamer Over a year ago

can you update your question and put how your return the result of your query to view blade, please

Collectives™ on Stack Overflow

How can i filter nested object in array using Laravel 5.5

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related