Exclude posts depending on a custom field value

Hi notavailable98

What is the meta key name and what is it’s value when it’s a sold property?

Hi keesiemeijer, and thanks for the quick reply!

the meta key is ‘_premprop_sold’ and the value is ‘yes’.

Do all properties have the _premprop_sold meta key (with ‘yes’ and ‘no’ values) or only the properties that are sold?

If all properties have the _premprop_sold meta key try it with this in your (child) theme’s functions.php file.

add_filter( 'related_posts_by_taxonomy_posts_join', 'rpbt_filter_tax_related_join' );

function rpbt_filter_tax_related_join( $args ){
	global $wpdb;
	$args .= " INNER JOIN $wpdb->postmeta AS mt1 ON ( $wpdb->posts.ID = mt1.post_id )";
	return $args;
}

add_filter( 'related_posts_by_taxonomy_posts_where', 'rpbt_filter_tax_related_where' );

function rpbt_filter_tax_related_where( $args ){
	// Query for premprop_sold meta key where value is not yes
	$args .= " AND ( mt1.meta_key = '_premprop_sold' AND mt1.meta_value != 'yes' )";
	return $args;
}

btw:
consider creating a child theme instead of editing your theme directly – if you upgrade the theme all your modifications will be lost. Or create a plugin with the code above.

Hi,

Thank you very much for the code!
I put it in my site specific plugin and it did not cause any errors but I’m having problems testing if it actually does the job. I created a property almost identical to another property, with the exact same taxonomies, and it is NOT marked as sold. On the new property page, I can see the original one at the top of the related posts list, however on the original property page I do not see the new one at all. I assume it may have something to do with caching, but that’s just my assumption…

Thanks so much for the help! I appreciate all your efforts.

I would test it like this.

Remove the code from your site site specific plugin. Go to a page were there are sold and unsold related properties. Add the code back. Refresh the page and see if only the unsold related properties remain.

Do unsold properties have the _premprop_sold meta key with a value of ‘no’?

Works perfectly, Thank you very much!
I appreciate your taking the time and effort to help and the extensive scope of your support.

P.S. Correct, unsold properties have the _premprop_sold meta key with the value of ‘no’.

You’re welcome ??

btw:
This will add the meta query to the widget also. Do you want it to only be used by the shortcode?

I know it applies to the widget as well and that’s great.

Thanks again ??