This forum has moved to a new location and is in read-only mode. Please visit talk.octobercms.com to access the new location.
If I make a composed column in the Backend like this:
columns:
fullname:
label: Numm
select: concat(first_name, ' ', last_name)
If I order the column asc / desc I get this error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'concat(first_name, ' ', last_name)' in 'order clause' (SQL: select wetzel_memberlist_members
.*, concat(first_name, ' ', last_name) as fullname
from wetzel_memberlist_members
order by concat(first_name, ' ', last_name)
asc limit 25 offset 0)" on line 600 of ...
Last updated
I'm using mysql. It shows the column but the error only occures when I try to order the composed column.
Screenshot: http://s9.postimg.org/xlfu01g8t/Bildschirmfoto_2014_09_08_um_14_25_25.png
Last updated
What version of MySQL are you on? If I run
select users.*, concat(name, ' ', email) as fullname from users order by concat(name, ' ', email) asc
in mine it works fine, so mysql is able to order by composed columns fine in v14.14 at least.
1-4 of 4