smallrecords
smallrecords copied to clipboard
Sorting on Images
When Images are added as a column in List setup, sorting returns an error when clicked on the Images column to sort:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'images' in 'order clause' (SQL: select
janvince_smallrecords_records.*, name as
name, (select group_concat(name separator ', ') from
janvince_smallrecords_categoriesinner join
janvince_smallrecords_records_categorieson
janvince_smallrecords_categories.
id=
janvince_smallrecords_records_categories.
category_idwhere
janvince_smallrecords_records.
id=
janvince_smallrecords_records_categories.
record_id) as
categoriesfrom
janvince_smallrecords_recordswhere
area_id= 4 order by
images desc limit 20 offset 20)
I didn't have more time to go deeper.
Looks like specific for MySQL as with SQLite sorting is OK.
I will look over this when I have some time.