Reverse relationship field query for ACF as a function 🔥

reverse-relationship-query.php

function getParents($childPostId, $parentPostType, $acfKey) {
    return get_posts(array(
        'post_type' => $parentPostType,
        'meta_query' => array(
            array(
                'key' => $acfKey,
                'value' => '"' . $childPostId . '"',
                'compare' => 'LIKE'
            )
        ) 
    ));
}

Example Usage

function getAssociatedCommunityLink() {
    $parents = getParents(get_the_ID(), 'plan', 'properties');

    if ($parents) {
        foreach ($parents as $parent) {
            $grandparents = getParents($parent->ID, 'community', 'floor_plans');

            if ($grandparents) {
                foreach ($grandparents as $grandparent) :
                    return get_the_permalink($grandparent->ID);
                endforeach;
            } else {
                return "/community";
            }
        }
    }
    
    return "/community";
}