Query to only show posts which are connected - Support Fourms

This topic has 3 replies, 2 voices, and was last updated 1 year ago by Max@powdersky.com.

Creator

Topic

January 16, 2019 at 8:23 PM #13035

Resolved

Max@powdersky.com

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

Creator

Topic

Viewing 3 replies - 1 through 3 (of 3 total)

Author

Replies
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

Max@powdersky.com
Participant

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

June 25, 2019 at 10:55 PM #15092

Max@powdersky.com
Participant

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

Replies

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.