Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I am writing a custom loop query to filter through a custom post type and custom taxonomy. I have replaced any variables with static values for the purpose of showing you what result I want.

$args = array(
    'manufacturer' => 'Keystone',
    'post_type' => 'rv',
    'category_name' => 'new',
    'rvtype' => 'fifth-wheel'
);

$loop = new WP_Query($args);

When I run this loop, instead of showing, just fifth-wheels, all posts under the manufacturer type 'Keystone' are shown. Why is this? Shouldn't this query only show posts with the custom taxonomy requested, under the post-type = rv, with the new category, with the rvtype = fifth-wheel?

Any insight would be greatly appreciated!

share|improve this question
add comment

1 Answer 1

Pretty sure you can't match multiple taxonomy terms in a query--Wordpress will only honor the first one and ignore the rest.

Apparently, this is scheduled to be fixed in 3.1.

In the meantime, there is a plugin that'll fix you right up: http://scribu.net/wordpress/query-multiple-taxonomies

EDIT: If you want a non-plugin solution, let me know. I've got one I use.

EDIT: Here is the quick and dirty non-plugin way. Drop this code into your functions.php file.

function wpse_5057_match_multiple_taxonomy_terms($where_clause, $wp_query) {

    // If the query obj exists
    if (isset($wp_query->query)) {

        $multi_query = $wp_query->query;

        if (is_array($multi_query) && isset($multi_query['multiple_terms'])) {

            global $wpdb;
            $arr_terms = $multi_query['multiple_terms'];

            foreach($arr_terms as $key => $value) {

                $sql = "AND $wpdb->posts.ID IN(
                    SELECT tr.object_id
                    FROM $wpdb->term_relationships AS tr
                    INNER JOIN $wpdb->term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
                    INNER JOIN $wpdb->terms AS t ON tt.term_id = t.term_id
                    WHERE tt.taxonomy='%s' AND t.slug='%s')";

                $where_clause .= $wpdb->prepare($sql, $key, $value); // add to the where

            }
        }

    }

    return $where_clause; // return the filtered where

}
add_action('posts_where','wpse_5057_match_multiple_taxonomy_terms',10,2); // Hook this to posts_where

Now, when you run a query, add a new argument called multiple_terms. This should contain an array where the key is the taxonomy name and the value is the value you'd like to match. Like so:

$args = array(
    'post_type' => 'rv',
    'multiple_terms' => array('manufacturer' => 'Keystone', 'rvtype' => 'fifth-wheel')
);

Works for me. This is modified from an idea I found on another forum or blog, but I can't find it for the life of me.

share|improve this answer
    
I would really appreciate your non-plugin solution. Hook me up? –  ToddSmithSalter Dec 8 '10 at 21:58
    
Modified my answer. Lemme know if it works for you! –  MathSmath Dec 9 '10 at 1:52
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.