Build query for future events

  • Resolved adatfalo

    (@adatfalo)


    5 years, 1 month ago

    Hi!

    I use Oxygen Builder, and I would like to build a query parameter, everything working well except the scope=future section. Could you help me with it?

    <?php
    $data = array(
    'post_type' => 'event',
    'post_per_page' => '-1',
    'meta_key' => '_event_start_date',
    'orderby' => 'meta_value',
    'order' => 'ASC'
    'no_found_rows' => 'true'
    'scope' => 'future'
     )
  )
);
    echo build_query( $data );
?>

    This query URL parameter works well: post_type=event&posts_per_page=-1&meta_key=_event_start_date&orderby=meta_value&order=ASC&no_found_rows=true How could I add the only future post parameter?

    Thanks

Viewing 1 replies (of 1 total)
  • Plugin Support angelo_nwl

    (@angelo_nwl)

    this might not work out of the box but maybe the snippet below can help you get started

    
function my_em_wp_query(){
	$args = array(
		'post_type' => 'event',
		'posts_per_page' => 100,
		'meta_query' => array( 'key' => '_start_ts', 'value' => current_time('timestamp'), 'compare' => '>=', 'type'=>'numeric' ),
		'orderby' => 'meta_value_num',
		'order' => 'ASC',
		'meta_key' => '_start_ts',
		'meta_value' => current_time('timestamp'),
		'meta_value_num' => current_time('timestamp'),
		'meta_compare' => '>='
	);

	// The Query
	$query = new WP_Query( $args );

	// The Loop
	while($query->have_posts()):
	$query->next_post();
	$id = $query->post->ID;
	echo '<li>';
	echo get_the_title($id);
	echo ' - '. get_post_meta($id, '_event_start_date', true);
	echo '</li>';
	endwhile;

	// Reset Post Data
	wp_reset_postdata();
}
add_shortcode('em_wp_query','my_em_wp_query');
Viewing 1 replies (of 1 total)
  • The topic ‘Build query for future events’ is closed to new replies.