wp query - ACF Date Based wp_query

admin管理员组

文章数量:1334183

I've been trying to order these exhibitions based on the end_date custom field created with Advanced Custom Fields. I'm not able to properly get this working. I need the most recent dates first. I need to also only get posts with the exhibition_status of past. For the life of me I can't get this working and the below code is just the latest non working interation.

$args = array (
    'post_type'         => 'exhibitions',
    'meta_query'        => array(
        'relation'      => 'OR',
            'query_one'     => array(
                'key'       => 'exhibition_status',
                'value'     => 'past',
            ),
            'query_two'     => array(
                'key'       => 'end_date',
                'compare'   => '>=',
            ), 
    ),
    'orderby'                => 'end_date',
    'order'                  => 'ASC',
    'post_status' => 'publish',
    'posts_per_page' => 10,
    'paged' => get_query_var( 'paged' ),
);

The date is based on this format F j, Y

How do I get all posts ordered by the ACF field end_date and only get posts where the ACF field exhibition_status equals past?

I've been trying to order these exhibitions based on the end_date custom field created with Advanced Custom Fields. I'm not able to properly get this working. I need the most recent dates first. I need to also only get posts with the exhibition_status of past. For the life of me I can't get this working and the below code is just the latest non working interation.

$args = array (
    'post_type'         => 'exhibitions',
    'meta_query'        => array(
        'relation'      => 'OR',
            'query_one'     => array(
                'key'       => 'exhibition_status',
                'value'     => 'past',
            ),
            'query_two'     => array(
                'key'       => 'end_date',
                'compare'   => '>=',
            ), 
    ),
    'orderby'                => 'end_date',
    'order'                  => 'ASC',
    'post_status' => 'publish',
    'posts_per_page' => 10,
    'paged' => get_query_var( 'paged' ),
);

The date is based on this format F j, Y

How do I get all posts ordered by the ACF field end_date and only get posts where the ACF field exhibition_status equals past?

• wp-query
• advanced-custom-fields
• meta-query

Share Improve this question edited Jul 2, 2020 at 17:14 Sabbir Hasan 1,40911 gold badge99 silver badges1414 bronze badges asked Jul 2, 2020 at 15:58 smack-a-brosmack-a-bro 11366 bronze badges 4

• Ordeby can not be a unknown field. You need to add another parameter 'meta_key' => 'end_date' and set the 'order_by' => 'meta_value'. – Shazzad Commented Jul 2, 2020 at 16:37
• Unfortunetly, that has no effect on the end results. – smack-a-bro Commented Jul 2, 2020 at 16:53
• Also the 'relation' => 'OR' should be 'relation' => 'AND' – Shazzad Commented Jul 2, 2020 at 16:54
• Still the same. I don't get it. Its seems to be kind of sorting them but early dates are still showing before more recent dates in some case.... – smack-a-bro Commented Jul 2, 2020 at 17:04

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

I've modified your existing code.Can you please try the code bellow:

$args = array (
    'post_type' => 'exhibitions',
    'meta_query'=> array(
        'relation'      => 'AND',
        array(
            'key'       => 'exhibition_status',
            'value'     => 'past',
        ),
        array(
            'key'       => 'end_date',
            'compare'   => 'EXISTS',
            'type'      => 'DATE'
        ), 
    ),
    'meta_key'    => 'end_date',
    'orderby'     => 'meta_value',
    'order'       => 'ASC',
    'post_status' => 'publish',
    'posts_per_page' => 10,
    'paged' => get_query_var( 'paged' ),
);

本文标签： wp queryACF Date Based wpquery