wp_query ordered by custom field value

  • Ale Urrutia

    (@alectro)


    13 years, 4 months ago

    Hi everyone, I am using in my portfolio the following wp_query:

    <?php $loop = new WP_Query( array( 'post_type' => 'work', 'posts_per_page' => 999, 'order' => DESC ) ); while ( $loop->have_posts() ) : $loop->the_post(); ?>

.....

    And it’s working perfectly, what I want is to order by “Year” Custom Field Value, of course is a numeric value such as: 2001, 2007 or 2010.

    How can I do it?

    Thanks in advance!
    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)
  • jamespiggot

    (@jamespiggot)

    13 years, 4 months ago

    Have you tried using orderby=meta_value together with metakey=year

    This will be a alpha rather than numeric sort but with your data values of just year it should work correctly.

    There is some documentation for this in the Codex under query_posts which explains somewhat what is required.

    Thread Starter Ale Urrutia

    (@alectro)

    13 years, 4 months ago

    Hi James,

    Thanks for replying and for enlighten the way to find the solution.
    Here’s the resulting code for anyone who wants to use it:

    <?php $loop = new WP_Query( array( 'post_type' => 'work', 'posts_per_page' => 999, 'meta_key'=>'year',  'orderby' => 'meta_value_num', 'order' => DESC ) ); while ( $loop->have_posts() ) : $loop->the_post(); ?>
...

    Regards.

    ixwa

    (@ixwa)

    12 years, 9 months ago

    Hmm, meta_value_num didn’t work for me but meta_value did. Just be sure that orderby is on the same level as post_type etc.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘wp_query ordered by custom field value’ is closed to new replies.