Title: Default ORDER BY
Last modified: February 20, 2020

---

# Default ORDER BY

 *  Resolved [mikebian](https://wordpress.org/support/users/mikebian/)
 * (@mikebian)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/default-order-by/)
 * I created a Data Project, and in the Manage Table Options, I am setting the “
   Default ORDER BY” field to
 * startDate desc
 * which is a valid field, and it is not working. The rest of the options I set,
   mostly Manage Columns, are working just fine. I tried this in a couple of different
   Data Projects and the default sort just does not work.
 * Any thoughts?
 * Thanks

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/default-order-by/#post-12462456)
 * Hi Mike,
 * Please be aware that a default order by defined in Manage Table Options is used
   to sort your child table, not your parent table. At this time a default order
   by at parent level is not available. There is a change request for it, so it 
   is on my to do list. I will add it to the project page definition.
 * Does this clarify your problem?
 * Best regards,
    Peter
 *  Thread Starter [mikebian](https://wordpress.org/support/users/mikebian/)
 * (@mikebian)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/default-order-by/#post-12462855)
 * Yup. That clarifies it perfectly. Thanks for the quick response. And thanks for
   the plugin. That’s a pretty awesome bit of code!
 *  [YuppiDu](https://wordpress.org/support/users/andreavecchi71/)
 * (@andreavecchi71)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/default-order-by/#post-13274656)
 * Hi Peter, will this feature be available in premium version?
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/default-order-by/#post-13274797)
 * Hi Andrea,
 * I will add it to the free version!
 * Sorry, I already wanted to have this done, but it has been an extremely busy 
   period. I’ll do my best to add it to the next release…
 * Best regards,
    Peter

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Default ORDER BY’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

## Tags

 * [order by](https://wordpress.org/support/topic-tag/order-by/)

 * 4 replies
 * 3 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [5 years, 8 months ago](https://wordpress.org/support/topic/default-order-by/#post-13274797)
 * Status: resolved