The Codex lists all of the comparison options on the WP_Query page. If you want events with a start date BETWEEN a range of dates, OR events with an end date BETWEEN a range of dates, something like this should work – ‘relation’ => ‘OR’, array( ‘key’ => ‘event_start_date’, ‘value’ => array( $beginning_of_range, $end_of_range ), … Read more
I have not used ACF before but i suspect your post-2.php lacks $post_id as in have_rows($field_name, $post_id)(see). If you are using ajax there is no way that your ajax function know the page you are on and what post you are seeking so you better use $post_id to tell ajax function which post data you … Read more
First, you are setting $_GET[‘filterN’] but you are trying to use $_GET[‘condition_N’]. That is not ever going to work right. Secondly, pagename is an “exact match” value, not a search parameter, and it only works with the “Page” post type (at least so far as I can tell). You are using a CPT and, presumably, … 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
Edit – This answer is no longer accurate for the current version of ACF, see their documentation Use the acf_save_post hook. function my_acf_save_post( $post_id ) { // vars $fields = false; // load from post if( isset($_POST[‘fields’]) ) { $fields = $_POST[‘fields’]; } // … } // run before ACF saves the $_POST[‘fields’] data add_action(‘acf_save_post’, … Read more
There are similar posts on this site about the same topic, if you look around. But here is your answer: To make this work you need to change your date format. You can sort alphabetically, or numerically, not calender-merically. The only human date format that orders correctly is YYYY/MM/DD. The separator are optional and shouldn’t … Read more
I had the same question a couple of weeks ago. Here’s what I did to make it work for me. How Do I Use WP_Query to Run This Database Query as Search Result? If you’ll read through my answer that I posted for reference’s sake, you’ll see that I ended up adding a filter add_filter(‘post_request’,’your_function_name’); … Read more
Fields added by PHP are not shown in the Dashboard. Recently, I came across this post in the User Submitted Fields section of ACF forums: PHP Recovery Tool. The author posted a plugin in GitHub, Advanced Custom Fields Recovery Tool from PHP Export. Haven’t tested, though. Use this plugin to import fieldsets from PHP exports. … Read more
I discovered the problem by inspecting the actual SQL created by WP_Query. I realized that the generated SQL query has 2 INNER JOINs, one for the meta_key and another for the actual meta_query. Basically on one hand it is filtering those films that have a showings_%_start_datetime in the next seven days, and on the other … Read more
To follow up on @rock3t’s comment, do you really have to query the backend whenever a user clicks on a column header? Have you looking into using the jQuery tablesorter? It allows an end-user to sort an HTML table by doing DOM manipulations. I’ve never used it in a WP project, but I have used … Read more