I have this weird pagination bug in Django: using object_list
as a return of a view, but passing a "paginate_by" argument to it, it's repeating some of the results; Otherwise, if I remove the argument or set as paginate_by=None
, the results are correct.
If using pagination, the quantity of results is maintained at a total, so, because there are repeated results, the last results are left out of the list, so they don't appear in the template.
Any ideas of what might be happening?
I had this problem also, but found a solution.
The problem was that i sorted the dataset by date. When i had multiple records with the same date, pagination showed wrong records.
What i did was i added another searchfield, id, so that the sortcriteria was unique for every record. And then it worked!
Before:
self.filtered_nesgames = self.filtered_nesgames.order_by('releasedate')
After:
self.filtered_nesgames = self.filtered_nesgames.order_by('releasedate', 'id')
HTH
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With