Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[DataGrid] Sorting by nullable values makes filter by records #30

Open
Eugentis opened this issue Apr 27, 2021 · 0 comments
Open

[DataGrid] Sorting by nullable values makes filter by records #30

Eugentis opened this issue Apr 27, 2021 · 0 comments
Labels
bug Something isn't working

Comments

@Eugentis
Copy link

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 Eugentis added the bug Something isn't working label Apr 27, 2021
@butschster butschster transferred this issue from spiral/framework Aug 30, 2022
@SerafimArts SerafimArts removed their assignment Aug 30, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants