is it possible to influence the order of the automatically read filters? In our case the order seems to be random, but we would like to have an alphabetical order (see attachment).
The only way to change the order of the selectbox would be to manually add these values in the column settings, under the "Data" tab.
So, access column settings and go to the Data tab. In there, change the type to String (if you haven't already), and change the "Possible values for column" to be "Define values list". Then, below that add the values in the order in which you want them to appear:
And that's the order they will appear in the filter:
thank you for your detailed answer. I had already feared that it only works manually.
At this point, another question: I thought I could work around the problem by disabling sorting for all columns, so that the sorting is taken from our source table.
But as soon as there are no more sortable columns, the table is not displayed in the frontend anymore? Is it intended that tables without sorting are not possible?
And a further thought: could I achieve the sorting by a hidden column which counts bluntly from 1 upwards?
Hey there,
is it possible to influence the order of the automatically read filters? In our case the order seems to be random, but we would like to have an alphabetical order (see attachment).
Regards,
Kay
Hi, Kay
Thanks for reaching out to us.
The only way to change the order of the selectbox would be to manually add these values in the column settings, under the "Data" tab.
So, access column settings and go to the Data tab. In there, change the type to String (if you haven't already), and change the "Possible values for column" to be "Define values list". Then, below that add the values in the order in which you want them to appear:
And that's the order they will appear in the filter:
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hey Miloš,
thank you for your detailed answer. I had already feared that it only works manually.
At this point, another question: I thought I could work around the problem by disabling sorting for all columns, so that the sorting is taken from our source table.
But as soon as there are no more sortable columns, the table is not displayed in the frontend anymore? Is it intended that tables without sorting are not possible?
And a further thought: could I achieve the sorting by a hidden column which counts bluntly from 1 upwards?
Regards,
Kay
Hi, Kay
You're welcome, i am happy to help.
-
Yes. As far as i am aware, and if i recall correctly i had a case where a user completely disabled all sorting,
i think that due to the Datatables jQuery plugin libraries that our plugin is based on -
it is needed to have at least one column to sort by default , otherwise the table would break;
but i will double-check this with our 2nd level Team to be sure, and will report back to confirm it as quick as possible.
2.
That is a good question, i am not sure, to be honest - we will check on both points,
and going to report back to confirm them for you.
Thank you for your patience.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi, Kay
We have an update on this.
1. If you disable sorting in Sorting & Filtering tab above the table settings on back-end,
you will not have any issues.
But if that is enabled, and you manually disable sorting on all columns - that will break the table.
2. If you hide the column through the settings, then this column will not load at all on the front-end and it will not be sortable by that column.
So, it can work only if you use CSS to hide its header and cells. ( let me know if you need that, i can help with the CSS)
Let me know if that was clear, or if you have any questions. Thanks
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables