I am trying to get posts in Ascending order using WP_Query,

$args  = array(
    'date_query' => array(
        array(
            'year' => $ppy,
            'orderby' => 'post_date',
            'order' => 'ASC',
        ),
    ),
);
$query = new WP_Query( $args );

But I am getting posts in descending order, I var_dumped the query and noticed that order is still DESC,

[request] => SELECT SQL_CALC_FOUND_ROWS wpqk_posts.ID FROM wpqk_posts WHERE 1=1 AND ( YEAR( wpqk_posts.post_date ) = 2017 ) AND wpqk_posts.post_type = 'post' AND ( wpqk_posts.post_status = 'publish' OR wpqk_posts.post_status = 'acf-disabled' OR wpqk_posts.post_status = 'private' ) ORDER BY wpqk_posts.post_date DESC LIMIT 0, 10

I am trying to get posts in Ascending order using WP_Query,

$args  = array(
    'date_query' => array(
        array(
            'year' => $ppy,
            'orderby' => 'post_date',
            'order' => 'ASC',
        ),
    ),
);
$query = new WP_Query( $args );

But I am getting posts in descending order, I var_dumped the query and noticed that order is still DESC,

[request] => SELECT SQL_CALC_FOUND_ROWS wpqk_posts.ID FROM wpqk_posts WHERE 1=1 AND ( YEAR( wpqk_posts.post_date ) = 2017 ) AND wpqk_posts.post_type = 'post' AND ( wpqk_posts.post_status = 'publish' OR wpqk_posts.post_status = 'acf-disabled' OR wpqk_posts.post_status = 'private' ) ORDER BY wpqk_posts.post_date DESC LIMIT 0, 10

• wp-query
• order
• date

Share Improve this question edited May 25, 2019 at 21:01 admcfajn 1,32622 gold badges1313 silver badges3030 bronze badges asked Jul 4, 2017 at 22:04 Abdul WaheedAbdul Waheed 1311 silver badge33 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

You've made "orderby" and "order" part of the date_query sub-array. "Order" parameters belong to the main parameters array.

I can't vouch for the part of your code that concerns the year and the above-undefined variable $ppy, but if you want the posts from a specified year in ascending order by 'post_date' (which is the default), you'd try:

$args = array( 
        'date_query' => array(
                     'year' => $ppy,
         ),
         'order'   => 'ASC',
);

You can leave off 'post_date', since it's the default, but it doesn't hurt to specify if you've got a lot else going on that may potentially change the query.