While creating a table I often need to order it by more than one column. e.g. name and first name, or position and name, ...
Is there a possibility to create a table with more than one order criteria? Often I order by a help column which is not visible, Thus the manual sorting for with more than one column does not work.
1. While creating a table it would be helpful to generate it with a SQL like e.g.:
SELECT * FROM wp_example ORDER BY Name, FirstName, ...
2. Allow to sort not only one column in specified order like it is right now in the process after creating the table.
This is why I ask for it. You have in a table four Millers:
Miller, Anton Miller, Charly Miller, Fred Miller, William
I need those persons in alphabetical order as it is shown above. But when William was entered first he will be on the top of the list. Of course I can add an additional column with a combination of Name and FirstName. But this is not the most elegant solution as there might be examples with more than two columns e.g. with town in addition and so on.
Unfortunately something like this is not possible with the plugin features at the moment.
But your idea is quite interesting so I will add your suggestion to our TODO list so maybe we can consider this implementation, or something similar , for our future releases.
While creating a table I often need to order it by more than one column. e.g. name and first name, or position and name, ...
Is there a possibility to create a table with more than one order criteria? Often I order by a help column which is not visible, Thus the manual sorting for with more than one column does not work.
Hi gottfried_s,
Thank you for your purchase.
Can you please describe me more what are you trying to achieve because I did not quite understand.
Thank you.
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 Bogdan,
there are two alternatives:
1. While creating a table it would be helpful to generate it with a SQL like e.g.:
SELECT * FROM wp_example ORDER BY Name, FirstName, ...
2. Allow to sort not only one column in specified order like it is right now in the process after creating the table.
This is why I ask for it. You have in a table four Millers:
Miller, Anton
Miller, Charly
Miller, Fred
Miller, William
I need those persons in alphabetical order as it is shown above. But when William was entered first he will be on the top of the list. Of course I can add an additional column with a combination of Name and FirstName. But this is not the most elegant solution as there might be examples with more than two columns e.g. with town in addition and so on.
I hope you now get the point I am hinting on.
Hi gottfried_s,
Unfortunately something like this is not possible with the plugin features at the moment.
But your idea is quite interesting so I will add your suggestion to our TODO list so maybe we can consider this implementation, or something similar , for our future releases.
Best regards.
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