2.7 and Lister subfield sorting column error

[somatonic]

I have 2.7.1 and ListerPro 1.0.8. Now the sorting on a subfield isn't working anymore. It was working fine in 2.6.10 and ListerPro 1.0.5.

The field is a PageTable field, sorting now shows the error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column '_sort_table_article_colors_article_images.article_images' in 'order clause'

[ryancramerdesign]

I've pushed a fix for this. I don't think it could have been working before however (for PageTable), because the code was not there to support it. The non-exception result you saw in 2.6 would have likely been because it was it falling back to the sort by the 'data' column. 2.7 expanded the options for sorting by columns, so it's no longer falling back to a useless sort by the data column, which is why you saw that exception. The latest commit to the dev branch now lets you sort by subfields of PageTable and Repeater. I'm still not sure how useful this actually is, since they are multi-value fields, but at least it's there.

[Renobird]

Hi Ryan,

I'm having this same issue with sorting. Unrelated to Lister.

In 2.7.1 and prior this worked: sort=page_selector.title

In 2.7.3 I get the following error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column '_sort_page_selector_title.title' in 'order clause'

[Renobird]

Just to further confirm this issue, in a template I have the following:

$pages->find("template=scholarships, sort=page_selector");
where "page_selector" is a page field.

The above works as expected, but if you add a sub-field to the sort it results in the SQLSTATE error.
$pages->find("template=scholarships, sort=page_selector.title");

I'm going to open a new issue.