This is not possible with the WP_Query. You can specify relationship inside the tax query and inside the meta query, but, you can’t have the query where meta and tax query are connected by OR. You can always build the SQL query the way you want it, not relying on the WP_Query at all to … Read more
You should be able to do what you’re trying to do. I think the issue may be that relation should not be contained in it’s own array. It should look like this: $prodPost = new WP_Query( array( ‘post_type’ => ‘product’, ‘posts_per_page’ => 6, ‘paged’ => 1, ‘meta_query’ => array( array( ‘relation’ => ‘AND’, array( ‘key’ … Read more
Looking at WP_Tax_Query and WP_Meta_Query used by Wp_Query, they return their respective where clauses with an AND relation, and no hook or $args to change that behavior. Furthermore, the tax_query is computed before the rest of the main query so that it’s included in the main query in term_taxonomy_id IN (…) form. Also the WP_Tax_Query … Read more
If the query string contains, as you say: listing_i_have=own%20studio It’s not working because $rt_field_id_i_have[0] is equal to the first character in the string (it’s not an array), it’s a string. The 0 index position is the letter o, which matches A LOT of things. You can add the proper meta query like so. <?php function … Read more
As you mention you need something like mixed tax and meta query with possibility to join them by condition OR or AND, which does not exist in WordPress. You can modify SQL directly using filters to get your result. /** * This function will add meta_key to WordPress query. * It will take care of … Read more
You can add custom meta fields for doing so. Here, is sample code for adding a meta field for post type post. For more details please refer to link. <?php /************************************************************************/ function myPrice_meta_box() { add_meta_box(‘myPrice_field’, ‘Price’, ‘myPrice_meta_box_callback’, ‘post’, ‘normal’, ‘high’); } add_action(‘add_meta_boxes’, ‘myPrice_meta_box’); /** * Prints the box content. * * @param WP_Post $post The … Read more
Looks like I found the solution. I needed to use compare instead of operator in the meta_query so array( ‘key’ => ‘vacancy_small_salary’, ‘value’ => $vacancy_small_salary, ‘operator’ => ‘>=’, ‘type’ => ‘NUMERIC’ ), becomes array( ‘key’ => ‘vacancy_small_salary’, ‘value’ => $vacancy_small_salary, ‘compare’ => ‘>=’, ‘type’ => ‘NUMERIC’ ), and the same for the other query
You have to use NOT EXISTS. You will get all posts, which do not have meta field ‘seasonaldiscountdesc’. $args = array( ‘post_type’ => ‘mad_property’, ‘post_status’ => ‘publish’, ‘paged’ => ‘-1’, ‘meta_query’ => array( ‘key’ => ‘seasonaldiscountdesc’, ‘compare’ => ‘NOT EXISTS’ ) );
You can use the filter posts_orderby. For a simple example: add_filter(‘posts_orderby’, ‘apply_sql_on_order’, 10, 2 ); function apply_sql_on_order($orderby, $query) { if(is_array($query->query_vars[“orderby”]) && array_key_exists(“apply_sql”, $query->query_vars[“orderby”])) { $orderby = preg_replace(“/(.*) (ASC|DESC)/”, $query->query_vars[“orderby”][“apply_sql”] . “($1) $2”, $orderby); } return $orderby; } $query = new WP_Query( array( ‘meta_query’ => array( ‘state_clause’ => array( ‘key’ => ‘state’ ), ), ‘orderby’ => … Read more
UPDATE: 2/28/18 Since you need to update all the posts in a particular taxonomy, it sounds like you need to read up on how WP_Query() works. Here’s a simple loop to get you started that will fetch all posts in a taxononmy, and update them if the “now is later than then” condition is met. … Read more