Query string to show only posts with no meta value WordPress

Utkarsh Kukreti answers:

Not sure if it'll work, but how about

"&category_name=news&posts_per_page=5&meta_key=featured&meta_value="

Millions comments:

This isn't working unfortunately, but thanks for the suggestion.

Arnav Joy answers:

what is the meta value of featured post??

Millions comments:

The value of the featured post is 'on' - it's a tick box.

Sadly 'off' doesn't work...

Arnav Joy comments:

try following:-

"&category_name=news&posts_per_page=5&meta_key=featured&meta_value!='on' "

Arnav Joy comments:

If you can provide me details of your page then i can solve this.
my id is: [email protected]

Sébastien | French WordpressDesigner answers:

"&category_name=news&posts_per_page=5&meta_key=featured&meta_value="

and if you use a query_posts in the precedent loop, don't forget to use wp_reset_query();
at the end of this precedent loop

Millions comments:

That's not doing the trick I'm afraid.

Sébastien | French WordpressDesigner comments:

is there a value by default for the meta_key "featured" ?

Millions comments:

Just checked and unfortunately there isn't, no.

Kannan C answers:

when you save the post meta, do like this
if($_POST["featured_post"])
update_post_meta($post->ID, "_featured_post", 'on');
else update_post_meta($post->ID, "_featured_post", 'off');

//then your query should be
"&category_name=news&posts_per_page=5&meta_key=featured&meta_value=off"

Kannan C comments:

if you already have posts then try this

$query = new WP_Query( array( 'meta_key' => 'featured_post', 'meta_value' => 'on', 'meta_compare' => '!=' ) );


Jurre Hanema answers:

Query strings suck. Can I see how you query your posts using your current query string (I suspect query_posts or WP_query)? I may then be able to rewrite it using an "advanced" meta query, which should do the job. (Are you using WP 3.1 or higher? If not, upgrade)

Millions comments:

Here's how it looks at the moment...


<?php
$otherstuffQuery = $query_string . "&category_name=news&posts_per_page=5&meta_key=featured&meta_value=-";
$myposts = get_posts( $otherstuffQuery );
if(count($myposts) >0) {
?>

<?php
foreach( $myposts as $post ) : setup_postdata($post); ?>
<a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>">
<?php the_title(); ?>
</a>

<?php endforeach; ?>
<?php
} ?>


And yes I'm on 3.1. Thanks in advance...

Jurre Hanema comments:

Try this:


<?php

$otherstuffQuery = new WP_Query;

$otherstuffQuery->query(
array(
'posts_per_page' => 5,
'category_name' => 'news',
'meta_query' => array(
array(
'key' => 'featured',
'value' => 'on',
'compare' => '!='
)
)
)
);


while($otherstuffQuery->have_posts())
{
$otherstuffQuery->the_post();
?>
<a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>">
<?php the_title(); ?>
</a>
<?php
}

wp_reset_query();
?>


I didn't test it yet... but I think there's a good chance it might work.

Manoj Raj answers:

i don't think meta_compare will work. I have maintained some records of situations i have come across in wordpress... Luckily One text file contains this code .. This solution provided by <strong>Joe </strong>will help you for sure.. This should be the way to solution..

Hope this code is already self explanatory. if it is not, i will give you an example some time later.. Or some other guys here will help you..

// add a filter to 'posts_where' to add the subquery
add_filter( 'posts_where', '_exclude_meta_key_in_posts_where' );

// make the query, the below function will be called
query_posts(array('showposts' => 1000, 'post_parent' => $post->ID, 'post_type' => 'page', 'orderby' => 'title', 'order' => 'ASC'));

function _exclude_meta_key_in_posts_where( $where ) {

global $wpdb;
return $where . " AND $wpdb->posts.ID NOT IN ( SELECT DISTINCT post_id FROM $wpdb->postmeta WHERE meta_key = 'featured_product' AND meta_value > '' )";
}

//remove the filter incase we do any more query_posts()s
remove_filter( 'posts_where', '_exclude_meta_key_in_posts_where' );


Thank you

Julio Potier answers:

Or again, try this :
$newWPQuery = new WP_Query( array( 'meta_key' => 'featured_post', 'meta_value' => 'on', 'meta_compare' => '!=' );