Support

Account

Home Forums General Issues Meta query key with POST OBJECT (ACF) (post_title) in wordpress

Solved

Meta query key with POST OBJECT (ACF) (post_title) in wordpress

  • I have big problem with my meta query. I would like to filter my posts, and I need query to compare post_title with my $_POST value. Code:

    function postsFilter(){
    $args = array(
        'post_type' => 'posts',
        'meta_query' => array(
            'relation' => 'AND'
        )
    );
    
    if( isset($_POST['year']) && $_POST['year'] ) 
    $args['meta_query'][] = array(
        'key' => 'year',
        'value' => $_POST['year'],
        'compare' => '='
    );
    if( isset($_POST['theme']) && $_POST['theme'] ) 
    $args['meta_query'][] = array(
        'key' => 'theme',
        'value' => $_POST['theme'],
        'compare' => '='
    );
    
    if( isset($_POST['member']) && $_POST['member'] ) 
    $args['meta_query'][] = array(
        'key' => 'member_relation',
        'value' => <code></code>.$_POST['member'].<code></code>,
        'compare' => 'LIKE'
    );
    
    $query = new WP_Query( $args );
    
    echo "<script>
    var posts_p = '" . json_encode( $query->query_vars ) . "',
         current_page_p = " . 1 . " ,
         max_page_p = " . $query->max_num_pages . ";
         console.log(current_page_p, max_page_p);
    </script>";
    
    if( $query->have_posts() ) :
        while( $query->have_posts() ): $query->the_post();
            get_template_part('template-parts/content', 'posts');
        endwhile;
        if (  $query->max_num_pages > 1 )
            echo '<div class="button-load-more_p btn-load-more text-center mx-auto w-100"><a class="btn btn-primary btn-md btn-with-icon fade-in full-visible load-more"><span>Load more</span></div></a></div>';
        wp_reset_postdata();
    else :
        echo 'No publications found';
    endif;
    
    die();

    and problem exists here:

    if( isset($_POST['member']) && $_POST['member'] ) 
    $args['meta_query'][] = array(
        'key' => 'member_relation',
        'value' => $_POST['member']
        'compare' => 'LIKE'
    );

    because I don’t know how to write this part of query, member relation is POST OBJECT type file in WordPress, I need compare $_POST[‘member’] with post_title value (maybe I am wrong ?)

    Is it possible to write this query? Please give me any advice or example solution of my problem.

  • You cannot compare a text value with a post object field. A post object field holds only the ID of the post object. The title of the post object is part of that other post and not part of the relationship field.

    Their is nothing built into WP that will let you do this in a single query.

    You would first need to search the posts of the other post type to get the ID based on the text. Then you can use the ID value(s) returned by this first query in your second query.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.