I'm trying to create a shortcode that runs a custom query based on Yoast's primary category meta key.

The goal is to pull posts with the same meta key value of the post being displayed and show 4 more in the sidebar.

So far, everything is working but the query isn't getting posts with the same value.

I added an echo of the meta key value to make sure it was getting it, and it is.

Here's my code:

function primary_category_query_shortcode( $atts ) {
    $atts = shortcode_atts( $defaults, $atts, 'primary_category_query' );

    $my_meta = get_post_meta ( $id, '_yoast_wpseo_primary_category', true);

// WP_Query arguments
$args = array (
    'posts_per_page'         => '4',
    'meta_query'             => array(
        array(
            'key'       => '_yoast_wpseo_primary_category',
            'value'     => '$my_meta',
        ),
    ),
);

    echo get_post_meta( get_the_ID(), '_yoast_wpseo_primary_category', true);  

// The Query
$query = new WP_Query( $args );

// The Loop
if ( $query->have_posts() ) { ?>

    <section class="recent-posts clear">

    <?php while ( $query->have_posts() ) : $query->the_post() ; ?>

    <article id="post-<?php the_ID(); ?>" <?php post_class( 'left' ); ?>>

    <a href="<?php the_permalink(); ?>" title="<?php the_title_attribute(); ?>">
        <?php the_title(); ?>
    </a>

    </article>

    <?php endwhile; ?>

    </section>

    <?php } else {
        echo 'Sorry, no more found.';
    }

    /* Restore original Post Data */
    wp_reset_postdata();
}
?>```

I'm trying to create a shortcode that runs a custom query based on Yoast's primary category meta key.

The goal is to pull posts with the same meta key value of the post being displayed and show 4 more in the sidebar.

So far, everything is working but the query isn't getting posts with the same value.

I added an echo of the meta key value to make sure it was getting it, and it is.

Here's my code:

function primary_category_query_shortcode( $atts ) {
    $atts = shortcode_atts( $defaults, $atts, 'primary_category_query' );

    $my_meta = get_post_meta ( $id, '_yoast_wpseo_primary_category', true);

// WP_Query arguments
$args = array (
    'posts_per_page'         => '4',
    'meta_query'             => array(
        array(
            'key'       => '_yoast_wpseo_primary_category',
            'value'     => '$my_meta',
        ),
    ),
);

    echo get_post_meta( get_the_ID(), '_yoast_wpseo_primary_category', true);  

// The Query
$query = new WP_Query( $args );

// The Loop
if ( $query->have_posts() ) { ?>

    <section class="recent-posts clear">

    <?php while ( $query->have_posts() ) : $query->the_post() ; ?>

    <article id="post-<?php the_ID(); ?>" <?php post_class( 'left' ); ?>>

    <a href="<?php the_permalink(); ?>" title="<?php the_title_attribute(); ?>">
        <?php the_title(); ?>
    </a>

    </article>

    <?php endwhile; ?>

    </section>

    <?php } else {
        echo 'Sorry, no more found.';
    }

    /* Restore original Post Data */
    wp_reset_postdata();
}
?>```

• wp-query
• query
• meta-value

• So no error, it's just pulling incorrect posts? In the DB, in post_meta, can you confirm that the _yoast_wpseo_primary_category is being assigned to posts? Also, above this line echo get_post_meta( get_the_ID(), '_yoast_wpseo_primary_category', true); can you add a var_dump( $id ); and beneath that line var_dump( $my_meta ); so we can verify what's there? Want to make sure neither of those are empty. – Tony Djukic Commented Apr 18, 2020 at 0:00
• adding the single quote marks turns this '$my_meta' into a string, you want to use the variable direct: 'value' => $my_meta – Michael Commented Apr 18, 2020 at 2:02
• @TonyDjukic It's not pulling any posts currently. I pulled up the database and I'm confused by the results. link It seems like it's only being applied to 2 posts (if I'm reading right, I don't spend much time in databases), but I've assigned that meta to 6 posts and it's not showing the value I expected. Here's a picture of the output link since adding var_dump. "29" is the echo of the category ID I'm looking to pull from. Sorry if I'm missing something obvious, I'm new to queries obviously. And thank you! – Christina Commented Apr 19, 2020 at 21:27
• @Michael Thank you! Still learning. :) – Christina Commented Apr 19, 2020 at 21:28
• Good catch Michael, I completely missed that. – Tony Djukic Commented Apr 19, 2020 at 21:51

1 Answer 1

Based on our chat in the comments here's what I came with. Please advise if it works.

<?php
function primary_category_query_shortcode( $post, $atts ) {
    //global $post;  //Uncomment this global if it still doesn't work.
    $atts = shortcode_atts( $defaults, $atts, 'primary_category_query' );
    $my_meta = get_post_meta ( $post->ID, '_yoast_wpseo_primary_category', true );
    // WP_Query arguments
    $args = array (
        'posts_per_page'         => '4',
        'meta_query'             => array(
            array(
                'key'       => '_yoast_wpseo_primary_category',
                'value'     => $my_meta
            ),
        ),
    );
    // All this would do is echo the ID of the category, correct?  Just for testing?
    //echo get_post_meta( get_the_ID(), '_yoast_wpseo_primary_category', true);  
    // The Query
    $query = new WP_Query( $args );
    // The Loop
    if ( $query->have_posts() ) { ?>
        <section class="recent-posts clear">
        <?php while ( $query->have_posts() ) : $query->the_post() ; ?>
            <article id="post-<?php the_ID(); ?>" <?php post_class( 'left' ); ?>>
                <a href="<?php the_permalink(); ?>" title="<?php the_title_attribute(); ?>">
                    <?php the_title(); ?>
                </a>
            </article>
        <?php endwhile; ?>
        </section>
    <?php } else {
        echo 'Sorry, no more found.';
    }
    /* Restore original Post Data */
    wp_reset_postdata();
}
?>

An explanation, what I suspect may be happening is that your attempt to get the Yoast Primary Category isn't succeeding because, based on your var_dump() you're not getting the post ID, it's coming back as NULL. So instead we'll include the $post in the function() and if that still doesn't work, we'll use global $post; to make sure it's being referenced. (That would be the second line, just uncomment it if it doesn't work without it.)

I've also commented out the echo get_post_meta( get_the_ID(), '_yoast_wpseo_primary_category', true ); because that would, in theory, just echo out the ID number of the category. So I assumed you had that in there for testing.