Make columns sortable

Make columns sortable in a ChronoForms table list.

Overview

The issue occurs when the sorting widget is not properly configured in both the table headers and the data action settings.
Add the sorting widget to the table headers and reference it in the columns list. Then, ensure the sortable fields are also specified in the Read Data action to enable functional ascending and descending sorting.

Answered
ChronoForms v6
to touretteroma 20 Apr, 2019
Dear all,
recently, you added "Table List" component. It is very usefull to display the content of a table from database.
How is possible to make columns sortable? is it possible to add a "Sorting link" to the headers? How to configure the sorting link?

I would like to create something similar to your page where is possible to view the content of the table attached to the form.

Thanks
Max_admin Max_admin 21 Apr, 2019
You will need to use the sorting widget in the headers area of the table then call it in your table settings, I'm supposed to add a demo on this feature soon!

Best regards
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
to touretteroma 21 Apr, 2019
Dear Max,
I'm trying to put a sorting widget in the headers area, but it is not clear which should be the value in "Field" and "Content" of the sorting widget.
Moreove, what does it means "... then call it in your table settings" ?
Could you please provide a simple sample :-)
Happy Easter
Tourette Roma
he healyhatman 21 Apr, 2019
Field would probably be the name of the field it's sorting by and Content would be the text content of the heading.
to touretteroma 22 Apr, 2019
I'm trying... unsuccessfully.
Here my sample... no sorting link is displayed
Where am I wrong?[file=12110]LIST_TEST_22_Apr_2019_12_34_36.cf6bak[/file]
he healyhatman 22 Apr, 2019
In your columns list, replace Header with {view:sortername}
For example,
Data3.id:{view:sorter2}
to touretteroma 22 Apr, 2019
Yes, now sortable widget appears on header. But clicking, ascending/descending order doesn't change.
Here my updated form.
I added sortable fields (A list of fields to be open for sorting using the sorter widget) but order never changes
​[file=12111]LIST_TEST_22_Apr_2019_15_33_46.cf6bak[/file]
Max_admin Max_admin 24 Apr, 2019
And you added this list to the "Read data" action too ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
to touretteroma 24 Apr, 2019
Answer
Yes, I do it.
Please, look
Make columns sortable image 1
Is it correct?
Why doesn't sort ascending/descending?
Regards
to touretteroma 28 Apr, 2019
Dear all,
any further suggestions about this topic?
Regards
This topic is locked and no more replies can be posted.