query by date

• retotito

• December 13, 2013 at 12:35 am

Hi
I just started to use this grate plugin and i wanted to query some event custom posts with the date custom field.
I created a custom field, called “event_datum”.
The date format is yymmdd.(preset from acf)
I used the code bellow to filter out the events that are gona be in the future.
Unfortunately id does not filter it out.
After some research i’m quite shure it has to be an issue of the date format.
Hope someone has an answer on that topic.
Thanks

<?php $events = new WP_Query(
array(
‘post_not_in’ => array($donotrepeat),
‘post_type’ => ‘chuchi_event’,
‘meta_key’ => ‘event_datum’,
‘orderby’ => ‘meta_value’,
‘order’ => ‘dsc’,
“posts_per_page” => 10,
‘meta_query’ => array(
‘key’ => ‘event_datum’,
‘value’ => date(“yymmdd”),
‘compare’ => ‘<=’,
‘type’ => ‘DATE’
)

)); ?>

<?php while($events->have_posts()) : $events->the_post(); ?>

• Elliot

• December 13, 2013 at 10:25 am

Hi @retotito

Thanks for the question.

I can see that your code is using the following as the meta value:

‘value’ => date(“yymmdd”),

Please note that the date field “yymmdd” is a javascript format string which differs from a PHP format string.

You can read more about this on the date field docs page, but basically all you need to do is change it to:

‘value’ => date(“Ymd”),

Thanks
E

• retotito

• December 17, 2013 at 3:29 am

Hi Elliot
Thanks for your answer.
I did try dad, but somehow it still does not filter it.
Maybe there is something else wrong with the code.

• Elliot

• December 17, 2013 at 10:38 am

Hi @retotito

Can you please debug your WP_Query $args?
What do they look like?

• retotito

• December 17, 2013 at 5:06 pm

Hi elliot.
when i use

<?php   
     var_dump($args);   
       ?> 

it gives me following information:

