smallrecords icon indicating copy to clipboard operation
smallrecords copied to clipboard

Sorting on Images

Open zlobec opened this issue 4 years ago • 1 comments

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 joinjanvince_smallrecords_records_categoriesonjanvince_smallrecords_categories.id=janvince_smallrecords_records_categories.category_idwherejanvince_smallrecords_records.id=janvince_smallrecords_records_categories.record_id) as categoriesfromjanvince_smallrecords_recordswherearea_id= 4 order byimages desc limit 20 offset 20)

I didn't have more time to go deeper.

zlobec avatar Oct 31 '20 13:10 zlobec

Looks like specific for MySQL as with SQLite sorting is OK.

I will look over this when I have some time.

jan-vince avatar Nov 13 '20 08:11 jan-vince