Thanks karpstrucking, This was a simple case of me needing to understand the Query better. Once I fully understood that wp_query returns a string for the sql query, it was a simply case of doing what I needed to do to correction the event_date value, concatenating on the additional title or meta_num_value and returning that. … Read more
In general this would make sense at pre_get_posts since you could just express conditions as meta query and let WP figure out SQL. In your specific case this won’t work, since that format is horrible for programmatic comparison. Unless you can change format to something more friendly, you will probably have to write some pretty … Read more
From the url you supplied it looks like you are using a custom post type of blog. The most likely reasons you are not seeing the post you want to display is that by default WP_Query is only set to display posts – see WordPress Codex on WP_Query Post & Page Parameters for more info. … Read more
I was having the exact same problem while querying post and pages, but also the jetpack-portfolio post type in my custom widgets. I was using $query = new WP_Query( $query_args ); in both cases. For me the fix was to change $query to $query_entries and $query_projects. It works as expected now. I see you’re already … Read more
Optimising specific Query with ACF meta objects
WP_Query with meta_value_num and meta_query not paged correctly
Geo location query inside wp_query?
thanks for responses, Allowed me to find correct answer which I’ve posted below – $tickets_for_user = get_posts(array( ‘post_type’ => ‘ticket’, ‘orderby’ => ‘meta_value_num’, ‘meta_key’ => ‘event_date’, ‘order’ => ‘ASC’, ‘posts_per_page’ => 1, ‘meta_query’ => array( ‘relation’ => ‘AND’, array( ‘key’ => ‘event_date’, ‘value’ => array($today,’20991231′), ‘compare’ => ‘BETWEEN’, ‘type’ => ‘DATE’, ), array( ‘key’ => … Read more
I found out the answer myself. There are other filters that let you adjust the query before it’s run: http://codex.wordpress.org/Plugin_API/Filter_Reference/posts_clauses The posts_clauses filter runs before the query gets executed and is essentially the sum of all filters that run immediately before it. Apart from posts_clauses, there are several more precise filters that modify only a … Read more
There’s an infinite number of approaches to this. Here’s a couple that come to mind: 1) You could easily use something like strpos() or a regular expression to see if $image[0] contains a keyword. This approach would be a little less than ideal in my opinion. 2) Add a checkbox or ‘tag’ field to the … Read more