Infinite scroll – help with offset when using meta_query parameter

I’ve tried different calculations for the offset using found posts in the calculation, but I can’t work it out.

I use the WordPress custom loop to it’s fullest using $the_query = new WP_Query( $loop_args );
So I will try and push infinite scroll to its limits 🙂 It is all working fine though except for that incorrect offset for my meta_query rating range. The date_query (which is similar to the meta_query parameter) which shows posts between a date range is working with the correct offset.

I’m currently just using the infinite_scroll_query_args filter to get the correct offset for the rating range:

// show events with at least a rating of 1
function hp_jetpack_infinite_scroll_query_args( $args ) {
        $args['post_type'] = 'event';
	$args['meta_query'] = array(
	       array(
			'key' 		=> 'rating_count',
			'value' 	=> 1,
			'compare' 	=> '>=',
		)
	);	
 
    return $args;
}

add_filter( 'infinite_scroll_query_args', 'hp_jetpack_infinite_scroll_query_args', 100 );

Once I get that rating range working correctly, my full infinite scroll filter looks like this:

function hp_jetpack_infinite_scroll_query_args( $args ) {

	// defaults
	$args['post_type'] = 'event';
	$args['orderby'] = 'date';
	$args['order']   = 'DESC';
			
	// User control loop Filters
	if( hp_is_url_query_string() ) {

		// Type (post type)
		if( hp_query_string( 'type' ) ) {
			$args['post_type'] = hp_get_sanitized_url_query_string_type_value();
		}
			
		// Search term
		if( hp_query_string( 's' ) ) {
			$args['s'] = get_search_query();
		}
		
		// Event category (taxonomy)
		if( hp_query_string( 'event_category' ) ) {
			$args['event_category'] = hp_get_sanitized_url_query_string_event_category_value();
		}

		// Order by date posted
		if( hp_query_string( 'orderby', 'newest' ) ) {	
			$args['orderby'] = 'date';
			$args['order']   = 'DESC';
			
			// bug fix
			$paged = (int)$_POST['page'] + 1;
			$args['paged'] = $paged;
		}
		
		// Order by comment count
		if( hp_query_string( 'orderby', 'comment_count' ) ) {	
			$args['orderby'] = 'comment_count';
			$args['order']   = 'DESC';
			
			// bug fix
			$paged = (int)$_POST['page'] + 1;
			$args['paged'] = $paged;
		}
		
		// Order by Rating
		if( hp_query_string( 'orderby', 'rating' ) ) {	
			$args['meta_key'] = 'rating_count';
			$args['orderby'] = 'meta_value_num';
			$args['order']   = 'DESC';
			
			// bug fix
			$paged = (int)$_POST['page'] + 1;
			$args['paged'] = $paged;
		}
		
		// Order by view count
		if( hp_query_string( 'orderby', 'view_count' ) ) {	
			$args['meta_key'] = 'view_count';
			$args['orderby'] = 'meta_value_num';
			$args['order']   = 'DESC';
			
			// bug fix
			$paged = (int)$_POST['page'] + 1;
			$args['paged'] = $paged;
		}

		// Date range
		if( hp_query_string( 'after' ) || hp_query_string( 'before' ) ) {
			$args['date_query'] = array(
				array(
					'after'     => hp_get_sanitized_url_query_string_after_value(),
					'before'	=> hp_get_sanitized_url_query_string_before_value(),
				)
			);
		}

		// rating range - Bug, incorrect offset
		if( hp_query_string( 'rating' ) ) {
			$args['meta_query'] = array(
				array(
					'key' 		=> 'rating_count',
					'value' 	=> hp_get_sanitized_url_query_string_rating_value(),
					'compare' 	=> '>=',
				)
			);
		}		
	}
 
    return $args;
}
add_filter( 'infinite_scroll_query_args', 'hp_jetpack_infinite_scroll_query_args', 100 );

I now know there is at least 2 things that is affecting the offset of my meta_query rating range:

1. the posts_per_page set in admin. If I set this to 1 post per page, there will be no offset which means I can use the same bug fix used on the orderby parameter.

2. The other thing affecting the offset is the total posts of the post type (not the found posts).
So if the wp_count_posts( 'your_post_type' )->publish is much higher than the: $wp-query->found_posts; There will be no offset, which means I can add the same bug fix used on the orderby parameter.

I don’t know if you can work out a fix for this based on this information.

• This reply was modified 9 years, 5 months ago by Andrew.