I am using the cf7 'Table List' and 'Read Data' to read from a table in my database.
My problem is that if I use an ORDER BY clause (in the Advanced Settings) to initially order the results based on 1 column, then none of the other sort buttons for the other columns work. They only work if I remove my initial ORDER BY clause.
My goal is to have both
1) an initial ORDER BY clause, for when the page loads, and
2) the ability for users to click on the sort buttons on any of the sortable columns and be able to override the initial ORDER BY clause.
Is this possible?
I think that this may not be possible in v7, but v8 has it:
the tutorial here will show you how to start a table listing in v8:
https://www.chronoengine.com/faqs/chronoforms/chronoforms8/create-a-table-list-in-chronoforms8
