Laravel Eloquent specific columns error

Question

I have the following in Laravel 4.x using eloquent:

Book table has a dozen fields.

$single_data = Book::
            selectRaw("GROUP_CONCAT(DISTINCT CAST(id as char) SEPARATOR ',') as type_id_list")
            ->first();

Question: the data returned is everything within the table inside Book AND type_id_list as seen from the selectRaw.

I would like to ONLY return what I specified within the selectRaw.

It was suggested that you get add an array of columns within first() or get() in order to retrieve this only - however it is not working with custom selectRaw where you specify an expression or your own wording. It throws an error and when the query is analyzed the array that you put in first/get gets appended as part of the select.

Does anyone have a work around?

@Andreas ah, it does work too - but I will use pluck instead as it gives back the value itself immediately and not the object too. — azngunit81
– azngunit81, Commented Jun 27, 2014 at 13:53
You should probably report this as a bug. github.com/laravel/framework/issues — Andreas
– Andreas, Commented Jun 27, 2014 at 14:06
first() and first([]) gives exactly the same result, which is a Book model with single attribute type_id_list (and other properties unrelated to the query like exists etc) because Eloquent provided with selectRaw ignores any previous selects. Given multiple selectRaw methods, it will use only last one. — Jarek Tkaczyk
– Jarek Tkaczyk, Commented Jun 27, 2014 at 15:05

Jarek Tkaczyk · Accepted Answer · 2014-06-27 08:01:26Z

1

first() will return only that particular column but wrapped in a Book object anyway, so use pluck() instead:

$single_data = Book::
        selectRaw("GROUP_CONCAT(DISTINCT CAST(id as char) SEPARATOR ',') as type_id_list")
          ->pluck('type_id_list');

answered Jun 27, 2014 at 8:01

Jarek Tkaczyk

81.4k27 gold badges167 silver badges162 bronze badges

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

1 Comment

azngunit81 Over a year ago

Note: Andreas' comment first([]) will yield the correct result but I will need to do ->type_id_list to get the info.

Collectives™ on Stack Overflow

Laravel Eloquent specific columns error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related