StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I believe you will find this functionality under a class called PostsOrderedByMetaQuery that extends WP_Query and accepts new arguments 'orderby_meta_key' and 'orderby_order'</p> <pre><code>class PostsOrderedByMetaQuery extends WP_Query { var $posts_ordered_by_meta = true; var $orderby_order = 'ASC'; var $orderby_meta_key; function __construct($args=array()) { add_filter('posts_join',array(&$this,'posts_join'),10,2); add_filter('posts_orderby',array(&$this,'posts_orderby'),10,2); $this->posts_ordered_by_meta = true; $this->orderby_meta_key = $args['orderby_meta_key']; unset($args['orderby_meta_key']); if (!empty($args['orderby_order'])) { $this->orderby_order = $args['orderby_order']; unset($args['orderby_order']); } parent::query($args); } function posts_join($join,$query) { if (isset($query->posts_ordered_by_meta)) { global $wpdb; $join .=<<<SQL INNER JOIN {$wpdb->postmeta} postmeta_price ON postmeta_price.post_id={$wpdb->posts}.ID AND postmeta_price.meta_key='{$this->orderby_meta_key}' SQL; } return $join; } function posts_orderby($orderby,$query) { if (isset($query->posts_ordered_by_meta)) { global $wpdb; $orderby = "postmeta_price.meta_value {$this->orderby_order}"; } return $orderby; } } </code></pre> <p>You would call it like this:</p> <pre><code> $thirtydays = date('Y/m/d', strtotime('+30 days')); $paged = (get_query_var('paged')) ? get_query_var('paged') : 1; $query = new PostsOrderedByMetaQuery(array ( 'post_type' => array('post', 'real-estate'), 'meta_key' => 'Time Available', 'meta_compare' => '<=', 'meta_value' => $thirtydays, 'paged' => $paged, 'orderby_meta_key' => 'Price', 'orderby_order' => 'DESC', )); foreach($query->posts as $post) { echo " {$post->post_title}\n"; } </code></pre> <p>You can copy the PostsOrderedByMetaQuery class to your theme's functions.php file, or you can use it within a .php file of a plugin you may be writing.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload