What if you use IN operator and split the search term in a words array: $args = array( ‘role’ => ‘Subscriber’, ‘meta_query’ => array( array( ‘key’ => ‘membership_class’, ‘value’ => ‘Full’, ‘compare’ => ‘=’, ‘type’ => ‘CHAR’, ), array( ‘relation’ => ‘OR’, array( ‘key’ => ‘first_name’, ‘value’ => explode( ‘ ‘, $usersearch ), ‘compare’ => … Read more
It’s not so difficult. All you have to do is to add a condition and check if the book_id param is passed. You can even check if this param is correct (for example if the book_id should be a number, then you can check if it is): add_filter( ‘rest_gallery_query’, function( $args ) { if ( … Read more
Custom meta boxes store values in the same way as custom fields, they just have a prettier UI. You shouldn’t need to modify your query in anyway other than knowing the key under which the custom meta box stores it’s values. If you’re using a plugin to generate the custom meta box, you’ll have to … Read more
It might be possible to achieve this by using the post clauses filters and rewriting the generated SQL query. You can also run 3 queries, One very lean query to get the desired posts from the date_query One very lean query to get all the posts from the meta_query One final query to get the … Read more
Found the error: $args = array( “posts_per_page” => 12, “paged” => $paged, “post_type” => array( “event”, “post” ) , “post_status” => “publish”, “meta_key” => “_thumbnail_id”, ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘event_start’, ‘value’ => date(“Y-m-d H:i:s”) , ‘compare’ => ‘>=’, ‘type’ => ‘DATETIME’ ) , array( ‘key’ => ‘event_start’, ‘compare’ => ‘NOT … Read more
The default relation for a meta query is AND, so when you have two conditions they will be treated as such: $meta_query[] = array( ‘key’ => ‘_stock’, ‘value’ => ‘0.000000’, ‘compare’ => ‘NOT IN’ ); $meta_query[] = array( ‘key’ => ‘_backorders’, ‘value’ => ‘no’, ‘compare’ => ‘!=’ ); Get all products with a _stock meta … Read more
Expanding a bit on the answer from @dgarceran Generally, using the WP_Query class is probably a good idea for querying posts. We’ll want to pass arguments to that query. In your case we’ll likely want use one of the following: “Custom Field Parameters” – meta_query “Taxonomy Parameters” – tax_query For a nearly comprehensive example of … Read more
Complex meta queries with a large number of meta values to find can be slow. Each meta key you query for generates one more JOIN in the query, and if you have a large database, it can be slow. You can try few things: Optimize your database tables, it is possible that you have a … Read more
So after @Nicolai found that blurb in the WP source confirming that I can’t use multiple parameters in the orderby if I am ordering by relevance I had to go a different route. However, this route only works if I don’t care for pagination. There probably is a way to put it back, but I’m … Read more
I’m not 100% certain what specific order you’re asking for, but you just need to assign an associative array to the ‘orderby’ value. Here’s an example: $args = array( ‘post_type’ => ‘brands’, ‘meta_query’ => array( array( ‘key’ => ‘br_type’, ‘value’ => ‘Aviation’ ), array( ‘key’ => ‘br_category’ ), array( ‘key’ => ‘br_name’ ) ), ‘posts_per_page’ … Read more