WordPress Ideas » Topic: Independent ASC/DESC in multiple ORDER BY statement. http://wordpress.org/ideas/topic/independent-ascdesc-in-multiple-order-by-statement WordPress Ideas » Topic: Independent ASC/DESC in multiple ORDER BY statement. en-US Tue, 18 Jun 2013 05:20:07 +0000 http://bbpress.org/?v=1.1 prophecy2040 on "Independent ASC/DESC in multiple ORDER BY statement." http://wordpress.org/ideas/topic/independent-ascdesc-in-multiple-order-by-statement#post-24267 Fri, 01 Mar 2013 18:26:36 +0000 prophecy2040 24267@http://wordpress.org/ideas/ I came across the need for this just the other day on two separate sites I was working on. I ended up having to hook into the posts_orderby filter and modify it for the certain instance I needed - so it was a lot more work than it should have been.

With the more versatile uses of WordPress sites these days, the need arises to perform more complex queries to get the right data. And who wants to have to write their own custom query calls when WP_Query is so great and easy to use?

I mainly just want to agree with extending the WP_Query class to allow for this functionality. With the great features like the meta_queries and the integration of the custom post type taxonomy - it just falls flat without the ability to sort the multiple columns independently.

Don Fischer

]]> Simon on "Independent ASC/DESC in multiple ORDER BY statement." http://wordpress.org/ideas/topic/independent-ascdesc-in-multiple-order-by-statement#post-24163 Thu, 07 Feb 2013 14:06:58 +0000 Simon 24163@http://wordpress.org/ideas/ It can be usefull, thx

]]> leemon on "Independent ASC/DESC in multiple ORDER BY statement." http://wordpress.org/ideas/topic/independent-ascdesc-in-multiple-order-by-statement#post-24160 Wed, 06 Feb 2013 19:57:21 +0000 leemon 24160@http://wordpress.org/ideas/ WP_Query supports ordering results by multiple columns, but does not currently support independent ASC/DESC declarations on those columns. Instead, it concatenates the ORDER and ORDER BY statements together.

In some cases, it would be beneficial to independently set the order for these columns. An example offered on WP-Hackers:

I have a situation where I want to order a list of post both by author and date using WP_Query which isn't a problem since 'orderby' lets me do that. But I want the author part sorted ascending and date part sorted descending.

A normal MySql statement would end with ORDER BY author ASC, date DESC.

We should extend WP_Query to allow users to set their ordering parameters independently. This should be done in such a way as to not break backwards compatibility.

http://core.trac.wordpress.org/ticket/17065

]]>