Reply To: Reverse Query Relationship subfield which is nested in a Repeater Field

• extrasmall

• November 12, 2017 at 3:51 pm

For anyone that runs across this, @elliot‘s custom filter to allow the LIKE function to work no longer works as of WP 4.8.3

If you replace it with the following function you’ll be all set. Hopefully this saves someone else the few hours I lost on it 🙂

function allow_wildcards( $where ) {
global $wpdb;
$where = str_replace(
"meta_key = '{$repeater_field_name}_%_{$sub_field_name}", 
"meta_key LIKE '{$repeater_field_name}_%_{$sub_field_name}",
$wpdb->remove_placeholder_escape($where)
);
return $where;
}

add_filter('posts_where', 'allow_wildcards');