Reply To: searching repeater sub field value with WP_User_query

• felicoz

• January 3, 2019 at 2:00 pm

updated, found the solution!

there is a similar “post_where” filter for WP_User_Query, that you can filter out the repeater sub field values.

function user_meta_callback( $user_query )
{
	global $wpdb;
	$user_query->query_where = str_replace("meta_key = 'coupons_$", "meta_key LIKE 'coupons_%", $user_query->query_where);
}
add_filter('pre_user_query', 'user_meta_callback');
	
$q = new WP_User_Query(array(
	'numberposts'	=> -1,
	'meta_query'	=> 
		array(
			'relation'		=> 'OR',
			array(
				'key'		=> 'coupons_$_date',
				'compare'	=> '>=',
				'value'		=> '2018-11-01',
				'type'		=> 'DATE'
			)
		)
	));