[Resolved] Multiple Sort Criteria in Views

[Author]

Posts

[carlosB-2]

Tell us what you are trying to do?

I'm trying to sort a view on more than one field value, and I'm only given limited options for a secondary sort.

I found this post from 2012: https://toolset.com/forums/topic/multiple-sort-criteria/#post-15873 that offers a method that can be added to my functions.php file, but I also found several other forum posts from around the same time saying that multiple sort criteria is in the works, and I'm just wondering if that has happened yet.

If not, are there any other methods to try for doing multiple sorts in one view?

Thanks!

[Noman]

Hi Carlos,

Thank you for contacting Toolset support. This feature was submitted and is under consideration still.

So right now the solution would be to do that using custom code and wpv_filter_query hook:
https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query

You can use the code given in above ticket that you have posted. OR a solution given below that may work as well (modification could be needed):
https://toolset.com/forums/topic/order-by-two-or-multiple-parameters/#post-263775

Thank you

[carlosB-2]

Thank you... I will use those resources to work on this.

[carlosB-2]

Hi Norman - I'm having trouble adding the code using the sample code you sent me... this is what I'm using in my functions.php file.

add_filter('wpv_filter_query', 'setup_order', 10, 2);
function setup_order($q, $view) {
        // adjust this condition to decide when to apply the filter
        if ($view['view_id'] == 4072) {  
                add_filter('posts_orderby', 'adjust_order');
        }
        return $q;
}
function adjust_order($order) {
        remove_filter('posts_orderby', 'adjust_order');
        global $wpdb;
        $order .= ', ' . $wpdb->prefix . 'postmeta.wpcf-thescon-room-number ASC';
        echo $order;
        return $order;
}

The view itself is sorted on a field called thescon-session, ascending and is output here:

hidden link

I think my problem is in the adjust_order function where we're adding the second field to sort on...

$order .= ', ' . $wpdb->prefix . 'postmeta.wpcf-thescon-room-number ASC';

I've also tried posts.thescon-room-number ASC and that doesn't work either.

Actually, when I use these functions, I'm getting no results at all. If I disable the functions, I do get results.

Thanks in advance for your help.