I've added all the additional match results. Note that this tournament was a one-day tournament, so the date grouping/sorting isn't as important for this one. But we will have multi-day tournaments in the future, so I want to make sure to get the date field as the first grouping/sorting. All the real results on the Results page now are on May 13. Everything else was just test matches I previously entered to try to get the functionality working. I've left the test Matches in the system for purposes of your work here, but as soon as this is working perfectly, I'll be deleting all those test Matches.
Note also that I had to add one additional field called Game Number. The key field in your code should probably be wpcf-game-number for that. Can we add a final sort on that after the Session sort and Round sort? Or can you show me how/where to add that myself within the code you provided? The game numbers should appear in numerical order under all Rounds. It is already sorted that way for the most part on the Results page by virtue of the order that I created the new Matches.
hidden link
But if you scroll down on that page to May 13, 2023 Morning – 3.0 Round 2, you'll see that the display order is Game 4, Game 6, Game 5.
Looking at your code, I'm thinking that it would change to this:
add_filter('wpv_filter_query','func_sort_by_multiple_custom_fields', 199, 3);
function func_sort_by_multiple_custom_fields($query_args, $view_settings, $view_id ) {
$view_ids = array( 841 );
if( in_array( $view_id, $view_ids)) {
$query_args['meta_query'] = array(
'relation' => 'AND',
'session_clause' => array(
'key' => 'wpcf-session2',
'compare' => 'EXISTS',
),
'round_clause' => array(
'key' => 'wpcf-round',
'compare' => 'EXISTS',
),
),
'game_number_clause' => array(
'key' => 'wpcf-game-number',
'compare' => 'EXISTS',
),
);
$query_args['orderby'] = array(
'session_clause' => 'ASC',
'round_clause' => 'ASC',
'game_number_clause' => 'ASC',
);
}
return $query_args;
}
add_shortcode('heading', 'my_heading');
function my_heading($atts, $content = '') {
static $year = null;
static $month = null;
static $session = null;
static $round = null;
static $game-number = null;
$condition = $atts['condition'];;
$value = $atts['value'];;
switch ($condition) {
case 'year':
case 'month':
case 'session':
case 'round':
case 'game-number':
if ($$condition != $value) {
$$condition = $value;
return $content;
}
break;
}
return '';
}
Did I do this correctly? Or is something else needed to add that additional field sort/group?
