framework
framework copied to clipboard
[DataGrid] Sorting by nullable values makes filter by records
Description
In case when you need sorting in DataGrid by nullable field I've detected that Sorter uses INNER JOIN on building Select Query.
If values are nullable this moment reduces amount of records.
Sorting mustn't reduce records amount
How To Reproduce
Make any simple table with nullable field. For example it can be updatedBy. This field will be changed only after update.
Insert some records with different values in this field.
Prepare grid and add sorting by updatedBy field
Additional Info
| Q | A |
|---|---|
| Framework Version | 2.7.8 |
| PHP version | 7.4.16 |