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

Improve database date filed sorting #12127

Closed
3 tasks done
idea-zone opened this issue Jul 29, 2024 · 2 comments
Closed
3 tasks done

Improve database date filed sorting #12127

idea-zone opened this issue Jul 29, 2024 · 2 comments
Assignees
Milestone

Comments

@idea-zone
Copy link

idea-zone commented Jul 29, 2024

数据库多个排序调教的时候,只有第一个排序条件起作用

Is there an existing issue for this?

  • I have searched the existing issues

Can the issue be reproduced with the default theme (daylight/midnight)?

  • I was able to reproduce the issue with the default theme

Could the issue be due to extensions?

  • I've ruled out the possibility that the extension is causing the problem.

Describe the problem

数据库多个排序调教的时候,只有第一个排序条件起作用,第二个和第三个排序条件没有效果。

如图:

image

Expected result

希望多个排序条件,可以在保持 “日期” 的排序约束下,再按照 “状态” 和额 “时间段” 排序。

Screenshot or screen recording presentation

No response

Version environment

- Version: v3.1.1
- Operating System: Win10教育版64位系统 
- Browser (if used): None

Log file

None

More information

No response

@88250 88250 changed the title 数据库 数据库多个排序调教的时候,只有第一个排序条件起作用 Jul 29, 2024
@TCOTC
Copy link
Contributor

TCOTC commented Jul 29, 2024

@88250 这个是日期排序的问题

如果没有打开具体时间,那么在排序的时候就不应该比较具体的时间,只应该比较日期:

image

参考 Notion ,在升序条件下,有具体时间的条目排在无具体时间的后面:

image

@88250 88250 self-assigned this Jul 29, 2024
@88250
Copy link
Member

88250 commented Jul 29, 2024

稍后调整,谢谢。

@88250 88250 changed the title 数据库多个排序调教的时候,只有第一个排序条件起作用 Improve database date filed sorting Jul 29, 2024
@88250 88250 added this to the 3.1.2 milestone Jul 29, 2024
@88250 88250 closed this as completed Jul 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants