表头筛选日期结果不对

登录

筛选20日的会出现21日的数据

Erik.Xue · Erik.Xue

大佬，这个问题的根本原因是因为你的这个日期字段精度太高了，从请求中可以看到，日期小数点保留了十几位：

已经是不毫秒级别，甚至微秒都不够，纳秒级别了。

活字格在页面上展示的时候，筛选只能到毫秒级别，所以相当于在毫秒这块，如果有重复的数据，那么查询直到毫秒级：

筛选后的重复的四条数据：

这四条数据就是因为精度只到了毫秒。

所以解决这个问题，加个公式字段：

保留几位小数即可。

具体可参考附件~

二麻子 · 二麻子

你给的DEOM 里没有图片中的筛选弹出窗口。此外，我直接在表头上进行筛选，没有问题。

大英俊 · 大英俊

二麻子发表于 2024-12-21 16:18
你给的DEOM 里没有图片中的筛选弹出窗口。此外，我直接在表头上进行筛选，没有问题。

最下面那个设置筛选就是弹框

二麻子 · 二麻子

在执行自定筛选的时候它的筛选SQL如下，可以看到这段SQL排除了不符合日期的数据，总共是11条。为什么是11条？因为自定义筛选中除去20号后就只能看到11条，但实际上不止11条，而是15条。所以产生的根本原因是因为表头的自定义筛选不能捕捉到所有行导致的，我之前直接用日期进行筛选没问题。

