[wp-trac] [WordPress Trac] #13729: Post Query should be able to order by specific order passed in "post__in"

[WordPress Trac]

#13729: Post Query should be able to order by specific order passed in "post__in"
-------------------------+--------------------------------------------------
 Reporter:  jakemgold    |       Owner:  ryan                           
     Type:  enhancement  |      Status:  new                            
 Priority:  normal       |   Milestone:  3.1                            
Component:  Query        |     Version:  3.0                            
 Severity:  minor        |    Keywords:  post__in, custom query, orderby
-------------------------+--------------------------------------------------
 Post queries can specify the posts to retrieve by passing an array of post
 IDs to the "post__in" parameter.

 There is no built in method for sorting those posts by the order
 specified. In fact, I would argue that when using "post__in", the post
 query should, by ''default'', order the posts in the same order specified
 in that array (I think this is the expected behavior by the developer).

 Many custom themes allow the developer to specifically designate featured
 posts, controlling the order in which they appear. Many of these themes
 are forced to make independent queries for each post or execute an
 atypical loop by calling the result by ID (the post array's key). The
 ability to "fetch", properly order, and execute a standard loop for a
 specific set of posts in a specific order would reduce overhead and
 complexity in these situations.

 I've developed a plug-in that does this as a workaround:

 http://wordpress.org/extend/plugins/sort-query-by-post-in/

 The 3.0+ specific code in there is *very* simple. It would be even more
 simple to do in base code (just another "case" in the orderby switch part
 of the query builder). In fact, I intend to submit a patch after 3.0 is
 released.

 My plug-in provides the framework for the SQL to do this.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/13729>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software