not sure if you’ll have tried this yet but you could consider grabbing the two sets of posts separately then merging them. Finally use get_posts to create a combined list sorted the way you want. Something like this might work for you (you may want to add in a posts per page argument to the … Read more
There is no official documented list of all possible post meta keys in core. The closest I could for anything unofficial was this answer on Stack Exchange: You probably don’t want to use the following post meta keys: _thumbnail_id – Used to store the featured image ID _edit_last – Used by the Heartbeat API _edit_lock … Read more
Note that the key in your orderby array needs to reference an array in meta_query which contains a direct key item, e.g. ‘key’ => ‘tdlrm_mp’. So for example, you should have used ‘tdlrm_mp_exists’ => ‘ASC’, and not ‘tdlrm_mp_key’ => ‘ASC’ in your $args[‘orderby’]. However, that wouldn’t actually sort the posts in the way you wanted … Read more
Checkbox field is stored as serialized array, therefore you can not use the IN operator and array with the values you are looking for. To get posts with checked “melbourne”, change meta_query to: $meta_query = array( array( ‘key’ => $name, ‘value’ => ‘”melbourne”‘, ‘compare’ => ‘LIKE’, ) ); To get posts with melbourne or sydney: … Read more
An IN query is not a string comparison query. It is more like a bunch of OR statements. … WHERE tablename.animal IN (‘cat’,’dog’,’ferret’) is going to be the same as …WHERE tablename.animal=”cat” OR tablename.animal=”dog” OR tablename.animal=”ferret” $_POST[‘_casestudypost’] is going to be an array, and if you stored it as a single value in postmeta it … Read more
Here is a rough outline of how you’d go about making a UNION work with WP_Query. add_filter( ‘posts_request’, function ($clauses) { $clauses = str_replace(‘SQL_CALC_FOUND_ROWS’,”,$clauses,$scfr); $scfr = (0 < $scfr) : ‘SQL_CALC_FOUND_ROWS’ : ”; $clause2 = $clauses; // manipulate this return “SELECT {$scfr} u.* FROM (({$clauses}) UNION ({$clause2})) as u”; }, 1, 2 ); Set up … Read more
Is there an easy way to do this without having to unserialize it? Not in any reliable way. You can certainly ORDER BY that value but the sorting will use the whole serialized string, which will give you technically accurate results but not the results you want. You can’t extract part of the string for … Read more
WordPress sets the php timezone to UTC for internal calculations. So at 4pm PST, date() will be producing a date that reads 10pm UTC. Hence the event is considered past. There are two ways to resolve this. (The preferred method) Store dates in the database in UTC. Handle all date calculations in UTC, and convert … Read more
That’s because ‘meta_key’ and ‘meta_value’ are not public query vars. In other words, you can’t use them in URLs directly, nor should you. Instead, register a specific query var, like so: function register_my_qv() { global $wp; $wp->add_query_var( ‘my_qv’ ); } add_action( ‘init’, ‘register_my_qv’ ); Then, you can go to a URL like this: ?my_qv=foobar All … Read more
First, just pass your arguments to the constructor of WP_Query as this is both cleaner, and the way you’re supposed to do it according to the Codex documentation of the class. You should be constructing things like this: $my_key_query_args = array( ‘post_type’ => ‘attachment’, ‘post_status’ => ‘inherit’, ‘meta_query’ => array( array( ‘key’ => ‘my_key’, ‘value’ … Read more