WP_Query multiple value not working

This is waaaay after the fact, but maybe it’ll help someone else. You’re looking for an IN comparison here – where the value is IN a group of values. Here’s what it’d look like: $args[‘meta_query’][] = [ ‘key’ => ‘antivirus_antivirus_featured_scaning’, ‘value’ => [‘scheduled_scan’,’anti_spyware’,’anti_worm’], ‘compare’ => ‘IN’ ]; Read more about it here: https://developer.wordpress.org/reference/classes/wp_query/#custom-field-post-meta-parameters =]

How sort products by calculate value? ( custom post meta, price, option)

Firstly i added table postmeta to query function add_join_clause_to_view_sql( $join, $wpq ) { global $wpdb; if( $wpq->query[‘orderby’] === ‘price’ || $wpq->query[‘orderby’] === ‘price-desc’) { $post_meta_table_name = $wpdb->postmeta; $post_table_name = $wpdb->posts; $join .= ” LEFT JOIN $post_meta_table_name ON $post_meta_table_name.post_id = $post_table_name.id “; } return $join; } add_filter(‘posts_join’, ‘add_join_clause_to_view_sql’, 10, 2); Secondly i added meta_key in WHERE … Read more

WordPress Meta Query Null Values Order

Generally, no, there is not a good way to achieve this if the sort order doesn’t produce things automatically in the order you need them. This is because WP_Query doesn’t allow for insertion of logic to say ‘order by fieldX except if $some_condition’ Somewhere, you’re going to have to write the logic for the order … Read more