framework icon indicating copy to clipboard operation
framework copied to clipboard

[DataGrid] Sorting by nullable values makes filter by records

Open Eugentis opened this issue 4 years ago • 0 comments

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

Eugentis avatar Apr 27 '21 08:04 Eugentis