Ok,
I was able to find a solution. Its what Elliot has suggested but using $wpdb. For some reason, Elliot’s meta query example did not work for me (returns no results).
Here is what I did:
global $wpdb;
$meetings = $wpdb->get_results( "SELECT post_id FROM wp_postmeta WHERE meta_key LIKE 'members_%_staff' AND meta_value = '{$user_id}'", OBJECT );
In the above example:
- “members” is the name of the repeater field
- “staff” is the name of the subfield (a user in my case)
- “{$user_id}” is the ID of the user which we need to lookup in meetings
$meetings contains all the post ids that have the staff (user) added as a subfield.
Like Elliot mentioned, the “%” is important as we don’t know the row index of the subfield.
$wpdb packs so much power than your standard wordpress $args query model. Hope that helps someone 🙂
