check if the $GET[‘rating’] is set ( isset($_GET[‘rating’]) or has any value. ( !empty($_GET[‘rating’]) if not, build the query fecthing all post without ‘meta_query’ for example: if ( (isset($_GET[‘rating’]) && !empty($_GET[‘rating’]) ) { // restrict $meta[] = array(( ‘key’ => ‘rating’, ‘value’ => $_GET[‘rating’] ); } if ( (isset($_GET[‘tax’]) && !empty($_GET[‘tax’]) ) { $meta[] = … Read more
Using your constructed array, I think this is the correct syntax: $meta_query_args = array( ‘meta_key’ => ‘price’, ‘meta_value_num’ => 1000, ‘meta_compare’ => ‘<=’, ‘meta_query’ => array( ‘relation’ => ‘OR’, array( ‘key’ => ‘roomcount’, ‘value’ => 3, ‘type’ => ‘numeric’, ‘compare’ => ‘>=’ ), array( ‘key’ => ‘bathroomcount’, ‘value’ => 2, ‘type’ => ‘numeric’, ‘compare’ => … Read more
What I would do is create a query for the _EventStartDate with a custom ‘eventDisplay’. This will grab all events, ordered by the start date. Then, once you get into the loop; compare the start date to a specific date that you want to output. tribe_get_start_date() accepts a date format parameter (see here) that will … Read more
You will have to change your tax_query. The xs is not the term_id but the slug So your tax_query will end up being like ‘tax_query’ => array( array( ‘taxonomy’ => ‘pa_sizes’, ‘field’ => ‘slug’, ‘terms’ => ‘xs’ ) ) I would love to help with the “instock” problem too, but I’m stuck with that question … Read more
One problem with the query is that the self-join with the ambiguous WHERE gives you a crossed dataset (which is masked by the DISTINCT), so it would be simpler to use wp_post as a base to attach the joins that precisely match the keys, eg SELECT p.ID, key1.meta_value as prog_ongoing, key2.meta_value as prog_date_start FROM $wpdb->posts … Read more
The handy thing about how ACF stores dates as YYYYMMDD is you can treat them like integers and get a similar level of functionality as if you were using “true” dates. For example, to get all dates after 1st Jan 2011, use > 20110101. Those before June 1st 2012? < 20120601. And for your case, … Read more
As @Howdy_McGee suggested and I made a quick test. Removing key do the trick so you can just remove the key and add compare LIKE if you do not want exact match. Example:- $posts = new WP_Query(array( ‘meta_query’ => array( array( ‘value’ => ‘meta_value’ ) ) )); This will produce the SQL like WHERE 1=1 … Read more
array( ‘relation’ => ‘OR’, array( ‘key’ => ‘status’, ‘value’ => ”, //<— not required but necessary in this case ‘compare’ => ‘NOT EXISTS’, ), array( ‘key’ => ‘status’, ‘value’ => ‘new’, ‘compare’ => ‘=’, ), ); That should do it.
If you don’t use any other meta data, just add the following to your $args: ‘meta_key’ => ‘sold’, ‘meta_value’ => true, // or whatever it is you’re using here ‘meta_compare’ => ‘!=’, Otherwise, use a WP_Meta_Query: ‘meta_query’ => array( array( ‘key’ => ‘sold’, ‘value’ => true, // or whatever it is you’re using here ‘compare’ … Read more
I figured it out, meta_query must be an array within an array as it is intended for advanced queries using ‘relation’. meta_query => array ( array ( //’relation’ => ‘OR’, ‘key’ => ‘audio_file’, //The field to check. ‘value’ => ”, //The value of the field. ‘compare’ => ‘!=’, //Conditional statement used on the value. ), … Read more