Query subrepeater field inside a group field

• 

  • yarongo

  • December 17, 2020 at 8:53 pm

  I have a set of fields in a repeater that in a group field.
  I’m tring to search a name in that repeater from all the posts i have in “projects” custom post that attached to a specific “customer”

  more_details – group field
  professionals – repeater
  professional_name – subfield which i need to search on

  I tried this:

  function my_posts_where( $where ) {
  	$where = str_replace("meta_key = 'more_details_$_professionals_$_professional_name'", "meta_key LIKE 'more_details_%_professionals_%_professional_name'", $where);
  	return $where;
  }
  add_filter('posts_where', 'my_posts_where');
  
  $searchKey = $_POST['searchKey'];
  $customerID = $_POST['customerID'];
  
  $args = array(
  'post_type' => 'projects',
  'posts_per_page' => -1,
  		'meta_query'	=> array(
  		'relation'		=> 'AND',
  		array(
  			'key'		=> 'customer',
  			'compare'	=> '=',
  			'value'		=> $customerID,
  		),
  		array(
  			'key'		=> 'more_details_$_professionals_$_professional_name',
  			'compare'	=> 'LIKE',
  			'value'		=> $searchKey,
  		)
  	)
      );
  	
  $query = new WP_Query( $args );
  if( $query->have_posts() )....
• 

  

  • John Huebner

  • December 17, 2020 at 11:16 pm

  group fields do not have indexes, the meta key should be

  
  more_details_professionals_$_professional_name