Order of records changes when reloading with same sorting

[lucianholt97]

Having multiple records with the same value in the column that I am ordering by, it occurs that they jump and change their place when I reload the data.

I would suggest, that you implement sorting by id as the second parameter in order to keep the sorting identical on reload. Otherwise, it looks very strange.

[lindyhopchris]

Yes good suggestion. To confirm, are you using the StandardStrategy, i.e. page-based pagination?

[lucianholt97]

Thanks for the quick reply. Yes, I am using page-based pagination.

[lindyhopchris]

Just for reference, this is a useful article on this issue:
https://tighten.co/blog/a-cautionary-tale-of-nondeterministic-laravel-pagination

Will be pushing a fix soon.

[lindyhopchris]

@lucianholt97 I've pushed a branch called issue313. Can you give it a go to check that it solves your problem?

$ composer require cloudcreativity/laravel-json-api:dev-issue313

[lucianholt97]

I am sorry for the late response. The branch issue313 works for me 👍

[lindyhopchris]

Great thanks for confirming. I'll get it merged into develop when I have time and release 1.1.0.