Our implementation of pagination assumes that the database will always generate the same order of items from which the requested slice (offset + limit) are then returned. This works well when sorting by
id column (usually default), but not so well when other fields are involved. See https://staging.ggce.genesys-pgr.org/t/species and sort by
Name Verification Date. Then hit "Reload" button and observe that different order of records is returned.
To ensure the proper ordering of items and their slicing (offset + limit) the
id column must always be included as the last of the
Sort fields (
order by ..., id asc) for page requests to the database.