Sort in WP_Query(), not filter? Is it possible?2019 Community Moderator ElectionOrder by multiple meta key and meta valueWp_query: sort by PHP variableSort All Posts by Category Name in the Admin Panel?Possible to create a permalink to sort with meta_key?Custome column sort by date not titleWP_Query with multiple orderby NOT working with ASC and DESC, what's wrong?sort query results by newestOrderby ASC changes to DESC in WP_QueryLimit WP_Query to only X results (total, not per page)Understanding the orderby in WP_Query?Changing WP_Query params with url Query Var

What do the Banks children have against barley water?

Information to fellow intern about hiring?

Is "plugging out" electronic devices an American expression?

aging parents with no investments

Is there a familial term for apples and pears?

Does the average primeness of natural numbers tend to zero?

How can I fix this gap between bookcases I made?

Finding files for which a command fails

Pristine Bit Checking

"listening to me about as much as you're listening to this pole here"

Is it wise to hold on to stock that has plummeted and then stabilized?

Is domain driven design an anti-SQL pattern?

Is there any use for defining additional entity types in a SOQL FROM clause?

Copycat chess is back

extract characters between two commas?

Is Social Media Science Fiction?

Re-submission of rejected manuscript without informing co-authors

Does bootstrapped regression allow for inference?

Is this food a bread or a loaf?

Domain expired, GoDaddy holds it and is asking more money

Can the Produce Flame cantrip be used to grapple, or as an unarmed strike, in the right circumstances?

Need help identifying/translating a plaque in Tangier, Morocco

What is the offset in a seaplane's hull?

Symmetry in quantum mechanics



Sort in WP_Query(), not filter? Is it possible?



2019 Community Moderator ElectionOrder by multiple meta key and meta valueWp_query: sort by PHP variableSort All Posts by Category Name in the Admin Panel?Possible to create a permalink to sort with meta_key?Custome column sort by date not titleWP_Query with multiple orderby NOT working with ASC and DESC, what's wrong?sort query results by newestOrderby ASC changes to DESC in WP_QueryLimit WP_Query to only X results (total, not per page)Understanding the orderby in WP_Query?Changing WP_Query params with url Query Var



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








1















I want to query and SORT in WP_Query(). But whatever I do, it only prints posts with meta_key set up. But I want all the results and just sort them.



This is my query:



$query = new WP_Query(array(
'post_type' => 'my_post_type',
'post_status' => 'publish',
'posts_per_page' => -1,
'meta_key' => 'post_views_count',
'orderby' => 'meta_value_num',
'order' => 'DESC'
));


Any ideas how to make sorting happen? It sorts, but only shows posts with meta_key set up. I want all the posts.










share|improve this question

















  • 1





    You'll need to hook into the posts_orderby filter for that.

    – mrben522
    14 hours ago











  • Ok so as I understand correctly. I now have custom posts in wp_posts table and custom meta in wp_postmeta. Now I only need a way to "connect" those two. So in return it should be something like wp_posts.wp_postmeta DESC? Or how do I connect those two tables? Thanks a lot!

    – LubWn
    14 hours ago

















1















I want to query and SORT in WP_Query(). But whatever I do, it only prints posts with meta_key set up. But I want all the results and just sort them.



This is my query:



$query = new WP_Query(array(
'post_type' => 'my_post_type',
'post_status' => 'publish',
'posts_per_page' => -1,
'meta_key' => 'post_views_count',
'orderby' => 'meta_value_num',
'order' => 'DESC'
));


Any ideas how to make sorting happen? It sorts, but only shows posts with meta_key set up. I want all the posts.










share|improve this question

















  • 1





    You'll need to hook into the posts_orderby filter for that.

    – mrben522
    14 hours ago











  • Ok so as I understand correctly. I now have custom posts in wp_posts table and custom meta in wp_postmeta. Now I only need a way to "connect" those two. So in return it should be something like wp_posts.wp_postmeta DESC? Or how do I connect those two tables? Thanks a lot!

    – LubWn
    14 hours ago













1












1








1








I want to query and SORT in WP_Query(). But whatever I do, it only prints posts with meta_key set up. But I want all the results and just sort them.



This is my query:



$query = new WP_Query(array(
'post_type' => 'my_post_type',
'post_status' => 'publish',
'posts_per_page' => -1,
'meta_key' => 'post_views_count',
'orderby' => 'meta_value_num',
'order' => 'DESC'
));


Any ideas how to make sorting happen? It sorts, but only shows posts with meta_key set up. I want all the posts.










