How to use pluck() method with custom method attribute ?

The accessor relies on the query having already run; the data fetched and the model hydrated. You are attempting to use a PHP-land accessor in a SQL query.

You can do this, but it is not very efficient because you need to create an Artist instance for every record (even though that instance has only the needed columns:

$arists = Artist::get(['id', 'firstname', 'lastname'])
	->pluck("full_name", "id")
	->toArray();

Instead, I would let the database concatenate for me using a selectRaw query method to concatenate the fields

$arists = Artist::selectRaw("id, concat(firstname, ' ', lastname) as full_name")->pluck('full_name', 'id');

Thanks for your answers.

Well I have tested your answer tykus. It works fine.

But I try to add an ->orderBy() after the get() method. I get an error.

@vincent15000 So use selectRaw

$arists = Artist::selectRaw("id, concat(firstname, ' ', lastname) as full_name")->orderBy('full_name')->pluck('full_name', 'id')->toArray();

Thanks ! ;)

The get() is the end of the Query Builder part; thereafter you are in EloquentCollection land. Although many methods share the same name, you are working with different objects across that expression depending on what each method returns.

If @michaloravec answer helped you more, please consider marking it Best Reply

@michaloravec ... sorry ... all is good ! It works fine too !

@vincent15000 Great when you choose as best answer to your one :D

This will work propably better

$artists = DB::table('artists')->selectRaw("id, concat(firstname, ' ', lastname) as full_name")->orderBy('full_name')->pluck('full_name', 'id')->toArray();