[
{
"Sql": "select a.[ID] as C0,a.[FMiShu] as C1,a.[FZhongLiang] as C2,a.[TCREATEDATE] as C3,a.[FBZGG] as C4,a.[Fbarcode] as C5,a.[FGC_Rowversion] as C6 from [main].[T_BD_BARCODEMAINFILE] as a Where a.[FMoEntryId] = 114513 AND ((a.[TCREATEDATE] <> 45645.39816365741 AND a.[TCREATEDATE] <> 45647.32507461806 AND a.[TCREATEDATE] <> 45647.32541542824 AND a.[TCREATEDATE] <> 45647.32555755787 AND a.[TCREATEDATE] <> 45647.32569730324 AND a.[TCREATEDATE] <> 45647.32586056713 AND a.[TCREATEDATE] <> 45647.325952465275 AND a.[TCREATEDATE] <> 45647.34344556713 AND a.[TCREATEDATE] <> 45647.409177511574 AND a.[TCREATEDATE] <> 45647.409330636576 AND a.[TCREATEDATE] <> @p10) OR a.[TCREATEDATE] is null ) ORDER BY a.[ID] ASC",
"OriginalSql": "select a.[ID] as C0,a.[FMiShu] as C1,a.[FZhongLiang] as C2,a.[TCREATEDATE] as C3,a.[FBZGG] as C4,a.[Fbarcode] as C5,a.[FGC_Rowversion] as C6 from [main].[T_BD_BARCODEMAINFILE] as a Where a.[FMoEntryId] = 114513 AND ((a.[TCREATEDATE] <> @p0 AND a.[TCREATEDATE] <> @p1 AND a.[TCREATEDATE] <> @p2 AND a.[TCREATEDATE] <> @p3 AND a.[TCREATEDATE] <> @p4 AND a.[TCREATEDATE] <> @p5 AND a.[TCREATEDATE] <> @p6 AND a.[TCREATEDATE] <> @p7 AND a.[TCREATEDATE] <> @p8 AND a.[TCREATEDATE] <> @p9 AND a.[TCREATEDATE] <> @p10) OR a.[TCREATEDATE] is null ) ORDER BY a.[ID] ASC",
"SqlParams": [
{
"Name": "@p0",
"Value": 45645.39816365741
},
{
"Name": "@p1",
"Value": 45647.32507461806
},
{
"Name": "@p2",
"Value": 45647.32541542824
},
{
"Name": "@p3",
"Value": 45647.32555755787
},
{
"Name": "@p4",
"Value": 45647.32569730324
},
{
"Name": "@p5",
"Value": 45647.32586056713
},
{
"Name": "@p6",
"Value": 45647.325952465275
},
{
"Name": "@p7",
"Value": 45647.34344556713
},
{
"Name": "@p8",
"Value": 45647.409177511574
},
{
"Name": "@p9",
"Value": 45647.409330636576
},
{
"Name": "@p10",
"Value": 45647.40941863426
}
],
"Duration": "8.2102ms"
},
{
"Sql": "select SUM(a.[FMiShu]) as C0 from [main].[T_BD_BARCODEMAINFILE] as a Where a.[FMoEntryId] = 114513 AND ((a.[TCREATEDATE] <> 45645.39816365741 AND a.[TCREATEDATE] <> 45647.32507461806 AND a.[TCREATEDATE] <> 45647.32541542824 AND a.[TCREATEDATE] <> 45647.32555755787 AND a.[TCREATEDATE] <> 45647.32569730324 AND a.[TCREATEDATE] <> 45647.32586056713 AND a.[TCREATEDATE] <> 45647.325952465275 AND a.[TCREATEDATE] <> 45647.34344556713 AND a.[TCREATEDATE] <> 45647.409177511574 AND a.[TCREATEDATE] <> 45647.409330636576 AND a.[TCREATEDATE] <> @p10) OR a.[TCREATEDATE] is null )",
"OriginalSql": "select SUM(a.[FMiShu]) as C0 from [main].[T_BD_BARCODEMAINFILE] as a Where a.[FMoEntryId] = 114513 AND ((a.[TCREATEDATE] <> @p0 AND a.[TCREATEDATE] <> @p1 AND a.[TCREATEDATE] <> @p2 AND a.[TCREATEDATE] <> @p3 AND a.[TCREATEDATE] <> @p4 AND a.[TCREATEDATE] <> @p5 AND a.[TCREATEDATE] <> @p6 AND a.[TCREATEDATE] <> @p7 AND a.[TCREATEDATE] <> @p8 AND a.[TCREATEDATE] <> @p9 AND a.[TCREATEDATE] <> @p10) OR a.[TCREATEDATE] is null )",
"SqlParams": [
{
"Name": "@p0",
"Value": 45645.39816365741
},
{
"Name": "@p1",
"Value": 45647.32507461806
},
{
"Name": "@p2",
"Value": 45647.32541542824
},
{
"Name": "@p3",
"Value": 45647.32555755787
},
{
"Name": "@p4",
"Value": 45647.32569730324
},
{
"Name": "@p5",
"Value": 45647.32586056713
},
{
"Name": "@p6",
"Value": 45647.325952465275
},
{
"Name": "@p7",
"Value": 45647.34344556713
},
{
"Name": "@p8",
"Value": 45647.409177511574
},
{
"Name": "@p9",
"Value": 45647.409330636576
},
{
"Name": "@p10",
"Value": 45647.40941863426
}
],
"Duration": "7.8272ms"
},
{
"Sql": "select SUM(a.[FZhongLiang]) as C0 from [main].[T_BD_BARCODEMAINFILE] as a Where a.[FMoEntryId] = 114513 AND ((a.[TCREATEDATE] <> 45645.39816365741 AND a.[TCREATEDATE] <> 45647.32507461806 AND a.[TCREATEDATE] <> 45647.32541542824 AND a.[TCREATEDATE] <> 45647.32555755787 AND a.[TCREATEDATE] <> 45647.32569730324 AND a.[TCREATEDATE] <> 45647.32586056713 AND a.[TCREATEDATE] <> 45647.325952465275 AND a.[TCREATEDATE] <> 45647.34344556713 AND a.[TCREATEDATE] <> 45647.409177511574 AND a.[TCREATEDATE] <> 45647.409330636576 AND a.[TCREATEDATE] <> @p10) OR a.[TCREATEDATE] is null )",
"OriginalSql": "select SUM(a.[FZhongLiang]) as C0 from [main].[T_BD_BARCODEMAINFILE] as a Where a.[FMoEntryId] = 114513 AND ((a.[TCREATEDATE] <> @p0 AND a.[TCREATEDATE] <> @p1 AND a.[TCREATEDATE] <> @p2 AND a.[TCREATEDATE] <> @p3 AND a.[TCREATEDATE] <> @p4 AND a.[TCREATEDATE] <> @p5 AND a.[TCREATEDATE] <> @p6 AND a.[TCREATEDATE] <> @p7 AND a.[TCREATEDATE] <> @p8 AND a.[TCREATEDATE] <> @p9 AND a.[TCREATEDATE] <> @p10) OR a.[TCREATEDATE] is null )",
"SqlParams": [
{
"Name": "@p0",
"Value": 45645.39816365741
},
{
"Name": "@p1",
"Value": 45647.32507461806
},
{
"Name": "@p2",
"Value": 45647.32541542824
},
{
"Name": "@p3",
"Value": 45647.32555755787
},
{
"Name": "@p4",
"Value": 45647.32569730324
},
{
"Name": "@p5",
"Value": 45647.32586056713
},
{
"Name": "@p6",
"Value": 45647.325952465275
},
{
"Name": "@p7",
"Value": 45647.34344556713
},
{
"Name": "@p8",
"Value": 45647.409177511574
},
{
"Name": "@p9",
"Value": 45647.409330636576
},
{
"Name": "@p10",
"Value": 45647.40941863426
}
],
"Duration": "7.5289ms"
}
]

复制代码

		自动登录	找回密码
密码			立即注册

[已处理] 表头筛选日期结果不对

最佳答案

4 个回复

本帖子中包含更多资源

本帖子中包含更多资源

Wyn高级认证

Wyn认证

讲师达人

悬赏达人

元老葡萄

活字格认证

活字格高级认证

微信认证勋章