This forum has moved to a new location and is in read-only mode. Please visit talk.octobercms.com to access the new location.

craw
craw

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

Flynsarmy
Flynsarmy

The above works in mysql which is what October supports. If you're on a different DB then please leave an issue on the git repo about it.

craw
craw

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

Flynsarmy
Flynsarmy

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

You cannot edit posts or make replies: the forum has moved to talk.octobercms.com.