share|improve this question














I want to query and SORT in WP_Query(). But whatever I do, it only prints posts with meta_key set up. But I want all the results and just sort them.



This is my query:



$query = new WP_Query(array(
'post_type' => 'my_post_type',
'post_status' => 'publish',
'posts_per_page' => -1,
'meta_key' => 'post_views_count',
'orderby' => 'meta_value_num',
'order' => 'DESC'
));


Any ideas how to make sorting happen? It sorts, but only shows posts with meta_key set up. I want all the posts.







wp-query sort






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked 15 hours ago









LubWnLubWn

154




154







  • 1





    You'll need to hook into the posts_orderby filter for that.

    – mrben522
    14 hours ago











  • Ok so as I understand correctly. I now have custom posts in wp_posts table and custom meta in wp_postmeta. Now I only need a way to "connect" those two. So in return it should be something like wp_posts.wp_postmeta DESC? Or how do I connect those two tables? Thanks a lot!

    – LubWn
    14 hours ago












  • 1





    You'll need to hook into the posts_orderby filter for that.

    – mrben522
    14 hours ago











  • Ok so as I understand correctly. I now have custom posts in wp_posts table and custom meta in wp_postmeta. Now I only need a way to "connect" those two. So in return it should be something like wp_posts.wp_postmeta DESC? Or how do I connect those two tables? Thanks a lot!

    – LubWn
    14 hours ago







1




1





You'll need to hook into the posts_orderby filter for that.

– mrben522
14 hours ago





You'll need to hook into the posts_orderby filter for that.

– mrben522
14 hours ago













Ok so as I understand correctly. I now have custom posts in wp_posts table and custom meta in wp_postmeta. Now I only need a way to "connect" those two. So in return it should be something like wp_posts.wp_postmeta DESC? Or how do I connect those two tables? Thanks a lot!

– LubWn
14 hours ago





Ok so as I understand correctly. I now have custom posts in wp_posts table and custom meta in wp_postmeta. Now I only need a way to "connect" those two. So in return it should be something like wp_posts.wp_postmeta DESC? Or how do I connect those two tables? Thanks a lot!

– LubWn
14 hours ago










2 Answers
2






active

oldest

votes


















3














If you want to sort the posts by the meta post_views_count, and still include posts that do not have that meta, you can use meta_query like so:



'meta_query' => array(
'relation' => 'OR', // make sure it's OR
// Include posts that have the meta.
array(
'key' => 'post_views_count',
'compare' => 'EXISTS',
),
// Include posts that don't have the meta.
array(
'key' => 'post_views_count',
'compare' => 'NOT EXISTS',
),
),


And you can just use that in place of this:



'meta_key' => 'post_views_count',


I.e. Your code would look like:



$query = new WP_Query(array(
'post_type' => 'my_post_type',
'post_status' => 'publish',
'posts_per_page' => -1,
'meta_query' => array(
'relation' => 'OR',
array(
'key' => 'post_views_count',
'compare' => 'EXISTS',
),
array(
'key' => 'post_views_count',
'compare' => 'NOT EXISTS',
),
),
'orderby' => 'meta_value_num',
'order' => 'DESC',
));





