Hi @waldiwaldi,
For single tables pages and parent tables:
> Edit your project
> Edit your project page
> Enter your order by column in Page Orderby (allows asc|desc & multiple columns)
> Save
Examples:
ORDER BY city asc, lastname desc
city, lastname
Works with and without ORDER BY.
For child tables:
> Add your table to Manage Table Options
> Enter your order by in Default ORDER BY
Syntax is similar as above.
Sorry, this should be documented! I’ll add it to the dpocumentation next weeek.
Please let me know if this works.
Best regards,
Peter
The above method you described only works on the page displayed in the created backend menu. When I put such a page on the entry and it is displayed at the front of the page, then sorting does not work.
For comparison, the WHERE CLAUSE conditions work both on the front and back of the page
Looks like a bug! I will investigate this issue. Thank you for reporting!
Best regards,
Peter
In Data Publisher, the “Default order/by” option does not work as described above
However, it works, but the rule is different than described above, i.e. column number, sort type (e.g. 1, asc)
Hi @waldiwaldi,
The Data Publisher is a different tool that uses a different API. A Data Project uses the WordPress list table class. The Data Publisher uses jQuery DataTables. The plugin follows the strategies of the different API’s. This allows maximum flexibility, but makes it harder to understand. Sorry! One of the many topics for approvement… 🙂
Best regards,
Peter
