Skip to content

Database table view date column filter time zone adjustment #9610

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
idea-zone opened this issue Nov 9, 2023 · 1 comment
Closed

Database table view date column filter time zone adjustment #9610

idea-zone opened this issue Nov 9, 2023 · 1 comment
Assignees
@Vanessa219
Labels
Development
Milestone
2.10.15

Comments

@idea-zone
Copy link

idea-zone commented Nov 9, 2023 •
edited by 88250
Loading

数据库: 日期类型过滤，无法正确过滤出 开始日期:2023-11-09 这样的过滤条件，见图。

siyuan 版本： 2.10.14 操作系统 Windows

过滤前：
image

过滤t条件：
image

过滤后：并没有正确过滤出对应的日期行
image
@88250 88250 self-assigned this Nov 9, 2023
@88250 88250 changed the title 数据库: 日期类型过滤，无法正确过滤出 开始日期:2023-11-09 这样的过滤条件，见图。 Database table view date column filter time zone adjustment Nov 9, 2023
@88250 88250 transferred this issue from siyuan-note/insider Nov 9, 2023
@88250 88250 added this to the 2.10.15 milestone Nov 9, 2023
@88250
Copy link
Member

88250 commented Nov 9, 2023

感谢反馈，下个版本改进。

但是改进以后需要重新创建过滤器，之前的数据时区有问题。

Vanessa219 added a commit that referenced this issue Nov 9, 2023
@Vanessa219
🎨 #9610
da16f74
@88250 88250 removed their assignment Nov 9, 2023
@88250 88250 closed this as completed Nov 9, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Vanessa219 Vanessa219

Labels
Development
Projects
None yet
Milestone
2.10.15
Development

No branches or pull requests
3 participants
@88250 @Vanessa219 @idea-zone