Pagination duplicates appearing across multiple pages
Having a bit of an issue with the table builder.
I have some records, and I want my default sort to show ones which have a specific attribute set (it's a boolean), so I sort by that DESC so the true/1 values get placed first.
The issue is that because many records share a
true
true
value, they can appear over multiple pages as by default the pagination just uses
limit
limit
and
offset
offset
, and my MySQL database doesn't know what it has returned on the previous page.
Is there a good way of adding some extra levels of sorting in addition to the default sort / whatever the user has selected with multiple columns?