I’m trying to build a festival website that has multiple events each year. Each event can occur more than once within each year.
I have a post type called Events with a repeater field for Event times. In the repeater field there are two sub-fields, one for Start time and one for End time.
I’m trying to display a chronological list of all the Events based on their Event times and have the following code (taken from https://www.advancedcustomfields.com/resources/query-posts-custom-fields):
<?php
// filter
function my_posts_where( $where ) {
$where = str_replace("meta_key = 'event_time_%", "meta_key LIKE 'event_time_%", $where);
return $where;
}
add_filter('posts_where', 'my_posts_where');
// set festival year in YYYY
$date = $festival_year;
// args
$args = array(
'numberposts' => -1,
'post_type' => 'event',
'meta_query' => array(
'key' => 'event_time_%_start_time',
'compare' => 'LIKE',
'value' => $date
)
);
// query
$the_query = new WP_Query( $args );
?>
<?php if( $the_query->have_posts() ): ?>
<ul>
<?php while ( $the_query->have_posts() ) : $the_query->the_post(); ?>
<li>
<a href="<?php the_permalink(); ?>"><?php the_title(); ?> - <?php the_sub_field('start_time'); ?></a>
</li>
<?php endwhile; ?>
</ul>
<?php endif; ?>
<?php wp_reset_query(); // Restore global post data stomped by the_post(). ?>
This successfully finds all the Events that have Start times in the $festival_year. The problem I am having is that I can’t get the code to show the_sub_field('start_time') for each Event. I would also expect to see some of these Events duplicated as two of them have two Event times fields, both in the same year.
I am essentially trying to query all sub_field data first and then connect the associated post data (title, content, etc). Then I can output it as a calendar.
Is this possible?
