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
It helps to write problems down. After I haven’t used pre_get_posts extensively, I focused too much on that area for the cause, but it was the if clause. Changed to if ( ! is_admin() && $query->is_main_query() && ! is_post_type_archive( ‘cpt’ ) ) { return $query; } elseif ( ! is_admin() && $query->is_main_query() && is_post_type_archive( ‘cpt’ … Read more
If you have a “natural” artwork archive (typically setting has_archive to true in your register_post_type() arguments), you already have the functionality in place: http://example.com/artwork/?s=query …assuming artwork is your archive slug, WordPress will search only artwork for “query”. Just set the action attribute of the search form to the archive URL, like so: <form action=”<?php echo … Read more
The sticky posts are prepended on the first paginated part of the home page, so try this: add_action( ‘pre_get_posts’, function( $q ) { if ( $q->is_home() && $q->is_main_query() && $q->get( ‘paged’ ) > 1 ) $q->set( ‘post__not_in’, get_option( ‘sticky_posts’ ) ); } ); to remove it from the other paginated parts of the home page.
I don’t suspect that your tax_query is failing you, but actually your tag parameter is. single_tag_title() returns the name of the tag, not the slug. All tag and category queries are converted to a tax_query in the WP_Query class before being passed to the WP_Tax_Query class to build the relative string for the SQL query. … Read more
After some more testing it became apparent that the results weren’t in fact doing natural sorting. I made a few changes. It’s ugly… but it works. Okidokes, so I wasn’t able to get this to sort the way I wanted using WordPress’ sorting functions so I did go the usort route, and I think it … Read more
As @Milo suggested and also codex documented it is_main_query Under_the_Hood This function is an alias for the method WP_Query::is_main_query(). In filter or action hook callbacks that are passed the WP_Query object, such as pre_get_posts, it is circular to call this function. Instead, directly call the passed object’s method. For example, if your filter callback assigns … Read more
We could try to use the the_posts filter, that’s applied on the queried posts, if the suppress_filters query variable is false, to collect relevant post IDs. We can then use the pre_get_posts hook, in each query, to exclude the accumulated array of post IDs. Here’s a schema example for the process: // Main query $wp_query … Read more
You seems to assume that it would grab archive for first of multiple post types. But why? Order in this case does not indicate any kind of priority. WP seems to consider that logical as well. If you take a look at get_archive_template() the individual template will only be considered if there is only one … Read more
I answered my own question I just implemented it wrong when testing it on my end (mis-typed the taxonomy). This is correct: // Change the number of posts that show up on the taxonomy template function custom_tax_post_count ( $query ) { if (($query->is_tax(array(‘taxonomy_1’, ‘taxonomy_2’)) )) $query->set( ‘posts_per_page’, ‘-1’ ); } add_action( ‘pre_get_posts’, ‘custom_tax_post_count’ );