Support

Account

Home Forums General Issues Alter pagination of an existing query to go by a custom field Reply To: Alter pagination of an existing query to go by a custom field

  • Ok figured out the problem. In case anyone is dealing with similar issues:

    		if ( isset( $query->query_vars['post_type'] ) && ( 'post' === $query->query_vars['post_type'] || is_single() ) ) {
    			$query->set( 'orderby', 'meta_value' );
    			$query->set( 'meta_key', 'event_start' );
    			$query->set( 'order', 'ASC' );
    			$query->set( 'paged', get_query_var( 'paged' ) );
    			$query->set( 'posts_per_page', get_option( 'posts_per_page' ) );
    			$query->set( 'meta_query', array(
    				'relation' => 'AND',
    				array(
    					'key'     => 'event_start',
    					'compare' => '>=',
    					'value'   => date( 'Y-m-d H:i:s', strtotime( '-8 hours' ) ),
    					'type'    => 'DATETIME',
    				),
    			) );
    		}
    		return $query;

    Only paged and pages_per_page had to be added. Now it is working proplery.