It can be done using nested view but in your case I think using shortcode will make more sense.
And we will use the Legacy view as Legacy view will offer you more control over table design rather using blocks. To enable the legacy view, please follow the following Doc:
- https://toolset.com/course-lesson/enabling-legacy-version-of-toolset-views/
Here is the sandbox site where I tried to setup a demo and you can auto-login to it using the following link:
- hidden link
I've setup post types:
- hidden link
And custom fields as you mentioned in your previous post:
- hidden link
As you can see I've setup few entries for both post types with required field:
- hidden link
- hidden link
I've created the following view:
- hidden link
Where:
- I've called the shortcode added to "Custom Code" section as given under:
<td align="center">[show_related_post_info relationship='related-club' type='count']</td>
-- To display related post count
<td>[show_related_post_info relationship='related-club' type='field-sum' field='game-duration']</td>
-- To display sum duration
<td>[show_related_post_info relationship='related-club' type='field-average' field='no-of-players']</td>
-- To display average player
Where:
- replace relationship shortcode attribute value with your original post reference field slug. In this case for this sandbox site its "related-club".
Added the following Code to "Custom Code" section offered by Toolset:
=> hidden link
add_shortcode('show_related_post_info', 'func_show_related_post_info');
function func_show_related_post_info($atts) {
global $post;
$field_sum = $field_avg = 0;
$relationship = $atts['relationship'];
$type = $atts['type'];
$field = 'wpcf-'.$atts['field'];
$child_posts = toolset_get_related_posts($post->ID,
$relationship,
'parent',999,
0,array(),
'post_id',
'child');
$total_count = count($child_posts);
if(isset($relationship) and $type=='count') {
return $total_count;
}else if(!empty($child_posts)) {
foreach($child_posts as $k=>$v):
$field_sum = $field_sum + get_post_meta($v,$field,true);
endforeach;
if(isset($relationship) and $type=='field-sum') {
return $field_sum;
}else if(isset($relationship) and $type=='field-average') {
return $field_sum/$total_count;
}
}
return 0;
}
On the following page - I've added the view as given under:
- hidden link
[wpv-view name="show-all-jeu-post-in-table" cached="off"]
If you can see on the the frontend for the above page here is the view result:
- hidden link
More info:
- https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/#toolset_get_related_posts
- https://toolset.com/documentation/programmer-reference/adding-custom-code/using-toolset-to-add-custom-code/#adding-custom-php-code-using-toolset
- https://toolset.com/documentation/programmer-reference/adding-custom-code/how-to-create-a-custom-shortcode/