object(WP_Query)#2729 (47) { [“query_vars”]=> array(64) { [“post_not_in”]=> array(1) { [0]=> NULL } [“post_type”]=> string(12) “chuchi_event” [“meta_key”]=> string(11) “event_datum” [“orderby”]=> string(10) “meta_value” [“order”]=> string(4) “DESC” [“meta_query”]=> array(4) { [“key”]=> string(11) “event_datum” [“value”]=> string(8) “20131217” [“compare”]=> string(2) “<=” [“type”]=> string(4) “DATE” } [“error”]=> string(0) “” [“m”]=> string(0) “” [“p”]=> int(0) [“post_parent”]=> string(0) “” [“subpost”]=> string(0) “” [“subpost_id”]=> string(0) “” [“attachment”]=> string(0) “” [“attachment_id”]=> int(0) [“name”]=> string(0) “” [“static”]=> string(0) “” [“pagename”]=> string(0) “” [“page_id”]=> int(0) [“second”]=> string(0) “” [“minute”]=> string(0) “” [“hour”]=> string(0) “” [“day”]=> int(0) [“monthnum”]=> int(0) [“year”]=> int(0) [“w”]=> int(0) [“category_name”]=> string(0) “” [“tag”]=> string(0) “” [“cat”]=> string(0) “” [“tag_id”]=> string(0) “” [“author”]=> string(0) “” [“author_name”]=> string(0) “” [“feed”]=> string(0) “” [“tb”]=> string(0) “” [“paged”]=> int(0) [“comments_popup”]=> string(0) “” [“meta_value”]=> string(0) “” [“preview”]=> string(0) “” [“s”]=> string(0) “” [“sentence”]=> string(0) “” [“fields”]=> string(0) “” [“menu_order”]=> string(0) “” [“category__in”]=> array(0) { } [“category__not_in”]=> array(0) { } [“category__and”]=> array(0) { } [“post__in”]=> array(0) { } [“post__not_in”]=> array(0) { } [“tag__in”]=> array(0) { } [“tag__not_in”]=> array(0) { } [“tag__and”]=> array(0) { } [“tag_slug__in”]=> array(0) { } [“tag_slug__and”]=> array(0) { } [“post_parent__in”]=> array(0) { } [“post_parent__not_in”]=> array(0) { } [“author__in”]=> array(0) { } [“author__not_in”]=> array(0) { } [“ignore_sticky_posts”]=> bool(false) [“suppress_filters”]=> bool(false) [“cache_results”]=> bool(true) [“update_post_term_cache”]=> bool(true) [“update_post_meta_cache”]=> bool(true) [“posts_per_page”]=> int(10) [“nopaging”]=> bool(false) [“comments_per_page”]=> string(2) “50” [“no_found_rows”]=> bool(false) } [“tax_query”]=> object(WP_Tax_Query)#2753 (2) { [“queries”]=> array(0) { } [“relation”]=> string(3) “AND” } [“meta_query”]=> object(WP_Meta_Query)#2727 (2) { [“queries”]=> array(1) { [0]=> array(1) { [“key”]=> string(11) “event_datum” } } [“relation”]=> string(3) “AND” } [“date_query”]=> bool(false) [“post_count”]=> int(4) [“current_post”]=> int(-1) [“in_the_loop”]=> bool(false) [“comment_count”]=> int(0) [“current_comment”]=> int(-1) [“found_posts”]=> string(1) “4” [“max_num_pages”]=> float(1) [“max_num_comment_pages”]=> int(0) [“is_single”]=> bool(false) [“is_preview”]=> bool(false) [“is_page”]=> bool(false) [“is_archive”]=> bool(false) [“is_date”]=> bool(false) [“is_year”]=> bool(false) [“is_month”]=> bool(false) [“is_day”]=> bool(false) [“is_time”]=> bool(false) [“is_author”]=> bool(false) [“is_category”]=> bool(false) [“is_tag”]=> bool(false) [“is_tax”]=> bool(false) [“is_search”]=> bool(false) [“is_feed”]=> bool(false) [“is_comment_feed”]=> bool(false) [“is_trackback”]=> bool(false) [“is_home”]=> bool(true) [“is_404”]=> bool(false) [“is_comments_popup”]=> bool(false) [“is_paged”]=> bool(false) [“is_admin”]=> bool(false) [“is_attachment”]=> bool(false) [“is_singular”]=> bool(false) [“is_robots”]=> bool(false) [“is_posts_page”]=> bool(false) [“is_post_type_archive”]=> bool(false) [“query_vars_hash”]=> string(32) “77f06eaf00a501b6f2c861adfd3a0c7a” [“query_vars_changed”]=> bool(false) [“thumbnails_cached”]=> bool(false) [“stopwords”:”WP_Query”:private]=> NULL [“query”]=> array(6) { [“post_not_in”]=> array(1) { [0]=> NULL } [“post_type”]=> string(12) “chuchi_event” [“meta_key”]=> string(11) “event_datum” [“orderby”]=> string(10) “meta_value” [“order”]=> string(3) “dsc” [“meta_query”]=> array(4) { [“key”]=> string(11) “event_datum” [“value”]=> string(8) “20131217” [“compare”]=> string(2) “<=” [“type”]=> string(4) “DATE” } } [“request”]=> string(355) “SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id) WHERE 1=1 AND wp_posts.post_type = ‘chuchi_event’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘closed’) AND (wp_postmeta.meta_key = ‘event_datum’ ) GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value DESC LIMIT 0, 10” [“posts”]=> array(4) { [0]=> object(WP_Post)#2763 (24) { [“ID”]=> int(137) [“post_author”]=> string(1) “1” [“post_date”]=> string(19) “2013-12-14 03:10:48” [“post_date_gmt”]=> string(19) “2013-12-14 03:10:48” [“post_content”]=> string(1781) “Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonu ……..

• Elliot

• December 18, 2013 at 10:02 am

Hi @retotito

Instead of debugging the WP_Query object, can you please debug just the $args like so:

<?php 

$args = array(
	'post_not_in' => array($donotrepeat),
	'post_type' => 'chuchi_event',
	'meta_key' => 'event_datum',
	'orderby' => 'meta_value',
	'order' => 'dsc',
	'posts_per_page' => 10,
	'meta_query' => array(
		'key' => 'event_datum',
		'value' => date('yymmdd'),
		'compare' => '<=',
		'type' => 'DATE'
	)
);

