Query to only show posts which are connected

This topic has 3 replies, 2 voices, and was last updated 5 years, 5 months ago by [email protected].

Viewing 4 posts - 1 through 4 (of 4 total)

Author

Posts

January 16, 2019 at 8:23 PM #13035

[email protected]

Participant

Hi,

I want to only show a specific custom post type (resort) if it has a connected CPT (Accommoation)

                 $resort_args = array(
                   'post_type' => 'resort',
                   'posts_per_page' => -1,
                   'tax_query' => array(
                     array(
                       'taxonomy' => '_resort_country',
                       'field'    => 'id',
                       'terms'    => $country->term_id
                     ),
                   ),
                   'relationship' => array(
                        'id' => 'accommodation_to_resorts',
                        'compare' => 'EXSISTS',
                        //This is an example not working
                    ),
                 );

  MB_Relationships_API::register( array(
        'id'   => 'accommodation_to_resorts',
        'from'   => array(
                    'object_type' => 'post',
                    'post_type'   => 'resort',
                    'meta_box'    => array(
                        'hidden'         => 'true',
                    ),
                ),
                'to'   => array(
                    'object_type' => 'post',
                    'post_type'   => 'accommodation',
                    'meta_box'    => array(
                        'title'         => 'Resort',
                        'context'       => 'side',
                        'empty_message' => 'No resorts.',
                    ),
                ),

Thanks in advanced

January 17, 2019 at 10:19 AM #13040

Anh Tran

Keymaster

Hi Max,

Querying posts using relationship as a condition is not supported. You might want to query posts as usual, then perform an API call to get connected items for each post. Then you can use condition to decide whether to show them.

MB_Relationships_API::each_connected( array(
    'id'   => 'posts_to_pages',
    'from' => $wp_query->posts, // 'from' or 'to'.
) );

while ( have_posts() ) : the_post();
    // Skip if no connected posts.
    if ( empty( $post->connected ) ) {
        continue;
    }

    // Output here
endwhile;

January 17, 2019 at 11:48 PM #13048

[email protected]

Participant

Perfect thanks Anh, will give it a go and let you know the outcome.

June 25, 2019 at 10:55 PM #15092

[email protected]

Participant

OK sorry just managed to get on to this, that all worked just need to make sure to include global $post; ! 🙂

Author

Posts

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.