Reply To: Filter query by custom field and sort orderby another custom field

• juliusbangert

• December 6, 2017 at 4:42 am

Any idea why this would not be working for me? I’m going round in circles trying to figure it out, please could you tell me where I’m going wrong.

$news_archive = ( int )( get_query_var('news_archive')  === 'true' );

$news_query = new WP_Query( array(
    'post_type' => 'news',
    'post_status' => 'publish',
    'posts_per_page' => $news_archive ? 12 : 5,
    'meta_query' => array(
        'relation' => 'AND',
        array(
            'key' => 'archive',
            'value' => $news_archive,
            'compare' => '=',
        ),
        array(
            'key' => 'featured_article',
            'value' => 0,
        )
    ),
    'meta_key' => 'date', 
    'orderby' => 'meta_value_num',
    'order' => 'ASC'
));

No change in the order of my posts.

To begin with I thought that there might be restrictions on using the name date for my custom field.. but that doesn’t seem to be the case because I tested by adding a test_date field and trying it with that.

I’ve also tried changing the output format of the date picker field, but that also doesn’t seem to affect anything because in newer versions of ACF date field values are stored as YYYYMMDD in the database regardless.

Please help.