Reply To: Reverse Query Relationship subfield which is nested in a Repeater Field

• shahab

• January 25, 2015 at 8:21 pm

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 🙂