Filter views_edit-post. function tst($a) { // var_dump(get_defined_vars()); $tst = array(); $tst[‘future’] = $a[‘future’]; $tst[‘publish’] = $a[‘publish’]; $tst[‘all’] = $a[‘all’]; return $tst; } add_filter(‘views_edit-post’,’tst’); You can juggle that new array however you want. The only keys that are present in the incoming array are the one that have posts so you should check that the key … Read more
You are storing your “price” (apparently) as human readable formatted currency. That makes it a string. And that means it is going to be sorted alphabetically, more or less, and not numerically as you need it to be. If you can store those values without the punctuation, and use meta_value_num— your second query above (but … Read more
Basically, I am reading right out of the Codex page for WP_Query. You want a meta_query similar to this with an orderby parameter with the two values you want to order by. The first is dominant. $args = array( ‘post_type’ => ‘post’, ‘meta_query’ => array( array( ‘key’ => ‘rating’, ‘value’ => 3, ‘compare’ => ‘>’ … Read more
For those interested I figured it out. I added this to my functions.php: function set_the_terms_in_order ( $terms, $id, $taxonomy ) { $terms = wp_cache_get( $id, “{$taxonomy}_relationships_sorted” ); if ( false === $terms ) { $terms = wp_get_object_terms( $id, $taxonomy, array( ‘orderby’ => ‘term_order’ ) ); wp_cache_add($id, $terms, $taxonomy . ‘_relationships_sorted’); } return $terms; } add_filter( … Read more
Found an answer to this. Somehow WordPress’ own orderby isn’t fully functional when trying to order by multiple values. I solved this by changing WP_Query to SQL Query, and including second DESC after _postmeta.meta_value+0 SELECT XXX_posts.* FROM XXX_posts INNER JOIN XXX_postmeta ON (XXX_posts.ID = XXX_postmeta.post_id) WHERE 1=1 AND XXX_posts.post_type=”sidebar_element” AND (XXX_posts.post_status=”publish”) AND (XXX_postmeta.meta_key = ‘sidebar_element_meta_alignment’ … Read more
a) If you have reordered the images under the uploaded to this post in the media browser then they should have menu_order>0 and you can get that order with ‘orderby’ => ‘menu_order’, ‘order’ => ‘asc’ b) If you haven’t, then menu_order=0 for all these images and you will need to use ‘orderby’ => ‘ID’, ‘order’ … Read more
To the best of my knowledge, you cannot sort a query by two different parameters without an additional iteration over the retrieved posts. Since that ideally should be avoided, let me suggest a different approach: How about incorporating an additional meta value “sort_date”, or the like? And then, in your saving routine, save either the … Read more
What kind of control do you want exactly? There are, for example, plugins that provide a UI through which you can order posts by various parameters. If you just want to order them all by one parameter that will not change, you can simply add it to your query (since you can order by multiple … Read more
Solved it with: function myedit_posts_orderby($orderby_statement) { $orderby_statement = “wp_postmeta.meta_value+0 DESC, wp_posts.post_date DESC”; return $orderby_statement; } add_filter(‘posts_orderby’, ‘myedit_posts_orderby’); WP_Query… …for some reason WP_Query only applied DESC order to date, and not to meta value.
You can use meta key for ordering your result. See reference from codex here. Ex. $args = array( ‘post_type’ => ‘post’, ‘meta_key’ => ‘priority’, ‘orderby’ => ‘meta_value_num’, ‘order’ => ‘ASC’ ); $query = new WP_Query($args);