meta_query value search in checkbox array?

• khomel

• February 21, 2019 at 11:18 am

I’m trying to do a WP_User_Query with a meta_query checking a checkbox field type against a submitted value from a select field. Code looks like this:

$sector_field_arr = get_field('sector');
					
				$user_query = new WP_User_Query( array( 
					'role' => 'Member',
					'meta_key' => 'last_name',
					'orderby' => 'meta_value',
					'order' => 'ASC',

					'meta_query' => array(
					  array(
						'key' => 'publish_publically',
						'value' => true
					  ),
						array(
						'key' => $sector_field_arr,
						'value' => $_POST['sector-select'],
						'compare' => 'IN'
					  )
					)

				) );

Everything is working except for trying to find the submitted value from the select field ($_POST[‘sector-select’]) in the checkbox array (sector). Any ideas how to find the submitted value in the field array?

• khomel

• February 21, 2019 at 4:30 pm

Turns out I was making it more complicated than it needed to be. This did the trick:

$user_query = new WP_User_Query( array( 
					'role' => 'Member',
					'meta_key' => 'last_name',
					'orderby' => 'meta_value',
					'order' => 'ASC',

					'meta_query' => array(
					  array(
						'key' => 'publish_publically',
						'value' => true
					  ),
						array(
						'key' => 'sector',
						'value' => $_POST['sector-select'],
						'compare' => 'LIKE'
					  )
					)

				) );