Sort in WP_Query(), not filter? Is it possible? The 2019 Stack Overflow Developer Survey Results Are In2019 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

Is bread bad for ducks?

Return to UK after being refused entry years previously

What is the meaning of the verb "bear" in this context?

Pokemon Turn Based battle (Python)

Resizing object distorts it (Illustrator CC 2018)

What is the closest word meaning "respect for time / mindful"

What to do when moving next to a bird sanctuary with a loosely-domesticated cat?

Have you ever entered Singapore using a different passport or name?

What is the motivation for a law requiring 2 parties to consent for recording a conversation

Identify boardgame from Big movie

Why not take a picture of a closer black hole?

Aging parents with no investments

What does ひと匙 mean in this manga and has it been used colloquially?

Is this app Icon Browser Safe/Legit?

Does a dangling wire really electrocute me if I'm standing in water?

Protecting Dualbooting Windows from dangerous code (like rm -rf)

What could be the right powersource for 15 seconds lifespan disposable giant chainsaw?

Why can Shazam fly?

Where to refill my bottle in India?

How to notate time signature switching consistently every measure

Shouldn't "much" here be used instead of "more"?

Right tool to dig six foot holes?

How technical should a Scrum Master be to effectively remove impediments?

Can a rogue use sneak attack with weapons that have the thrown property even if they are not thrown?



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



The 2019 Stack Overflow Developer Survey Results Are In
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
    2 days 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
    2 days 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
    2 days 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
    2 days 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 2 days ago









LubWnLubWn

154




154







  • 1





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

    – mrben522
    2 days 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
    2 days ago












  • 1





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

    – mrben522
    2 days 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
    2 days ago







1




1





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

– mrben522
2 days ago





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

– mrben522
2 days 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
2 days 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
2 days 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 2 days ago









          Sally CJSally CJ

          5,3662616




          5,3662616























              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 2 days ago









                  leymannxleymannx

                  85211122




                  85211122



























                      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







                      -sort, wp-query

                      Popular posts from this blog

                      Frič See also Navigation menuinternal link

                      Identify plant with long narrow paired leaves and reddish stems Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?What is this plant with long sharp leaves? Is it a weed?What is this 3ft high, stalky plant, with mid sized narrow leaves?What is this young shrub with opposite ovate, crenate leaves and reddish stems?What is this plant with large broad serrated leaves?Identify this upright branching weed with long leaves and reddish stemsPlease help me identify this bulbous plant with long, broad leaves and white flowersWhat is this small annual with narrow gray/green leaves and rust colored daisy-type flowers?What is this chilli plant?Does anyone know what type of chilli plant this is?Help identify this plant

                      fontconfig warning: “/etc/fonts/fonts.conf”, line 100: unknown “element blank” The 2019 Stack Overflow Developer Survey Results Are In“tar: unrecognized option --warning” during 'apt-get install'How to fix Fontconfig errorHow do I figure out which font file is chosen for a system generic font alias?Why are some apt-get-installed fonts being ignored by fc-list, xfontsel, etc?Reload settings in /etc/fonts/conf.dTaking 30 seconds longer to boot after upgrade from jessie to stretchHow to match multiple font names with a single <match> element?Adding a custom font to fontconfigRemoving fonts from fontconfig <match> resultsBroken fonts after upgrading Firefox ESR to latest Firefox