share|improve this answer






























    1














    Have you already tried 'meta_query'? See Order by multiple meta key and meta value [closed]. In your case maybe like so:



    $query = new WP_Query([
    'post_type' => 'my_post_type',
    'post_status' => 'publish',
    'posts_per_page' => -1,
    'meta_query' => [
    'relation' => 'OR',
    'post_views_count' => [
    'key' => 'post_views_count',
    'compare' => 'EXISTS',
    ],
    ],
    'orderby' => [
    'post_views_count' => 'DESC',
    'title' => 'ASC',
    ],
    ]);





    share|improve this answer























      Your Answer








      StackExchange.ready(function()
      var channelOptions =
      tags: "".split(" "),
      id: "110"
      ;
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function()
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled)
      StackExchange.using("snippets", function()
      createEditor();
      );

      else
      createEditor();

      );

      function createEditor()
      StackExchange.prepareEditor(
      heartbeatType: 'answer',
      autoActivateHeartbeat: false,
      convertImagesToLinks: false,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: null,
      bindNavPrevention: true,
      postfix: "",
      imageUploader:
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      ,
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      );



      );













      draft saved

      draft discarded


















      StackExchange.ready(
      function ()
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fwordpress.stackexchange.com%2fquestions%2f333787%2fsort-in-wp-query-not-filter-is-it-possible%23new-answer', 'question_page');

      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      3














      If you want to sort the posts by the meta post_views_count, and still include posts that do not have that meta, you can use meta_query like so:



      'meta_query' => array(
      'relation' => 'OR', // make sure it's OR
      // Include posts that have the meta.
      array(
      'key' => 'post_views_count',
      'compare' => 'EXISTS',
      ),
      // Include posts that don't have the meta.
      array(
      'key' => 'post_views_count',
      'compare' => 'NOT EXISTS',
      ),
      ),


      And you can just use that in place of this:



      'meta_key' => 'post_views_count',


      I.e. Your code would look like:



      $query = new WP_Query(array(
      'post_type' => 'my_post_type',
      'post_status' => 'publish',
      'posts_per_page' => -1,
      'meta_query' => array(
      'relation' => 'OR',
      array(
      'key' => 'post_views_count',
      'compare' => 'EXISTS',
      ),
      array(
      'key' => 'post_views_count',
      'compare' => 'NOT EXISTS',
      ),
      ),
      'orderby' => 'meta_value_num',
      'order' => 'DESC',
      ));





      share|improve this answer



























        3














        If you want to sort the posts by the meta post_views_count, and still include posts that do not have that meta, you can use meta_query like so:



        'meta_query' => array(
        'relation' => 'OR', // make sure it's OR
        // Include posts that have the meta.
        array(
        'key' => 'post_views_count',
        'compare' => 'EXISTS',
        ),
        // Include posts that don't have the meta.
        array(
        'key' => 'post_views_count',
        'compare' => 'NOT EXISTS',
        ),
        ),


        And you can just use that in place of this:



        'meta_key' => 'post_views_count',


        I.e. Your code would look like:



        $query = new WP_Query(array(
        'post_type' => 'my_post_type',
        'post_status' => 'publish',
        'posts_per_page' => -1,
        'meta_query' => array(
        'relation' => 'OR',
        array(
        'key' => 'post_views_count',
        'compare' => 'EXISTS',
        ),
        array(
        'key' => 'post_views_count',
        'compare' => 'NOT EXISTS',
        ),
        ),
        'orderby' => 'meta_value_num',
        'order' => 'DESC',
        ));





        share|improve this answer

























          3












          3








          3







          If you want to sort the posts by the meta post_views_count, and still include posts that do not have that meta, you can use meta_query like so:



          'meta_query' => array(
          'relation' => 'OR', // make sure it's OR
          // Include posts that have the meta.
          array(
          'key' => 'post_views_count',
          'compare' => 'EXISTS',
          ),
          // Include posts that don't have the meta.
          array(
          'key' => 'post_views_count',
          'compare' => 'NOT EXISTS',
          ),
          ),


          And you can just use that in place of this:



          'meta_key' => 'post_views_count',


          I.e. Your code would look like:



          $query = new WP_Query(array(
          'post_type' => 'my_post_type',
          'post_status' => 'publish',
          'posts_per_page' => -1,
          'meta_query' => array(
          'relation' => 'OR',
          array(
          'key' => 'post_views_count',
          'compare' => 'EXISTS',
          ),
          array(
          'key' => 'post_views_count',
          'compare' => 'NOT EXISTS',
          ),
          ),
          'orderby' => 'meta_value_num',
          'order' => 'DESC',
          ));





          share|improve this answer













          If you want to sort the posts by the meta post_views_count, and still include posts that do not have that meta, you can use meta_query like so:



          'meta_query' => array(
          'relation' => 'OR', // make sure it's OR
          // Include posts that have the meta.
          array(
          'key' => 'post_views_count',
          'compare' => 'EXISTS',
          ),
          // Include posts that don't have the meta.
          array(
          'key' => 'post_views_count',
          'compare' => 'NOT EXISTS',
          ),
          ),


          And you can just use that in place of this:



          'meta_key' => 'post_views_count',


          I.e. Your code would look like:



          $query = new WP_Query(array(
          'post_type' => 'my_post_type',
          'post_status' => 'publish',
          'posts_per_page' => -1,
          'meta_query' => array(
          'relation' => 'OR',
          array(
          'key' => 'post_views_count',
          'compare' => 'EXISTS',
          ),
          array(
          'key' => 'post_views_count',
          'compare' => 'NOT EXISTS',
          ),
          ),
          'orderby' => 'meta_value_num',
          'order' => 'DESC',
          ));






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered 14 hours ago









          Sally CJSally CJ

          5,3562616




          5,3562616























              1














              Have you already tried 'meta_query'? See Order by multiple meta key and meta value [closed]. In your case maybe like so:



              $query = new WP_Query([
              'post_type' => 'my_post_type',
              'post_status' => 'publish',
              'posts_per_page' => -1,
              'meta_query' => [
              'relation' => 'OR',
              'post_views_count' => [
              'key' => 'post_views_count',
              'compare' => 'EXISTS',
              ],
              ],
              'orderby' => [
              'post_views_count' => 'DESC',
              'title' => 'ASC',
              ],
              ]);





              share|improve this answer



























                1














                Have you already tried 'meta_query'? See Order by multiple meta key and meta value [closed]. In your case maybe like so:



                $query = new WP_Query([
                'post_type' => 'my_post_type',
                'post_status' => 'publish',
                'posts_per_page' => -1,
                'meta_query' => [
                'relation' => 'OR',
                'post_views_count' => [
                'key' => 'post_views_count',
                'compare' => 'EXISTS',
                ],
                ],
                'orderby' => [
                'post_views_count' => 'DESC',
                'title' => 'ASC',
                ],
                ]);





                share|improve this answer

























                  1












                  1








                  1







                  Have you already tried 'meta_query'? See Order by multiple meta key and meta value [closed]. In your case maybe like so:



                  $query = new WP_Query([
                  'post_type' => 'my_post_type',
                  'post_status' => 'publish',
                  'posts_per_page' => -1,
                  'meta_query' => [
                  'relation' => 'OR',
                  'post_views_count' => [
                  'key' => 'post_views_count',
                  'compare' => 'EXISTS',
                  ],
                  ],
                  'orderby' => [
                  'post_views_count' => 'DESC',
                  'title' => 'ASC',
                  ],
                  ]);





                  share|improve this answer













                  Have you already tried 'meta_query'? See Order by multiple meta key and meta value [closed]. In your case maybe like so:



                  $query = new WP_Query([
                  'post_type' => 'my_post_type',
                  'post_status' => 'publish',
                  'posts_per_page' => -1,
                  'meta_query' => [
                  'relation' => 'OR',
                  'post_views_count' => [
                  'key' => 'post_views_count',
                  'compare' => 'EXISTS',
                  ],
                  ],
                  'orderby' => [
                  'post_views_count' => 'DESC',
                  'title' => 'ASC',
                  ],
                  ]);






                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered 14 hours ago









                  leymannxleymannx

                  73911022




                  73911022



























                      draft saved

                      draft discarded
















































                      Thanks for contributing an answer to WordPress Development Stack Exchange!


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid


                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.

                      To learn more, see our tips on writing great answers.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function ()
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fwordpress.stackexchange.com%2fquestions%2f333787%2fsort-in-wp-query-not-filter-is-it-possible%23new-answer', 'question_page');

                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      Popular posts from this blog

                      Can not update quote_id field of “quote_item” table magento 2Magento 2.1 - We can't remove the item. (Shopping Cart doesnt allow us to remove items before becomes empty)Add value for custom quote item attribute using REST apiREST API endpoint v1/carts/cartId/items always returns error messageCorrect way to save entries to databaseHow to remove all associated quote objects of a customer completelyMagento 2 - Save value from custom input field to quote_itemGet quote_item data using quote id and product id filter in Magento 2How to set additional data to quote_item table from controller in Magento 2?What is the purpose of additional_data column in quote_item table in magento2Set Custom Price to Quote item magento2 from controller

                      How to solve knockout JS error in Magento 2 Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?(Magento2) knockout.js:3012 Uncaught ReferenceError: Unable to process bindingUnable to process binding Knockout.js magento 2Cannot read property `scopeLabel` of undefined on Product Detail PageCan't get Customer Data on frontend in Magento 2Magento2 Order Summary - unable to process bindingKO templates are not loading in Magento 2.1 applicationgetting knockout js error magento 2Product grid not load -— Unable to process binding Knockout.js magento 2Product form not loaded in magento2Uncaught ReferenceError: Unable to process binding “if: function()return (isShowLegend()) ” magento 2

                      Nissan Patrol Зміст Перше покоління — 4W60 (1951-1960) | Друге покоління — 60 series (1960-1980) | Третє покоління (1980–2002) | Четверте покоління — Y60 (1987–1998) | П'яте покоління — Y61 (1997–2013) | Шосте покоління — Y62 (2010- ) | Посилання | Зноски | Навігаційне менюОфіційний український сайтТест-драйв Nissan Patrol 2010 7-го поколінняNissan PatrolКак мы тестировали Nissan Patrol 2016рвиправивши або дописавши її