Reply To: Query Posts for Repeater Subfield "User" Equal to Current Author

• James

• November 15, 2016 at 12:54 pm

Hi @inhouse

I’m afraid I don’t understand your current setup, so please forgive me if I’m wrong.

Could you please check the documentation here (under the Sub custom field values section): https://www.advancedcustomfields.com/resources/query-posts-custom-fields/? Based on that documentation, your code should be like this:

// filter
function my_posts_where( $where ) {
	
	$where = str_replace("meta_key = 'people_list_%", "meta_key LIKE 'people_list_%", $where);

	return $where;
}

add_filter('posts_where', 'my_posts_where');

// args
$args = array(
	'post_type' => 'page',
	'meta_query' => array(
		array(
			'key' => 'people_list_%_person_list_user',
			'value' => '"' . $author_id . '"',
			'compare' => 'LIKE'
		)
	)
);
$the_query = new WP_Query( $args );
if( $the_query->have_posts() ):
while ( $the_query->have_posts() ) : $the_query->the_post();

I hope this helps 🙂