Using pre_get_posts / meta_query on search page?

Yes I am using seamless mode.

Thanks for the example on Gist. I couldn’t get it to work though. It seems the filters are not being called. Got any ideas?

Here’s my settings:

General – http://i.imgur.com/x0c5Rhb.jpg
Search Results 1/2 – http://i.imgur.com/LZn6xl0.jpg
Search Results 2/2 – http://i.imgur.com/wFIaf3L.jpg

The page I am testing on is:

http://willamalane.org/?s=lil

Some of the classes shown, such as “Junior Turbos: Lil Dribblers”, have expired. We’re trying to hide them from that page, for now I’ve simply made them say “This class expired on ____”.

—

Here’s what I was trying, which seemed to have no effect on the search page. It should have killed the page to display the where statement (var_dump, exit). The SQL itself hasn’t been tested yet, but it couldn’t be reached, so I can’t exactly test it yet.

function class_hide_expired_bsearch_join( $join ) {
	global $wpdb;

	$join = $join . "\n  LEFT JOIN {$wpdb->postmeta} <code>class_date</code> ON {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id";
	$join = $join . "\n  LEFT JOIN {$wpdb->postmeta} <code>always_show</code> ON {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id";

	return $join;
}
function class_hide_expired_bsearch_where( $where ) {
	global $wpdb;

	$time = time();

	$where = $where . "\n
	AND (
		{$wpdb->posts}.post_type != 'class'
		OR (
			<code>class_date</code>.meta_key = 'date-timestamp'
			AND (
				<code>class_date</code>.meta_value = 0
				OR
				<code>class_date</code>.meta_value > {$time}
			)
		) OR (
			<code>always_show</code>.meta_key = 'always-show'
			AND
			<code>always_show</code>.meta_value = 'on'
		)
	)";

	// Let's take a look at the WHERE statement
	echo "<pre>";
	var_dump($where);
	exit;

	return $where;
}
add_filter( 'bsearch_posts_join', 'class_hide_expired_bsearch_join' );
add_filter( 'bsearch_posts_where', 'class_hide_expired_bsearch_where' );