Laravel get single item from Array in Query with relation ship

Question

in my one of models such as posts i have a column array as featured_image and when i get result query from this model that return all of this array items, for example:

"featured_image": {
    "images": {
        "original": "/uploads/post_images/2020/1598873165.jpg",
        "300": "/uploads/post_images/2020/300_1598873165.jpg",
        "900": "/uploads/post_images/2020/900_1598873165.jpg"
    },
    "thumbnail": "/uploads/post_images/2020/300_1598873165.jpg"
},

now how can i modify this below query to get only one item from this array such as thumbnail?

public function allData()
{
    $posts = Post::with(['groups', 'categories' => function ($query) {
        $query->whereLocked(false);
    }])->wherePublished(true)->get();
    return response()->json([
        'posts' => $posts,
    ], 200);
}

@FelippeDuarte featured_image is a column on Posts model — DolDurma
– DolDurma, Commented Aug 31, 2020 at 18:22
@FelippeDuarte yes, thats right, like with pasted output in post — DolDurma
– DolDurma, Commented Aug 31, 2020 at 18:29
You'll probably have to use a join() (or similar) to extract featured_image->thumbnail to a column, then pass forward in your response. You could iterate $posts and do $post->thumbnail = $post->feature_image->thumbnail;, but that's potentially quite slow. — Tim Lewis
– Tim Lewis, Commented Aug 31, 2020 at 18:33

Alzafan Christian · Accepted Answer · 2020-08-31 19:45:50Z

1

you can try this :

public function allData()
{
    $posts = Post::with(['groups', 'categories' => function ($query) {
        $query->whereLocked(false);
    }])->wherePublished(true)
    ->select('{primary must included to use With}', 'other', 'columns', 'featured_image->thumbnail as thumbnail')
    ->get();
    return response()->json([
        'posts' => $posts,
    ], 200);
}

edited Aug 31, 2020 at 19:45

answered Aug 31, 2020 at 19:12

Alzafan Christian

5894 silver badges9 bronze badges

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

3 Comments

Tim Lewis Over a year ago

One quick fix, featured_image->thumbnails would be featured_image->thumbnail (no 's', not pluralized)

Tim Lewis Over a year ago

No problem! And you tag like this: @TimLewis (@ before my username, with no spaces), but I got notified anyway (if only 1 person has commented, they are notified)

DolDurma Over a year ago

@AlzafanChristian how about relationships? such as 'groups', 'categories', i don't have them in output of query

Collectives™ on Stack Overflow

Laravel get single item from Array in Query with relation ship

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related