Sort by multiple columns

Question

Sort by multiple columns

Opened this issue 9 years ago · 3 comments

I guess I'm just overlooking something, as this is pretty much standard functionality, but how can I order data source results by multiple columns? Like ORDER BY date ASC, title ASC?

Answer 1 · 2015-09-27T23:55:33.000Z

It's not supported by Symphony.

Answer 2 · 2015-09-28T06:40:06.000Z

@brendo Any way to hack it in? Or is this a more complex issue? Is there a common (non-xsl) workaround that's usable with pagination?

Answer 3 · 2015-09-28T16:11:38.000Z

@jensscherbl I would also be interested in this feature.

But it would also require touching the EntryManager class: https://github.com/symphonycms/symphony-2/blob/master/symphony/lib/toolkit/data-sources/class.datasource.section.php#L511-L522