[wp-trac] [WordPress Trac] #17485: Sort Order by Date in WP Gallery resorts to order by ID

[WordPress Trac]

#17485: Sort Order by Date in WP Gallery resorts to order by ID
-----------------------------------+-----------------------------
 Reporter:  nrajesh                |       Owner:  dd32
     Type:  defect (bug)           |      Status:  reopened
 Priority:  normal                 |   Milestone:  Future Release
Component:  Gallery                |     Version:  3.1.2
 Severity:  normal                 |  Resolution:
 Keywords:  3.3-early westi-likes  |
-----------------------------------+-----------------------------

Comment (by westi):

 Note you can do: [gallery orderby="post_date"] at the moment in trunk so
 we could just hook the UI up to do that instead of [gallery orderby="ID"]

 EXPLAIN on both queries is the same:

 {{{
 1       SIMPLE  wp_posts        ref     type_status_date,post_parent
 post_parent     8       const   1       Using where; Using filesort
 }}}

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/17485#comment:11>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software