Querying Multiple Post Types

• kevinreilly

• November 26, 2013 at 4:47 am

Hi I’m trying to construct a query to display a single post that matches the following criteria:

post_type = ‘friday’ OR ‘saturday’ OR ‘sunday’
AND
custom_text_field = ‘right’
AND
custom_date_field_1 < current_date < custom_date_field_2

I was able to get the OR relationship working for custom fields but I can’t seem to get it to work for post types. Also, if there is a way to just avoid specifying post types and just querying all posts of any type, that might work out better for me. Any ideas? Thanks.

• Elliot

• November 26, 2013 at 11:12 am

Hi @kevinreilly

All the WP_Query args are well documented on the WP website. I will have to refer you for your questions regarding post_type as they are not related to ACF.

Perhaps you can post back your actual $args for the WP_Query object and I can help you fix any issues regarding the meta_query args?

Thanks
E

• kevinreilly

• December 13, 2013 at 2:46 am

Here is my current code. I’ve resolved the issue of querying multiple post types but now I need to only get posts that have:
date_picker_value1 <= current_date <= date_picker_value2

$args = array (
    'post_type' => array('friday','saturday','sunday','special'),
    'meta_query' => array(
	array(
	    'key' => 'publish_area',
	    'value'     => 'left',
	),
    ),
);

• Elliot

• December 13, 2013 at 10:47 am

Hi @kevinreilly

As long as your date field is saved with the default format (JS format = yymmdd), then you can compare the values like so:

<?php 

$today = date('Ymd');

$args = array (
    'post_type' => array('friday','saturday','sunday','special'),
    'meta_query' => array(
		array(
		    'key' 	=> 'publish_area',
		    'value'	=> 'left',
		),
		array(
	        'key'		=> 'start_date',
	        'compare'	=> '<=',
	        'value'		=> $today,
	    ),
	     array(
	        'key'		=> 'end_date',
	        'compare'	=> '>=',
	        'value'		=> $today,
	    )
    ),
);

?>

Please note this code is untested, but should explain how to do it!

Thanks
E