[Resolved] Filter to show only posts that have related posts assigned.

[Author]

Posts

[SteBlood]

Hello,

I have two CPT;

Parks
Properties

This is a one to many relationship where there are multiple properties to a park.

I have my archive page which shows all parks, but now I would like to create another search page (view) that shows only parks that have properies assigned to them.

Could you help me with a solution to this please?

Many Thanks

Steve

[Waqar]

Hi Steve,

Thank you for contacting us and I'd be happy to assist.

To exclude the 'Properties' posts from a view, which are not related to any parent "Parks" post, you can use the "wpv_filter_query" filter:
https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query

For example, suppose your view's ID is "12345", the slug of the property post type is "property" and the slug of the relationship is "park-property".

The code for this exclusion will look like this:

add_filter( 'wpv_filter_query', 'filter_no_parent_park_posts_fn', 1000 , 3 );
function filter_no_parent_park_posts_fn( $query_args, $view_settings ) {
	if ( ( isset($view_settings['view_id']) && $view_settings['view_id'] == 48) ) {
		// change these values, as per your website
		$target_post_type = "property";
		$relationship_slug = "park-property";

		// cycle through all target posts
		$args = array(
			'posts_per_page'   => -1,
			'post_type'        => $target_post_type,
			'post_status'      => 'publish',
		);
		$posts_array = get_posts( $args );

		// check if the parent post exists and if not remove the target post from the view's results
		foreach ($posts_array as $post_array ) {
			$get_results = toolset_get_related_posts( $post_array -> ID, $relationship_slug, 'child', 999999, 0, array(), 'post_id', 'parent' );
			if(empty($get_results)) {
				$query_args['post__not_in'][] = $post_array -> ID;
			}
		}
	}
	return $query_args;
}

The above code snippet can be included through either Toolset's custom code feature ( ref: https://toolset.com/documentation/adding-custom-code/using-toolset-to-add-custom-code/ ) or through the active theme's "functions.php" file.

I hope this helps and please let me know if you need any further assistance around this.

regards,
Waqar

[SteBlood]

Hi Waqar, thank you kindly for this, do I need to change the View ID to the ID of the view I will be using?

Steve

[Waqar]

Thanks for writing back.

Yes, you'll replace the following items in the code snippet to match your website:

- '12345': with the actual ID of your view
- 'property': with the actual slug of your property post type
- 'park-property': with the actual slug of your relationship between the park and the property post type

[SteBlood]

Hi Waqar,

So after testing thoroughly and nearly writing a long ass post here about how it isn't working the way I wanted, I sat and read your code. Which is great btw!

So what I noticed was it was working correctly, however the opposite way to what I wanted, so I changed the 'parent' and 'child' around then changed the slug from properties to park and viola! it works!

Thanks Waqar! I can now continue with my work 🙂

[SteBlood]

Thanks Waqar!

[SteBlood]

So what I have come to realise is that I cannot just show the parks that have 'any' properties linked.

I have a taxonomy which allows people to mark the properties as;

For Sale, Sold, Draft/Save for later or Under Offer.

Anything Sold has been removed from any listings on the website.

However, using this formula works, but it still shows the parks that have attached Sold items.

Is there a way I can also negate 'Sold' items from the search even though they're attached via a relationship?

For example;

You can see each park has 1 Private Sale(s), but Rownhams Park does not.
This is because the one attached to Rownhams Park has been marked as 'Sold', so shouldn't technically show on this list.

Any help with this would be greatly appreciated, I am soo very nearly there with it!

Thanks
Steve

New threads created by Waqar and linked to this one are listed below:

https://toolset.com/forums/topic/split-filter-to-exclude-posts-with-certain-taxonomy-terms-from-view-results/

[SteBlood]

Changing the post status from Published to either pending review or draft does not change the outcome of this.

[Waqar]

Thanks for the update and glad that the code worked.

I've created a separate ticket for your question about excluding the posts, based on the taxonomy term.
( ref: https://toolset.com/forums/topic/split-filter-to-exclude-posts-with-certain-taxonomy-terms-from-view-results/ )

I'll be following up on that ticket shortly and you're welcome to start a new ticket for each new question or concern.