Show metabox value last post excerpt, title and link

Question

I'm facing a problem I can't solve. I'd like to get the excerpt, title and link of the last post containing a particular meta-box button status.

For example: I would like to retrieve the last post with the status "1" on the meta-box button id "hotnews-status". But I don't know how to do this despite my multiple searches on the forum or in Wordpress docs.

The final goal is to display these news in a component generated by the Visual Composer plugin.

Thank you in advance for your help and advice!

Answer 1

IF HOT NEWS IS A TAG (FIRST QUESTION ASKED FOR TAGS)

You gotta use a WP query where you query posts which have the tag "hot news" and order the result in descending order of the post ID, and then return 1 post, sth like this:

$query_args = array(
  'post_type' => 'your_post_type',
  'tax_query' => array(
    array(
      'taxonomy' => 'your_tag_taxonomy',
      'field' => 'slug',
      'terms' => 'hot_news'
    )
  ),
  'order_by' => 'ID',
  'order' => 'DESC',
  'posts_per_page' => 1
);

// Fire WP post query
$my_query = new WP_Query( $query_args );

// Check if at least one matching post was found
if ( $my_query->have_posts() ) {

  // If yes, iterate through the found post(s)
  while ( $my_query->have_posts() ) {

    // Forward the post iterator to the currently iterated post of the loop.
    // Like this you'll be able to get the iterated posts' content via the
    // ```get_the...``` etc. functions
    $my_query->the_post();

    $posts_title = get_the_title();
    $posts_excerpt = get_the_excerpt();
    $link = get_the_permalink();

    echo $posts_title." ".$posts_excerpt." ".$link;

  }

}

// Reset the global $post object (should always be done after post queries)
wp_reset_postdata();

IF HOT NEWS IS A META KEY (LATER ASKED FOR META)

If you wanna query in function of metavalues, you need to formulate your query args as follows:

$query_args = array(
  'post_type' => 'your_post_type',
  'meta_query' => array(
    array(
      'key' => 'hotnews-status',
      'value' => 1,
      'type' => 'NUMERIC'
    )
  ),
  'order_by' => 'ID',
  'order' => 'DESC',
  'posts_per_page' => 1
);

The logic behind both queries is the following: Each time you create a newpost, that post will get an auto-incremented ID value associated to it (meaning = ID of the most recently added post + 1) in your database. To thus get the most recent post, order your queried posts in function of their post ID in descending order, and return 1 post (posts_per_page parameter of the query). And yeah then you add any additionally needed filters, such as tag / category / taxonomy / metavalue / whatever filters. Clear?