Reply To: Query by Repeater row subfield checkbox

• rdm

• February 20, 2019 at 10:50 am

Personally, I use $wpdb to query repeater fields. This might not be the best way (you might want to use wp_cache_set/wp_cache_get if this turns into a performance issue), but it works for me.

If I understand your situation properly, I imagine something like this (warning, untested code):

global $wpdb;
return $wpdb->get_col("SELECT DISTINCT post_id FROM wp_postmeta m INNER JOIN wp_posts p ON m.post_id = p.id AND p.post_type='artist' WHERE m.meta_key LIKE 'video\_%\_tag' AND m.meta_value='featured'");

If I am not mistaken about your setup, this would return a list of artist post ids where any of the tags in your video repeater is set to ‘featured’.

Note that, as written, this would return both published and unpublished posts. If you wanted just published posts you’d need to add that constraint to the query (in the where clause, something like: AND p.post_type=’publish’).