I think this would be easier if you had the performance_datetime custom field, because that could simplify your meta query. The following is just a demo fun for you to play with: As far as I understand the problem, you get three INNER JOINS on the wp_posts table, namely wp_postmeta, mt1 and mt2. But the … Read more
The solution is to use: ‘taxonomy’ => ‘meal’, ‘field’ => ‘slug’, ‘terms’ => ‘breakfast’ The taxonomy and terms are obvious, but why does field have to be slug? When you add taxonomy parameters, you can specify what ‘breakfast’ is– via the field. It could be the term’s ID, the full name, or slug. See the … Read more
I call it when I render a metabox on the edit page. ( Yeah, you shouldn’t be using globals in this context – use a foreach loop instead: function get_available_attachments( $post /* This is the post object being edited */ ) { $attachments = []; $attach_query = new WP_Query([ ‘post_type’ => ‘attachment’, ‘post_status’ => ‘inherit’, … Read more
Technically you can merge things into loop, by manipulating its posts field (such as $wp_query->posts for main query). WP has it in public for visibility and access, as it tends to. However it’s not that common technique, less so if you are considering injecting something that is not actually posts. It is more common for … Read more
There is no order_by. Change order_by to orderby and it should work. The default value of compare is = so it is unnecessary, you can remove it. Also, you should specify type of the meta_value if it is a specific type rather than the default CHAR.
You can use custom filters in $args (not tested) add_filter( ‘posts_where’, ‘find_by_title_filter’, 10, 2 ); function find_by_title_filter( $where, &$wp_query ) { global $wpdb; if ( $find_title_arg = $wp_query->get( ‘find_title’ ) ) { $where .= ‘ AND ‘ . $wpdb->posts . ‘.post_title LIKE \’%’ . esc_sql( $wpdb->esc_like( $find_title_arg ) ) . ”; } return $where; } … Read more
It’s a little hard to think in meta_query code for complicated case like this and without access to data. 🙂 What you have working can be expressed as two following conditions: start_date BETWEEN event_begin and event_end end_date BETWEEN event_begin and event_end Your first case with both in between seems irrelevant, since these two will catch … Read more
Boohoo why did I start a bounty for that 😉 The answer is pretty simple – add ‘type’ => ‘numeric’ to the meta query. array(5) { [“posts_per_page”]=> int(6) [“orderby”]=> array(2) { [“uss_product_price”]=> string(4) “DESC” [“uss_product_weight”]=> string(4) “DESC” } [“meta_query”]=> array(3) { [“relation”]=> string(3) “AND” [“sortprimary_clause”]=> array(3) { [“key”]=> string(17) “uss_product_price” [“compare”]=> string(6) “EXISTS” [“type”]=> string(7) … Read more
The timing of relevant parts of the process is following: Query executes and fetches posts (or in this case no posts) template_redirect fires Template file is determined from query variables and loaded When you change query variables in template_redirect you change template choice (which you observe), but you still have no posts in query. The … Read more
how to write a WP_Query that returns the custom field data This is not typically necessary. You can simply access meta data for each post in query individually (as you do already). You can also iterate through query more than once in a page (it rewinds to start automatically, that’s what while( have_posts() ) part … Read more