order - Read For Learn

Sorting: custom query with orderby meta_value_num THEN by title

This is very crude but should sort your posts by year (meta_value) and then by title. It does depend on how the query is setup so it will only work with the query below or with similar ones. function alter_order_wpse_103181($order,$qry) { remove_filter(‘posts_orderby’,’alter_order’,1,2); $order = explode(‘,’,$order); $order = implode( ‘ ASC,’,$order); return $order; } add_filter(‘posts_orderby’,’alter_order_wpse_103181′,1,2); $q … Read more

Pre_Get_Posts order DESC not registering

I’m not sure why, but it had to do with the title in my ordering, once I removed that everything started working fine. I’ll leave this open for anyone who knows why. $query->set(‘orderby’, ‘meta_value_num title’); – Does not Work $query->set(‘orderby’, ‘meta_value_num’); – Works!

Custom Post Type Order Index Loop

You’re only referencing the event date in your query, which is why you’re not getting normal posts (because I assume they don’t have an event date). You can use “orderby” with multiple values (separated by a space), so you should be able to change it to: ‘orderby’ => ‘meta_value date’ That should mean that the … Read more

Query category-specific, paginated posts and allow viewer to change sort order

Is There A Way To Add Weight Or Order To Tags?

Apply ordering args to newly merged queried

Here’s what I’d do. This is mildly tested. It gets the IDs of all the posts you need and then builds a single query to get the posts in the correct order. // get your page IDs, I assume this returns an array of integers $page_ids = get_pageslug(” ‘first_page’, ‘second_page’ “); // get your blog … Read more

$args Orderby The number

You could use the get_terms_orderby filter: add_filter( ‘get_terms_orderby’, ‘wpse156153_get_terms_orderby’, 10, 3 ); $categories=get_categories($cat_args); remove_filter( ‘get_terms_orderby’, ‘wpse156153_get_terms_orderby’, 10, 3 ); with function wpse156153_get_terms_orderby($orderby, $args, $taxonomies ) { return ‘FIELD(t.term_id, ‘ . $args[‘include’] . ‘)’; }

Order Custom Posts by Several Fields

You can do it with WP_Query:- $query = new WP_Query( array ( ‘post_type’ => ‘product’, ‘orderby’ => ‘meta_value’, ‘meta_key’ => ‘price’ ) ); Replace ‘price’ with your meta key. Reference:- http://codex.wordpress.org/Class_Reference/WP_Query#Order_.26_Orderby_Parameters

Re-order posts inside tax query

How to order posts by the user_login that corresponds to a meta_value (which is a user id)?

Ok, solved this. I had to use the posts_clausesfilter and the following code: function assigned_to_orderby( $clauses, $wp_query ) { global $wpdb; $clauses[‘join’] .= ” LEFT OUTER JOIN {$wpdb->postmeta} ON {$wpdb->posts}.ID={$wpdb->postmeta}.post_id LEFT OUTER JOIN {$wpdb->users} ON {$wpdb->users}.ID={$wpdb->postmeta}.meta_value “; $clauses[‘where’] .= ” AND ({$wpdb->postmeta}.meta_key = ‘assignee’)”; $clauses[‘groupby’] = “{$wpdb->postmeta}.post_id”; $clauses[‘orderby’] = “GROUP_CONCAT({$wpdb->users}.user_login ORDER BY {$wpdb->users}.user_login ASC) “; … Read more

+ More