‘meta_key’ => ‘keyname’ must be part of the query to be able to sort by its value. Unfortunately, that will immediately result in the query being limited to posts where the key is set (its value can be empty, but it must exist). Hence, either consider the method s_ha_dum linked to in the question comments, … Read more
You will need to create two queries. The first will be one that pulls all of the custom post types in the search query. $args = array( ‘post_type’ => YOUR-POST-TYPE, ‘posts_per_page’ => ‘-1’, ‘s’ => get_search_query(), ); $sort_query = new WP_Query($args); $included_results = array(); You will then have to probably print out your results so … Read more
Just unsetting the cat variable probably isn’t enough. The pre_get_posts hook happens after the query variables have already been parsed. So there’s probably a tax_query with the taxonomy = category and the terms = your category. You’re already dumping the $query in your code, presumably for debugging. So, look at what you’re actually dumping. Do … Read more
The hooks you are looking for can be found in the WordPress Codex WP_Query – Filters: Filters posts_distinct – Alters SQL ‘DISTINCTROW’ clause to the query that returns the post array. posts_groupby – Alters SQL ‘GROUP BY’ clause of the query that returns the post array. posts_join – Alters SQL ‘JOIN’ clause of the query … Read more
Your can use the “meta_query” argument of the query, I think is better than filter the post_where: add_action( ‘pre_get_posts’, ‘bbwp_calendar_visible_events’ ); function bbwp_calendar_visible_events( $query ) { $postType=”bbwp_calendar”; if ( !is_admin() && $query->is_main_query() ){ if ( is_post_type_archive( $postType ) ) { $meta_query = array( ‘relation’ => ‘OR’, //current time <= event_end_date array( ‘key’ => ‘event_end_date’, //Check … Read more
This is an overly complicated approach. pre_get_posts will work for any query and there are numerous ways to control when/how the callback behaves: Add and remove the callback: function dummy_action($q) { } add_action(‘pre_get_posts’,’dummy_action’); $q = new WP_Query( array( ‘post_type’ => ‘post’ ) ); remove_action(‘pre_get_posts’,’dummy_action’); Use a self-removing callback: function dummy_action($q) { remove_action(‘pre_get_posts’,’dummy_action’); } add_action(‘pre_get_posts’,’dummy_action’); $q … Read more
Unfortunately there is no post_status__not_in query argument, but you can simply query for all statuses other than trash & draft: $stati = array_keys( get_post_stati() ); unset( $stati[‘trash’], $stati[‘draft’] ); $stati = array_flip( $stati ); $query->set( ‘post_status’, $stati );
Depending on your timeline or how much you want to live on the edge, there were some great improvements that are set to be introduced to 4.1 that I think will allow you to do just what you’re looking to do. If you want to live on the edge a little, you could develop with … Read more
Before amending $query we first have to find out which posts to exclude, which requres two querys (if I can think of a way of doing it in one I’ll update the answer). The first will grab a list of distinct ID’s of all parent events, for example – SELECT DISTINCT wp_posts.post_parent FROM wp_posts WHERE … Read more
After hours of searching and testing I finally came to a solution. This code and SQL shows events with a parent id of 0 and is ordered by the dates of child events. Raw SQL cannot be used to replace the default way WP queries the database but there are always some kind of workaround … Read more