You should change $parents[] to $parents in get_parents() function: $parents = get_metadata(‘post’, $post_id, WPKWP::$META_CHILD, false); if ($parents !== FALSE && count($parents) > 0) return $parents; return false; because get_metadata return array in this case. If the $post_id parameter is invalid, false is returned. If the meta value isn’t set, function return an empty array. Therefore, … Read more
There’s no hard limit, but meta queries are very inefficient, and in my experience things start to slow down dramatically after 3 or 4, depending on what type of query they are exactly (=, LIKE etc.) For querying based on that many fields you should consider a custom table, rather than meta. Or taxonomies where … Read more
I think you should be able to do this with a tax_query in your $args. I could not test this, and I also dont know how the query behaves with a meta and tax query in one. But I would start with testing something like this: ‘tax_query’ => array( array( ‘taxonomy’ => ‘event_category’, // the … Read more
Like I’ve pointed in my comment, you can find out if a ‘player’ is a ‘goal scorer’ and/or a ‘yellow/red card holder’, by comparing against their post ID. So let’s say there’s a ‘match’ with the following: 9 ‘players’ (ACF fields: pl1 to pl9) 3 ‘goal scorers’ (ACF fields: s1 to s3) 1 ‘card’ (ACF … Read more
Try this: $meta_query_args = array( ‘meta_query’=>array( array( ‘key’ => ‘_cornerstone_data’, ‘value’ => $attachment_url, ‘compare’ => ‘LIKE’, ), ) ); $meta_query = new WP_Query( $meta_query_args ); $posts = $meta_query->posts;
If I understand it correctly, you would need to use the CASE operator in MySQL/MariaDB like so, to achieve that kind of sorting: (try a live demo on DB Fiddle) ORDER BY (CASE # put posts with the specific meta value to the top WHEN (wp_postmeta.meta_value LIKE ‘%12345%’) THEN 1 # for the rest of … Read more
Easy peasy! $args_for_query1 = [ ‘post_type’ => ‘custom_project’, ‘post_status’ => ‘publish’, ‘meta_query’ => array( array( ‘key’ => ‘_thumbnail_id’ ) ) ]; $args_for_query2 = [ ‘post_type’ => ‘custom_project’, ‘post_status’ => ‘publish’, ‘meta_key’ => ‘_thumbnail_id’, ‘meta_compare’ => ‘NOT EXISTS’, ]; $query1 = new WP_Query($args_for_query1); $query2 = new WP_Query($args_for_query2); $wp_query = new WP_Query(); $wp_query->posts = array_merge( $query1->posts, $query2->posts … Read more
‘meta_key’ => ‘clpr_topcoupon’, ‘orderby’ => ‘meta_value_num’, ‘order’ => ‘DESC’ You can solve the problem by using order by clause then there will no need to write meta query. Please use the above code to solve your problem.It will show the posts according to descending order of the value in meta key.
There is one problem with your query. You assume, that it will use OR relation to all query parts. But it won’t. The OR operator will be used only for meta_query parts. It means, that your query is looking for posts that are matching these criteria: (post_title LIKE query) AND ( ean LIKE query OR … Read more
You can use the WP_Query::get method to get whatever is in the meta query like this: add_action(‘pre_get_posts’,’add_another_meta_query’); function add_another_meta_query($query){ //Be sure to only use the main query on frontend if($query->is_main_query() && !is_admin()){ $meta_query = $query->get(‘meta_query’,array()); $new_meta_query = array(); //now, $meta_query has the meta_query if set (or an array) //check if the old version of meta_query … Read more