tax-query - Read For Learn

wp_get_object_terms count on taxonomies within an category archive

A simple function to count posts did the trick, but this is one more request in DB : function count_posts_in_cat_by_custom_term( $category_ID, $custom_taxonomy_name, $custom_term_id ){ $args = array( ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘posts_per_page’ => -1, ‘category’ => $category_ID, ‘tax_query’ => [ [ ‘taxonomy’ => $custom_taxonomy_name, ‘fields’=>’term_id’, ‘terms’ => $custom_term_id, ] ] ); $posts = … Read more

WP_Query with tax_query not working

SQL query forming is wrong SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND 0 = 1 AND wp_posts.post_type=”product” AND (wp_posts.post_status=”publish”) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 1 Here 1=1 AND 0 = 1

Output ACF field dynamicaly within a taxonomy loop [closed]

Alright, problem solved. Turned out to be a pretty basic mistake, actually. All I needed to do was to pass on the queried term as a second parameter in get_field();. I even posted a comment here referencing one of ACF´s docs that explains just that… Turns out I ALREADY had created the taxonomy array $collections, … Read more

How to pass >= condition filter to my year custom tax_query

You can pass an array of years to the tax_query (or use PHP range()). The default operator is IN – see https://developer.wordpress.org/reference/classes/wp_tax_query/__construct/#parameters $args = array( ‘tax_query’ => array( array( ‘taxonomy’ => ‘year’, ‘field’ => ‘name’, ‘terms’ => range($min_year, $max_year) ) ) );

Woocommerce – Shipping tax class based on cart items not using the highest tax available

I have found the answer by override the shipping tax filter // 0% and 21% tax producdts added combined to the cart needs to have 21% shipping tax add_filter(‘woocommerce_shipping_packages’, ‘override_woocommerce_shipping_packages’); function override_woocommerce_shipping_packages($packages) { $shipment_needs_tax = false; foreach ($packages[0][‘contents’] as $cartitem) { if (!empty($cartitem[‘data’]->tax_class)) $shipment_needs_tax = true; } if ($shipment_needs_tax && empty($packages[0][‘rates’][‘flat_rate:3’]->get_taxes())) { $shipcost = $packages[0][‘rates’][‘flat_rate:3’]->get_cost(); … Read more

Using tax_query to get single post per category

Set ‘posts_per_page’ to 1 on your args variable. I also suggest that you add ‘page-attributes’ while registering the magazine’s post type and order the result by ‘menu_order’. This way, you will have the field Order while editing a magazine, and set the highest which should appear on this query.

How to limit posts to 1 from each term with tax_query?

<?php $categories = array(‘economy’,’the-constitution’,’monetary-policy’,’liberty’); foreach($categories as $category) { $args = array( ‘posts_per_page’ => 1, ‘category_name’ => $category, ‘tax_query’ => array( array( ‘taxonomy’ => ‘highlight’, ‘field’ => ‘slug’, ‘terms’ => array( ‘lead’,’featured’ ), ‘operator’ => ‘NOT IN’ ) ) ); $wpse42358_query = new WP_Query( $args ); while( $wpse42358_query->have_posts() ) : $wpse42358_query->the_post(); // write post stuff here … Read more

Custom Query Arguments

/** * Define a new function that uses $args and wp_parse_args() */ function explain_parse_args( $args ) { $defaults = array ( ‘text’ => ‘wp_parse_args() merges $args into $defaults’, ‘before’ => “”, ‘after’ => ” \n”, ‘echo’ => TRUE ); // Parse incomming $args into an array and merge it with $defaults $args = wp_parse_args( $args, … Read more

Cannot query custom post type taxonomy from theme options array

You create a new query and assign it to $my_qry, but you never loop over those results. See the codex page for WP_Query, the loop has to reference your new query object: $my_qry = new WP_Query($args); if ( $my_qry->have_posts() ) : while ( $my_qry->have_posts() ) : $my_qry->the_post(); // etc.. endwhile; endif;

How to update WordPress custom SQL Select query for custom taxonomies so that syntax is correct?

You should not use a direct SQL query, instead try the WP_Query tax queries e.g.: $args = array( ‘post_type’ => ‘post’, ‘tax_query’ => array( ‘relation’ => ‘AND’, array( ‘taxonomy’ => ‘category’, ‘field’ => ‘id’, ‘terms’ => array( 22 ) ), array( ‘taxonomy’ => ‘job’, ‘field’ => ‘name’, ‘terms’ => $terms, ‘operator’ => ‘IN’ ) ) … Read more

+ More