Support

Account

Home Forums Add-ons Repeater Field Reverse Query Relationship subfield which is nested in a Repeater Field Reply To: Reverse Query Relationship subfield which is nested in a Repeater Field

  • 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 🙂