WP_Query selects posts and not meta value that is way you are not getting the value. You can use the returned post ID to get the value something like: $args = array( ‘post_type’ => ‘post’, ‘post_status’ => ‘publish’, ‘posts_per_page’ => 1, ‘meta_key’ => ‘picture_upload_1’ ); $dbResult = new WP_Query($args); global $post; if ($dbResult->have_posts()){ $dbResult->the_post(); $value … Read more
1) Using only the posts_orderby filter: It looks like you want to order the movies by the minimum of the wpcf-showtime meta values. You can modify the ORDER BY part of the SQL generated by the WP_Query, by using the posts_orderby filter. Here’s an example: add_filter( ‘posts_orderby’, ‘wpse_posts_orderby’ ); $ongoing_movies = new WP_Query( $args ); … Read more
You might need a 180° solution here 😉 Think about the problem once more and try this: As a visitor I can filter by color and size. So your solution might be: … JOIN … (A) … (B) … (C) WHERE (A.meta_key = ‘color’ AND A.meta_value=”red”) OR (B.meta_key = ‘color’ AND B.meta_value=”blue”) … AND (C.meta_key … Read more
You should be able to use the meta_query attribute that uses WP_Meta_Query behind the scenes: $child_categories = get_categories( array( ‘parent’ => $cat_id, ‘orderby’ => ‘id’, ‘order’ => ‘DESC’, ‘hide_empty’ => ‘0’, ‘meta_query’ => array( array( ‘key’ => ‘mykey’, // Adjust to your needs! ‘value’ => ‘myvalue’, // Adjust to your needs! ‘compare’ => ‘=’, // … Read more
Update – it may be supported in a meta_query. I need more information – see below. You can’t do it using a meta_query, it’s not supported. Do you have data in meta_data fields? – WordPress queries will exclude posts where any of the orderby (or meta_query) fields is missing. WordPress adds a join condition to … Read more
Is this possible via query args? I don’t think so. Is this possible via ‘posts_where’? It is probably doable using some ‘posts_*’ filters, not only with ‘posts_where’. Or maybe using ‘posts_request’ filter to completely oveeride the query. Do I need to run a separate query and then somehow merge the results? That would be the … Read more
I’ve spent hours of research and found the solution a few minutes after writing this question: $args = array( ‘post_type’ => ‘attachment’, ‘post_status’ => ‘inherit’, <<– IMPORTANT ‘meta_query’ => array( array( ‘key’ => ‘medientyp’, ‘value’ => ‘Video’ ) ) ); $query = new WP_Query($args);
Introducing STR_TO_DATE MySQL has a STR_TO_DATE function that you could leverage for the scope. To use it you need to filter the WHERE clause of a WP_Query, probably using posts_where filter. That function allows to format a column value as a date by using a specific format. By default, WordPress uses the CAST MySQL function … Read more
Try an array of arrays in your meta query. $args = Array( ‘post_type’ => ‘event’, ‘posts_per_page’ => -1, ‘meta_key’ => ‘event_date’, ‘orderby’ => ‘meta_value_num’, ‘order’ => ‘ASC’, ‘meta_query’ => array( array( ‘key’ => ‘event_date’, ‘compare’ => ‘>=’, ‘value’ => intval(strtotime(date(‘Y-m-d’))), ‘type’ => ‘numeric’ ) ), ); $query = new WP_Query( $args );
The meta_query argument (that you can use in a WP_Query) is not enabled by default when using a WC_Order_Query through wc_get_orders() WooCommerce function. But for you can use the undocumented Custom Field Parameters (just like in a WP_Query): meta_key meta_value meta_value_num meta_compare So in your case you can use the following instead: $orders = wc_get_orders( … Read more