[Resolved] Populate a Gravity form Dropdown with post titles from a Custom post type

[Author]

Posts

[Rune Brynestad]

I'm populating a Gravity form Dropdown with post titles from a Custom post type with the slug "building".

add_filter( 'gform_pre_render_2', 'populate_posts' );
add_filter( 'gform_pre_validation_2', 'populate_posts' );
add_filter( 'gform_pre_submission_filter_2', 'populate_posts' );
add_filter( 'gform_admin_pre_render_2', 'populate_posts' );
function populate_posts( $form ) {
 
    foreach ( $form['fields'] as $field ) {
 
        if ( $field->type != 'select' || strpos( $field->cssClass, 'populate-posts' ) === false ) {
            continue;
        }
 
        // you can add additional parameters here to alter the posts that are retrieved
        $posts = get_posts( 'post_type=building&numberposts=-1&post_status=publish' );
 
        $choices = array();
 
        foreach ( $posts as $post ) {
            $choices[] = array( 'text' => $post->post_title, 'value' => $post->post_title );
        }
 
        // update 'Select a Post' to whatever you'd like the instructive option to be
        $field->placeholder = 'Velg eiendom';
        $field->choices = $choices;
 
    }
 
    return $form;
}

The script works fine, but I need to add another parameter to the filter to alter the posts that are retrieved:

$posts = get_posts( 'post_type=building&numberposts=-1&post_status=publish' );

I need to filter on a relationship. Only Buildings connected with the Customer Group relationship named "Eiendomsspar" should be retrieved. Is it possible?

Thanks in advice.

Kind regards
Rune

[Minesh]

Hello. Thank you for contacting the Toolset support.

Toolset offers the post-relationship API function toolset_get_related_posts() that will allow you to fetch the related posts.
=> https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/#toolset_get_related_posts

For example - To get related posts:

$posts = toolset_get_related_posts(
    get_the_ID(), //Post to query by.
    'replace-your-relationship-slug,  //Slug of the relationship to query by
    'parent', //Name of the element role to query by.
    1000, //Maximum number of returned results
    0, //Result offset
    array( //Additional query arguments
      'meta_key' => 'wpcf-customer-group',
      'meta_compare' => '=',
      'meta_value' => 'Eiendomsspar'
    ),
    'post_object', //Determines return type
    'child', // which posts from the relationship should be returned
    'title', //orderby: null, 'title', 'meta_value', 'meta_value_num'
    'ASC' // $order 'ASC' or 'DESC'.
);

Where:
- Replace "replace-your-relationship-slug" with your original post-relationship slug
- Replace "wpcf-customer-group" field slug if required with your original custom field slug
- Replace the meta_value if required.

Can you please try and check if the solution I shared help you to resolve your issue.

[Rune Brynestad]

My issue is resolved now. Thank you!