You cannot replace the main query with the output of $wpdb. The main query is a WP_Query object. $wpdb returns a simple array or object, but not a WP_Query object. Even if you could shove raw SQL into a query (something in the back of my head makes me think you can but I can’t … Read more
You’ve specified a priority of 1 for your pre_get_posts function here: add_action( ‘pre_get_posts’, ‘mytheme_portfolio_archive_pages’, 1 ); Jetpack doesn’t specify a priority: add_action( ‘pre_get_posts’, array( $this, ‘posts_per_page_query’ ) ); So that gets added with the default priority for add_action, which is 10: $priority (int) (optional) Used to specify the order in which the functions associated with … Read more
pre_get_posts runs for every query. That includes the main query, secondary queries, and menus. The problem is that is_post_type_archive(array(‘provider’)) is checking if the main query is the post type archive, not a specific query going through pre_get_posts. So when you check for that and then modify the current query going through pre_get_posts you’re going to … Read more
Maybe a bit late … add_action( ‘pre_get_posts’, function($query) { if ( !is_admin() && $query->is_main_query() && is_post_type_archive( ‘[your_post_type]’ ) ) { $query->set(‘meta_query’, array( ‘_property_price’ => array( ‘key’ => ‘_property_price’, ), ‘_property_featured’ => array( ‘key’ => ‘_property_featured’, ) )); $query->set(‘orderby’,array( ‘_property_price’ => ‘DESC’, ‘_property_featured’ => ‘DESC’ )); } return $query; } );
Try using meta_query parameter : add_action(‘pre_get_posts’, ‘add_event_date_criteria’); function add_event_date_criteria(&$query) { // We only want to filter on “public” pages // You can add other selections, like here: // – Only on a term page for our custom taxonomy if (!is_admin() && is_tax(‘event-tag’) || is_tax(‘event-category’)) { $time = time(); $meta = array( array( ‘key’ => ‘start_time’, … Read more
pre_get_posts is executed before each and every query. Your $query->is_main_query() is making this code change the query only for the Main query. So, if you’re in an archive page, you’re modifying only the archive posts, and not any of the others queries (widgets, menus, etc). But be aware, that code you added there will change … Read more
@Howdy_McGee – Thanks for pointing me in the right direction. Below is the code I used. By the way, I know that the FacetWP plugin can be a little particular with queries. In case anyone is wondering, this works with it. function set_posts_per_page_for_attorneys_cpt( $atty ) { if ( !is_admin() && $atty->is_main_query() && is_post_type_archive( ‘attorneys’ ) … Read more
Finally found out using two (single) posts metas : likes_log where I keep up to date an array where each entry is the time the item was liked. Entries are removed if they are too old (here, >1 month) likes_log_count where I update the number of entries in the previous log. function update_likes_monthly_count(){ if ( … Read more
You could use the WooCommerce filter woocommerce_shortcode_products_query to change/manipulate the query arguments. This example comes from the shortcode documentation. When using the Products shortcode, you can choose to order products by the pre-defined values above. You can also sort products by custom meta fields using the code below (in this example we order product by … Read more
As mentioned in the comments you an issue in your meta query, as you set the key to 20161126 or similar. Instead key should be filled with your meta key post_end_date. Meta query also support multiple arrays to combine your query to also include posts where the meta key is not set. The example would … Read more