[Resolved] Conditional view

[Author]

Posts

[christopheV-2]

Hello,

I have 2 types: teams and products (woocommerce)
A relation between these 2 types.
I have a view where the teams are displayed.

I would like to set up a condition.
If the team has 5 or less than 5 products, it is not displayed in the view.

thank you.

[Minesh]

Hello. Thank you for contacting the Toolset support.

Before I should work around the offering the solution:
- I would like to know what is the relationship you have between the post type teams and products?
- In your view, are you using pagination or just listing the team names?

[christopheV-2]

Hello,

- Many teams and Many product (check Intermediary post type)
- With pagination (Teams ordered by post title, ascending, 99 items per page with manual pagination)

Thank you

[Minesh]

It seems we need to use View's hook here as you are using pagination.

Can you please share problem URL where you are listing your team as well as access details.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I have set the next reply to private which means only you and I have access to it.

[Minesh]

I will required FTP access details to add the hook or you can Check file permissions and wp-config.php constants DISALLOW_FILE_EDIT and DISALLOW_FILE_MODS and disable it so that I can add the file using Toolset "Custom Code" section.

I have set the next reply to private which means only you and I have access to it.

[Minesh]

Can you please check now: hidden link

I've added the following code to your current child theme's functions.php file at bottom of that file:

add_filter( 'wpv_filter_query_post_process', 'func_count_related_parent', 1001, 3 );
function func_count_related_parent( $query, $view_settings, $view_id ){
 
     
    $relationship = 'produit-equipe'; // Edit for relationship slug
	
    if ( $view_id == 2155 && !empty( $query->posts ) ){
		 
		 foreach ($query->posts as $key => $child) {
   
            // get the parent posts of the child  post
           $parents = toolset_get_related_posts(
                $child->ID,
                $relationship,
                array(
                    'query_by_role'     =>  'child',
                    'role_to_return'    =>  'parent'
                )
            );
            // getting total count
           $number_of_parents = count( $parents );

   
            if ( $number_of_parents <= 5 ) {
   
                unset( $query->posts[$key] );
                $query->found_posts = $query->found_posts - 1;
                $query->post_count = $query->post_count - 1;
            }
   
        }
   
        $query->posts = array_values( $query->posts );
         
    }
    
    return $query;
}

More info:
=> https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/#toolset_get_related_posts

I can see now its working as expected. Can you please confirm it works at your end as well.

[Minesh]

Can you please check now: hidden link

I've added the following code to your current child theme's functions.php file at bottom of that file:

add_filter( 'wpv_filter_query_post_process', 'func_count_related_parent', 1001, 3 );
function func_count_related_parent( $query, $view_settings, $view_id ){
 
     
    $relationship = 'produit-equipe'; // Edit for relationship slug
	
    if ( $view_id == 2155 && !empty( $query->posts ) ){
		 
		 foreach ($query->posts as $key => $child) {
   
            // get the parent posts of the child  post
           $parents = toolset_get_related_posts(
                $child->ID,
                $relationship,
                array(
                    'query_by_role'     =>  'child',
                    'role_to_return'    =>  'parent'
                )
            );
            // getting total count
           $number_of_parents = count( $parents );

   
            if ( $number_of_parents <= 5 ) {
   
                unset( $query->posts[$key] );
                $query->found_posts = $query->found_posts - 1;
                $query->post_count = $query->post_count - 1;
            }
   
        }
   
        $query->posts = array_values( $query->posts );
         
    }
    
    return $query;
}

More info:
=> https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/#toolset_get_related_posts

I can see now its working as expected. Can you please confirm it works at your end as well.