I think what you are after is get_post_meta() and not a custom query. REASONS: The results from custom fields are cached and extremely streamline when it cone to performance. You can read this answer I have done recently which will explain everything You are trying to get the custom field attached to a post only … Read more
First of all, your meta_query is wrong. It should be an array of an array, not just an array So, the following ‘meta_query’ => array ( ‘key’ => ‘qd_resource_author_selector’, ‘value’ => $myAuthor, ), becomes ‘meta_query’ => array ( array( ‘key’ => ‘qd_resource_author_selector’, ‘value’ => $myAuthor, ), ), Secondly, you can optimize your query. You are … Read more
meta_query format and orderby format should be as follows: $args = array( ‘post_type’ => ‘product’, ‘post_status’ => ‘publish’, ‘posts_per_page’=> 10, ‘orderby’ => ‘total_sales’, ‘order’ => ‘DESC’, ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘_featured’, ‘value’ => ‘yes’, ‘compare’ => ‘=’ ), array( ‘key’ => ‘total_sales’, ‘value’ => ’10’, ‘compare’ => ‘>=’ ) ) … Read more
I solve this problem as below. We should compare each meta value instead of passing array in the meta value. Array( [post_type] => post [posts_per_page] => 3 [order] => DESC [meta_query] => Array( [relation] => AND [0] => Array( [key] => argomento [value] => Array([0] => 2875 ) [compare] => like ) [1] => Array( … Read more
Shouldn’t it be like this (doc)? $meta_query[] = array( ‘meta_query’ => array( ‘relation’ => ‘AND’, array( ‘key’ => ‘estate_property_google_maps’, ‘value’ => $al[‘0’], ‘compare’ => ‘LIKE’ ), array( ‘key’ => ‘estate_property_google_maps’, ‘value’ => $al[‘1’], ‘compare’ => ‘LIKE’ ), ) );
There are few issue with your code When using WP_Query in conjuction with the_post() or using get_posts() in conjuction with setup_postdata( $post ), you need to reset the $post global with wp_reset_postdata(), not wp_reset_query(). wp_reset_query() is used in conjuction with query_posts() which you should never ever use You would want to reset posdata between your … Read more
I found an older post showing what I was missing from my code, so it seems like I didn’t do a good enough search to begin with. For anyone wondering I was missing ‘compare’ => ‘LIKE’ from the query, so the code would look like this: $args_post = array(‘post_type’ => ‘release’, ‘orderby’ => ‘_custom’, ‘order’ … Read more
This $_GET[‘variable’] is an array, as per your URL query string ?variable[]=value1&variable[]=value2, $_GET[‘variable’][0] and $_GET[‘variable’][1] should return those 2 key values Edit – after the discussion – making it dynamic $meta_query = array(); if ( ! empty( $_GET[“variable”] ) ) { if ( is_array( $_GET[“variable”] ) ) { $meta_query[‘relation’] = ‘OR’; foreach ( $_GET[“variable”] as … Read more
When you call get_posts WP will also retrieve and cache all the post meta, so your later calls to get the meta data shouldn’t cause any more database queries.
This is how meta_key/_values work. How you store your values is case sensitive. Example meta_key = “foo’ and meta_value=”Bar” Would return the result you are looking for: $posts = new WP_Query( ‘post_type=post&meta_key=foo&meta_value=Bar’ ); Would not return the result you are looking for: $posts = new WP_Query( ‘post_type=post&meta_key=foo&meta_value=bar’ ); However it does appear that your database … Read more