Skip to content

Improve the handling of empty values in database multi-field sorting #10758

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.

Sign up for GitHub

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

Jump to bottom
Closed
TCOTC opened this issue Mar 26, 2024 · 5 comments
Closed

Improve the handling of empty values in database multi-field sorting #10758

TCOTC opened this issue Mar 26, 2024 · 5 comments
Assignees
@88250
Labels
Enhancement
Milestone
3.0.6

Comments

@TCOTC
Copy link
Contributor

TCOTC commented Mar 26, 2024 •
edited by 88250
Loading

改进数据库多字段排序包含空值处理

In what scenarios do you need this feature?

目前数据库多字段排序时，包含空字段的行是不参与排序的。但数据库不可能每行每个用来排序的字段都填满

image

Describe the optimal solution

包含空字段的行应该按条件先后参与排序，先满足前一个排序条件，再满足后一个排序条件，依次满足，直到包含空字段时置底

比如在 Notion 中是参与排序的：

image

Describe the candidate solution

No response

Other information

关联：数据库多列排序功能反馈
@88250

This comment was marked as outdated.

Sign in to view
@88250 88250 closed this as completed Mar 26, 2024
@88250 88250 reopened this Mar 26, 2024
@88250 88250 changed the title 数据库多字段排序时，包含空字段的行按条件先后参与排序 改进数据库多字段排序包含空值处理 Mar 26, 2024
@TCOTC
Copy link
Contributor Author

TCOTC commented Mar 26, 2024

飞书：

image

FlowUs：

image

Excel 就更不用再看了

@TCOTC
Copy link
Contributor Author

TCOTC commented Mar 26, 2024

确实大家都是这样排序的

@88250 88250 self-assigned this Mar 26, 2024
@88250 88250 changed the title 改进数据库多字段排序包含空值处理 Improve the handling of empty values in database multi-field sorting Mar 27, 2024
@88250 88250 added this to the 3.0.6 milestone Mar 27, 2024
88250 added a commit that referenced this issue Mar 27, 2024
@88250
🎨 Improve the handling of empty values in database multi-field sorting …

Verified

This commit was signed with the committer’s verified signature.
88250 D
GPG key ID: 86211BA83DF03017
Verified
Learn about vigilant mode
5c6dec4 
…#10758
@88250 88250 closed this as completed Mar 27, 2024
@TCOTC
Copy link
Contributor Author

TCOTC commented Mar 27, 2024

用了dev版，顺序好像反了，空值排在开头了：

image

@88250
Copy link
Member

88250 commented Mar 28, 2024 •
edited
Loading

下个版本会将控制排在下面。

88250 added a commit that referenced this issue Mar 28, 2024
@88250
🎨 Improve the handling of empty values in database multi-field sorting …

Verified

This commit was signed with the committer’s verified signature.
88250 D
GPG key ID: 86211BA83DF03017
Verified
Learn about vigilant mode
58f7996 
…#10758
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@88250 88250

Labels
Enhancement
Projects
None yet
Milestone
3.0.6
Development

No branches or pull requests
2 participants
@88250 @TCOTC