Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

'Order by' broken when using concat label with databasejoin field #1261

Closed
batonac opened this issue Jun 9, 2014 · 1 comment
Closed

'Order by' broken when using concat label with databasejoin field #1261

batonac opened this issue Jun 9, 2014 · 1 comment

Comments

@batonac
Copy link

batonac commented Jun 9, 2014

When using a concat label with a databasejoin field in Fabrik 3.1 (latest from Github), enabling 'order by' in the list view settings, and attempting to order the list by that column from the list view, the resultant query uses the entire concat string in the 'ORDER BY' clause, instead of using calling the column alias.

For example, when I enter, {thistable}.number,' ',{thistable}.name into the concat label field, and then try to sort by that databasejoin element column, the resultant query contains both CONCAT_WS('', threecore_category.number,' ',threecore_category.name) AS threecore___category_id in the SELECT clause, and ORDER BY CONCAT_WS('',threecore_category.number,' ',threecore_category.name) asc' at the end. It should say ORDER BY threecore___category_id asc instead...

@pollen8
Copy link
Member

pollen8 commented Oct 21, 2015

this seems to be fixed. Closing the ticket. If its still an issue please feel free to reopen it

@pollen8 pollen8 closed this as completed Oct 21, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants