Eloquent: Retrieve pluck collection with trashed entries

Question

I want to get all Address IDs, including the trashed ones, with pluck. This is how it is working but I don't get the trashed ones as well...:

$clientIDs = Client::pluck('address_id')->all();

This is what I tried already:

$clientIDs = Client::pluck('address_id')
                        ->withTrashed()
                        ->get();

Throws: Method withTrashed does not exist.

How can I use pluck and withTrashed() and solve this problem?

Kind regards!

score 5 · Accepted Answer · answered Jul 01 '18 at 20:15

pluck() already finalises the query and retrieves the info from the database for you. So the ->all() call is redundant for that - what it does is convert the Eloquent collection into an array.

For that reason, you're calling withTrashed() after the query has already been executed. Move them and it'll work:

$clientIds = Client::withTrashed()->pluck('address_id'); // no need for ->get()

Eloquent: Retrieve pluck collection with trashed entries

1 Answers1