[Resolved] Duplication of Posts in Pagination

[Author]

Posts

[kristyR]

hidden link

When you click through the paginated results, some of the custom posts (Directory Listings) get repeated over and over rather than being only shown once in the results. It looks like its because of the random order sorting. Is there a way to make that apply to the entire set of posts rather than just the current page?

[Minesh]

Hello. Thank you for contacting the Toolset support.

As you set your view to order by the random order, even when you paginate and move from one page to another page, the query will be fired is, for example:
show posts from 11 to 20 order by random order.

And random order will fetch any posts randomly.

With every page of pagination, Views will query the database, and get the results in random order as the view is set to order by random order and that is why you see the duplicated items in each page. There is no workaround available, you will have to remove random order.

[kristyR]

We have paid listings (approximately 100, so its not user-friendly to have them all on one page) and need to display people in an equitable way.

With that format of random it means that some people are never shown while others are shown multiple times. The pagination becomes useless.

Is there any other way we can display search results in an equitable way?

[Minesh]

I think you should remove the order by random from your view's ordering section.

And use the following hook "wpv_filter_query_post_process" to randomize the found posts:
=> https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query_post_process

For example:
- Try to add the following code to "Custom Code" section offered by Toolset or to your theme's functions.php file:
=> https://toolset.com/documentation/programmer-reference/adding-custom-code/using-toolset-to-add-custom-code

add_filter( 'wpv_filter_query_post_process', 'func_randomize_found_posts', 10, 3 );
 function func_randomize_found_posts( $query, $view_settings, $view_id ) {
    if ( $view_id == 9999 ) { 
         
        $query->posts  =   shuffle($query->posts);
        
    }
    return $query;
}

Where:
- Replace 9999 with your original view ID.