[Resolved] View only query posts that have children

[Author]

Posts

[bobA-2]

Say I have a Post type called Movies and Post type called Showings with a One To Many relationship.

I make a view and in the loop section I call a nested view which has showing information for relationship current post in the loop.

But what if I some movies does not have showings data yet and I want to see only Movies that have. So basically I only want to query Movie posts that actually have children posts (Showings). How do I do that? I found old post about this I think with the code below. But I guess that is for old Views relationship and will not work with the new right?

add_filter('wpv_filter_query', 'parent_has_childs_func', 101, 3);
 
function parent_has_childs_func($query, $view_settings, $view_id) {
if ( $view_id == 'ID OF THE VIEW' ) {
  global $wpdb;
  $ids = $wpdb->get_results( "SELECT meta_value FROM wp_postmeta WHERE meta_key = '_wpcf_belongs_city_id'" );
  $query['post__in'] = array($ids);
}
return $query;
}

[Christian Cox]

Hi, you are correct that this code should be used with legacy post relationships only. For migrated or new relationships, you should use the new post relationships API to determine which parent posts have no children, and exclude those parent posts from the query with post__not_in. I helped on another ticket that does something similar:
https://toolset.com/forums/topic/table-with-child-posts

You'll edit the View ID to be the ID of the View that shows parent posts, you'll edit the relationship slug, and you'll change the parent post type slug to match your site's content. You can also change the function name (in both places) if you'd like. Then add this code to your child theme's functions.php file, or to a new custom code snippet in Toolset > Settings > Custom code:

add_filter('wpv_filter_query', 'jobs_with_bewerbungs_func', 101, 3);
function jobs_with_bewerbungs_func($query, $view_settings, $view_id) {
  $views = array( 84 );
  $relationship_slug = 'job-bewerbung-multis';
  $parent_type_slug = 'job';
  // you should not edit anything below this line
  if ( in_array( $view_id, $views ) ) {
    $ids = array();
    $parents_args = array(
      'post_type' => $parent_type_slug,
      'numberposts' => -1,
    );
    $parents = get_posts( $parents_args );
    foreach($parents as $parent) {
      $children = toolset_get_related_posts(
        $parent->ID,
        $relationship_slug,
        'parent',
        1000000,
        0,
        array(),
        'post_id',
        'child'
      );
      if( !is_array($children) || count($children) < 1 ) {
        array_push( $ids, $parent->ID );
      }
    }
    $query['post__not_in'] = isset($query['post__not_in']) ? $query['post__not_in'] : array();
    $query['post__not_in'] = array_merge($query['post__not_in'], $ids );
  }
  return $query;
}

[bobA-2]

My issue is resolved now. Thank you!