OK, After a lot of trial and error and asking around I managed to finally get a working solution. Thought I would post it here for those that are trying to fix a similar problem in the future. Filter 1: posts_join creates a left join on all queries to link up the postmeta table. Its … Read more
sort by date in Advanced Custom Field
What about using just get_posts (removing the order_by argument), then looping through to create and array of programs, then building the output from that: $posts = get_posts(array(‘post_type’=>’programas’,’meta_key’=>’audio_date’)); $programs = array(); foreach ($posts as $post) { $days = get_post_meta( $post->ID, ‘audio_date’, true ); // $time = get_post_meta( $post->ID, ‘audio_time’, true); $found = false; foreach ($days as … Read more
How to make a WP REST API query with meta_query in WP4.7?
WP_Meta_Query causing long-running MySQL queries
you can write like for this. ‘meta_query’ => array( array( ‘key’ => ‘_age_from’, ‘value’ => sanitize_text_field( $_REQUEST[‘age_from’] ), ‘compare’ => ‘>=’, ‘type’ => ‘NUMERIC’ ), array( ‘key’ => ‘_age_to’, ‘value’ => sanitize_text_field( $_REQUEST[‘age_to’] ), ‘compare’ => ‘<=’, ‘type’ => ‘NUMERIC’ ) );
Multiple meta queries but arrange by specific meta value order
As you will probably want to eventually do some reporting on the data, e.g. print a temperature average from this month last year in area X, I’d opt for custom tables from the beginning. I’m saying tables, because I don’t see a reason why you wouldn’t put the locations into a custom table as well. … Read more
How to show recent and upcoming birthdays using meta_query
Can an array be used as a meta_query value?