sort by two meta keys

Question

I'm trying to order data with two meta keys but I'm not able to do that.

This code is not working for me:

 $args= array(
  "post_type" => "post_type",
  "post_status" => "publish",
  'meta_query'    => array(

                            array(
                                'key'     => 'keyname1',
                                'orderby' => 'meta_value_num',
                                'order' => DESC,
                            ),
                                 array(
                                'key'     => 'keyname2',
                                'orderby' => 'meta_value_num',
                                'order' => DESC,
                            ),

),


  "posts_per_page" => 10
);

This code works for the single key perfectly, but not for the two keys:

$args=array(
      "post_type" => "post_type",
      "post_status" => "publish",
      "orderby" => array(
      "meta_value_num" => "DESC",
      "rand" => "ASC" ),
      "meta_key" => "keyname",);

How can I do this?

are you using `WP_QUERY` ? try print the executed query for above `$args` like -> `$query = new WP_QUERY($args); print_r($query->request);` ? and try running the query in database to check whats issue with ordering — Noman, Dec 15 '16 at 06:17
Can you check this link helpful for you?http://stackoverflow.com/questions/17745334/how-to-order-by-multiple-meta-keys — Jomol MJ, Dec 15 '16 at 06:17
@JomalJohn Thanks for reminding this solution figured it out. — RItika, Dec 15 '16 at 06:48

score 1 · Answer 1 · answered Dec 15 '16 at 06:46

I have figured out the solution thanks @Jomal John for reminding me this solutions again. Here's the answer might me helpful for someone.

$args=array(
  "post_type" => "post_type",
  "post_status" => "publish",
  "meta_query"    => array(

             'key_1_clause' => array(
            'key' => 'key_1',

        ),
     'key_2_clause' => array(
            'key' => 'key_2',

        ),


),
    'orderby' => array(
     "meta_value_num" => "DESC",
        'key_1_clause' => 'DESC',
        'key_2_clause' => 'DESC',
    ),

 "posts_per_page" => 10
);

vikas pandey · Answer 2 · 2016-12-15T09:19:51.347

0

After add 'relation'=>'OR' try this i think work well

<?php
$_query = new WP_Query( array(
        'post_type'         => 'post_type',
        'post_status'       => 'publish',
        'meta_query' => array(
            'relation' => 'OR',
            array(
                'key'     => 'key1'
            ),
            array(
                'key'     => 'key2'
            ),
        ),
    ) );
?>

edited Dec 15 '16 at 09:19

answered Dec 15 '16 at 06:36

vikas pandey

194
7

sort by two meta keys

2 Answers2