Chatgpt says this should work. But it doesn’t. It shows nothing.
//
add_filter( ‘kadence_blocks_pro_query_loop_query_vars’, function( $query, $ql_query_meta, $ql_id ) {
if ( $ql_id == 123 ) {
$query[‘post_type’] = ‘sp_event’; // Ensure it’s querying SportsPress events
$query[‘post_status’] = array( ‘publish’, ‘future’ ); // Include scheduled events
$query[‘meta_query’] = array(
array(
‘key’ => ‘_sp_date’, // Adjust if necessary
‘value’ => date(‘Y-m-d H:i:s’),
‘compare’ => ‘>=’,
‘type’ => ‘DATETIME’,
)
);
$query[‘orderby’] = ‘meta_value’;
$query[‘meta_key’] = ‘_sp_date’;
$query[‘order’] = ‘ASC’;
}
return $query;
}, 10, 3 );
//
This works(change $ql_id):
add_filter( ‘kadence_blocks_pro_query_loop_query_vars’, function( $query, $ql_query_meta, $ql_id ) {
if ( $ql_id == 123 ) {
$query[‘post_type’] = ‘sp_event’;
$query[‘post_status’] = array( ‘publish’, ‘future’ ); // Include scheduled games
$query['date_query'] = array(
array(
'after' => date('Y-m-d H:i:s'), // Only show future games
'inclusive' => true,
),
);
$query['orderby'] = 'post_date'; // Order by scheduled event date
$query['order'] = 'ASC'; // Show earliest upcoming games first
}
return $query;
}, 10, 3 );
