Ajax Load More with nested meta_query

Thanks so much for getting back to me. I’m not sure what you’ve created here quite does what I’m trying to though. I think I confused things by including a previous example which uses different keys.

So – forget the event_date key. Here we are using a combination of start_date and end_date.

If you look again at the initial block of code in my first post, you see that there are TWO variables: the two dates which make up the BETWEEN operator and the two possible keys to pass through that operator.

The process that first query creates is:

1. Find posts of type event.
2. Check if post has an end_date value. If so, use it as the key.
3. If post no end_date value use the start_date value (there is always a start_date value).
4. Compare the key to the meta value (using BETWEEN on the date range as in your shortcode).
5. Include post IF the key (which, from post to post, could be either end_date or start_date) falls between the meta values.

Your shortcode creates the date range in which the key needs to fall, but it uses one key – event_date – whereas I need it to check for end_date before using start_date.

I hope that is clearer – apologies for the second bit of code in my original post, which I suspect has made this confusing.

Thanks.

• This reply was modified 5 years, 7 months ago by mtm.
• This reply was modified 5 years, 7 months ago by mtm. Reason: Corrections and formatting to improve clarity

Oh this looks very promising. I had a go but so far no dice – you can see what’s happening at the staging site.

Here’s what I’ve added to the functions.php file:

// ALM Shortcode
// [ajax_load_more id="past_event_listing" posts_per_page="8" offset="8" button_label="Show More"]
// 'past_event_listing' is the value of the 'id' parameter in the shortcode.

date_default_timezone_set('Europe/London'); 
$alm_date_1 = date('Ymd', strtotime("-999 months"));
$alm_date_2 = date('Ymd', strtotime("now"));

$alm_past_args = array(
 'post_type'			=> 'event',
 'meta_query'		=> array(
  'relation'	=> 'OR',
// check to see if end date has been set
  array(
   'key' => 'end_date',
   'compare' => 'BETWEEN',
   'type' => 'DATE',
   'value' => array($alm_date_1, $alm_date_2),
  ),
 // if no end date has been set use event/start date
  array(
   'key' => 'start_date',
   'compare' => 'BETWEEN',
   'type' => 'DATE',
   'value' => array($alm_date_1, $alm_date_2),
  )
 ),
 'orderby' => 'meta_value_num',
 'order' => 'DESC',
);
return $alm_past_args;

}
add_filter( 'alm_query_args_past_event_listing', 'my_past_event_listing', 10, 2);

Here’s my shortcode:

[ajax_load_more id="past_event_listing" posts_per_page="8" offset="8" button_label="Show More"]

And here’s what the ALM container returns in the inspector:

<ul aria-live="polite" aria-atomic="true" class="alm-listing alm-ajax eventlist nopad nostyle" data-container-type="ul" data-repeater="default" data-post-type="post" data-order="DESC" data-orderby="date" data-offset="8" data-posts-per-page="8" data-scroll="true" data-scroll-distance="100" data-max-pages="0" data-pause-override="false" data-pause="false" data-button-label="Show More"></ul>

Any idea why it appears to be returning nothing? The same query in a template works, and there should be a further 15 events to list here.

Thanks.