#Issues with inconsistent table sorting with records having the same value for the sorted column

2 messages · Page 1 of 1 (latest)

dull pewter
#

When sorting a Filament Table it appears to somehow randomise the results order within the records that have the same value that is being sorted.

Say I sort on column X and records 1 to 3 have the same db value for column X, the order of records 1, 2 and 3 themselves when sorting seems randomised between 1, 3, / 3, 2, 1 / 1, 3, 2 etc. everytime when the table is "refreshed", for instance when toggling a ToggleColumn or paginating. I also don't see an "in" to add a orderBy('id') as fallback (last orderBy after every query) as this would fix it.

Anyone else experienced and solved this somehow?

lucid currentBOT
#

To help others find answers, you can mark your question as solved via Right click solution message -> Apps -> ✅ Mark Solution