echo '<pre>';
	print_r( $args );
echo '</pre>';
die;

$events = new WP_Query($args);

	
?>

P.S. Please wrap all code in the code buttons
Thanks
E

• retotito

• December 18, 2013 at 4:50 pm

Hi Elliot

That’s the code i used:

<?php $args = 
     			array(
     				'post_not_in'    => array($donotrepeat),
                                'post_type'       => 'chuchi_event',
     				'meta_key'        => 'event_datum',
     				'orderby'        => 'meta_value',
     				'order'           => 'dsc',
            'meta_query'  => array(         
                  'key'     => 'event_datum',  
                  'value'   => date("Ymd"),  
                  'compare' => '<=',          
                  'type'    => 'DATE'         
                                  )     					           
     			      ); 
        
          echo '<pre>';
	        print_r( $args );
          echo '</pre>';
          die;
     
        $events = new WP_Query($args);
     
        ?>

That’s the output:

Array
(
    [post_not_in] => Array
        (
            [0] => 
        )

    [post_type] => chuchi_event
    [meta_key] => event_datum
    [orderby] => meta_value
    [order] => dsc
    [meta_query] => Array
        (
            [key] => event_datum
            [value] => 20131218
            [compare] => <=
            [type] => DATE
        )

)

I hope it’s what you are looking for.
Thanks

• Elliot

• December 18, 2013 at 5:52 pm

Hi @retotito

The issue could be caused by the ‘post_not_in’ argument. Can you remove that as it is not doing anything at the moment.

Also, can you remove the type => ‘DATE’ as this is not neccessary.

Can you then confirm that your date field has a save_format setting of ‘yymmdd’? Please also update a few of your posts to ensure that the vaue is saved in the correct format.

Thanks
E

• retotito

• December 18, 2013 at 8:33 pm

Hi Elliot.
Thanks for your help.

I Tryed all of that:
removed the ‘post_not_in’ argument.
removed the type => ‘DATE’
the save_format setting is ‘yymmdd’
i updated the post and added some new one’s
i deactivated plugins

but unfortunately it still doesn’t filter.

By the way the order by date works fine.

I might try to redo the same situation with another wp theme, maybe thats where the issue commes from.

• Elliot

• December 19, 2013 at 9:51 am

Hi @retotito

It is possible that there is a filter in your theme or a plugin which is modifying the WP_Query args. This filter is most likely called ‘pre_get_posts’.

Perhaps as a test, create a simple text field and enter the value ‘test’. Then change your query args to find posts where the field_name = ‘test’.

Does this work?

Thanks
E

• retotito

• December 20, 2013 at 2:21 am

Hi Elliot

That works fine.
I tested with following code:

<?php $args = new WP_Query(
     			array(
            'post_type' => 'testpost',
            'meta_key' => 'testpost_testtext', 
	    'meta_value' => 'test', 
          
          ));     
     			?>

Do you suggest to ask the theme-support about that issue?
I’m using the “enfold” theme.

• Elliot

• December 22, 2013 at 7:04 pm

Hi @retotito

Personally, I would search through your theme’s code before contacting the developers. But sure, they will be able to help.

Start with the functions.php file.

Thanks
E

• retotito

• December 24, 2013 at 5:03 am

Hi Elliot
Thanks first for the outstanding support.
I’m going to check that out soon and let you know.

For the meantime i got a workaround with an if statement. That might not be the most beautiful solution, but it works temporarely:

`<?php $args = new WP_Query(
array(
‘post_type’ => ‘chuchi_event’,
‘meta_key’ => ‘event_datum’,
‘orderby’ => ‘meta_value’,
‘order’ => ‘dsc’,
‘posts_per_page’ => 50,

)); ?>

<?php while($args->have_posts()) : $args->the_post(); ?>

<?php
$datex = strtotime(date_format(date_create(”.get_field(‘event_datum’).”),’d-m-Y’));
$now = time();
?>

<?php
if($now <= ($datex+(60*60*24))){
?>
<div>
</div>
<?php
}
?>

<?php endwhile; ?>