The culprit The culprit of the matter is meta queries not supporting different and/or nested relations – a shortcoming by the way, that has driven me nuts before as well. In a recent instance with a search scenario also. What you want to do simply cannot be accomplished with WP_Query as well as one loop … Read more
That massive function was a bit scary, I got this working like so – with two arguments (that exclude the features) $args = array( ‘meta_query’ => array( ‘relation’ => ‘OR’, array( // new and edited posts ‘key’ => ‘Set as Featured Post’, ‘compare’ => ‘!=’, ‘value’ => 1 ), array( // get old posts w/out … Read more
You can create groups of meta_queries using specific compare operation on them, and since you want to order based in a single custom field, you can keep the order declaration dedicated to the single meta field. So: $q = new WP_Query( array( ‘meta_key’ => ‘population’, //setting the meta_key which will be used to order ‘orderby’ … Read more
Getting posts without a certain meta key is a little tricky, namely due to the database design and the nature of SQL joins. AFAIK, the most efficient way would be to actually grab the post IDs that do have the meta key, and then exclude them from your query. // get all post IDs that … Read more
This is a simple mathimatical problem. You will indeed need access to both your longitude and latitude, so save it in a metafield. than you will have to query your posts like this as a sql query. Haven’t got a chance to test it. and or pour it into wordpress. Don’t have access to my … Read more
There are different way to do the trick, 2 comes into my mind: use a complete custom $wpdb query use WP_Query with filters, using WP_Meta_Query to build the additional sql I’ll post here sample code for case #2 /** * Run on pre_get_posts and if on home page (look at url) * add posts_where, posts_join … Read more
If we define the conditions: A: my_custom_field_ignore EXISTS B: my_custom_field_ignore = 1 then NOT ( A && B ) is equivalent to: NOT ( A ) || NOT ( B ) meaning in our case: ( my_custom_field_ignore NOT EXISTS ) || ( my_custom_field_ignore != 1 ) We could therefore try the following for WP 3.5+ … Read more
You could try the REGEXP version: ‘meta_query’ => array( array( ‘key’ => ’email_address’, ‘value’ => ‘^hello@’, ‘compare’ => ‘REGEXP’, ) ) where ^ matches the beginning of a string. You can check the MYSQL reference on REGEXP here for more info. Notice that these are the possible values of the meta compare parameter: ‘=’, ‘!=’, … Read more
I’ve come across this problem and it seems MySQL doesn’t deal well with the multiple joins to the same table (wp_postmeta) and OR-ed WHERE that WP generates here. I dealt with it by rewriting the join and where as mentioned in the post you link to – here’s a version that should work in your … Read more
Adding a custom endpoint is pretty straightforward. I also modified the url to look more like http://example.com/wp-json/namespace/v2/posts?filter[meta_value][month]=12&filter[meta_value][year]=2015 function wp_json_namespace_v2__init() { // create json-api endpoint add_action(‘rest_api_init’, function () { // http://example.com/wp-json/namespace/v2/posts?filter[meta_value][month]=12&filter[meta_value][year]=2015 register_rest_route(‘namespace/v2’, ‘/posts’, array ( ‘methods’ => ‘GET’, ‘callback’ => ‘wp_json_namespace_v2__posts’, ‘permission_callback’ => function (WP_REST_Request $request) { return true; } )); }); // handle the request … Read more