表头筛选日期结果不对

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

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

1. [
   
2.   {
   
3.     "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",
   
4.     "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",
   
5.     "SqlParams": [
   
6.       {
   
7.         "Name": "@p0",
   
8.         "Value": 45645.39816365741
   
9.       },
   
10.       {
    
11.         "Name": "@p1",
    
12.         "Value": 45647.32507461806
    
13.       },
    
14.       {
    
15.         "Name": "@p2",
    
16.         "Value": 45647.32541542824
    
17.       },
    
18.       {
    
19.         "Name": "@p3",
    
20.         "Value": 45647.32555755787
    
21.       },
    
22.       {
    
23.         "Name": "@p4",
    
24.         "Value": 45647.32569730324
    
25.       },
    
26.       {
    
27.         "Name": "@p5",
    
28.         "Value": 45647.32586056713
    
29.       },
    
30.       {
    
31.         "Name": "@p6",
    
32.         "Value": 45647.325952465275
    
33.       },
    
34.       {
    
35.         "Name": "@p7",
    
36.         "Value": 45647.34344556713
    
37.       },
    
38.       {
    
39.         "Name": "@p8",
    
40.         "Value": 45647.409177511574
    
41.       },
    
42.       {
    
43.         "Name": "@p9",
    
44.         "Value": 45647.409330636576
    
45.       },
    
46.       {
    
47.         "Name": "@p10",
    
48.         "Value": 45647.40941863426
    
49.       }
    
50.     ],
    
51.     "Duration": "8.2102ms"
    
52.   },
    
53.   {
    
54.     "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 )",
    
55.     "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 )",
    
56.     "SqlParams": [
    
57.       {
    
58.         "Name": "@p0",
    
59.         "Value": 45645.39816365741
    
60.       },
    
61.       {
    
62.         "Name": "@p1",
    
63.         "Value": 45647.32507461806
    
64.       },
    
65.       {
    
66.         "Name": "@p2",
    
67.         "Value": 45647.32541542824
    
68.       },
    
69.       {
    
70.         "Name": "@p3",
    
71.         "Value": 45647.32555755787
    
72.       },
    
73.       {
    
74.         "Name": "@p4",
    
75.         "Value": 45647.32569730324
    
76.       },
    
77.       {
    
78.         "Name": "@p5",
    
79.         "Value": 45647.32586056713
    
80.       },
    
81.       {
    
82.         "Name": "@p6",
    
83.         "Value": 45647.325952465275
    
84.       },
    
85.       {
    
86.         "Name": "@p7",
    
87.         "Value": 45647.34344556713
    
88.       },
    
89.       {
    
90.         "Name": "@p8",
    
91.         "Value": 45647.409177511574
    
92.       },
    
93.       {
    
94.         "Name": "@p9",
    
95.         "Value": 45647.409330636576
    
96.       },
    
97.       {
    
98.         "Name": "@p10",
    
99.         "Value": 45647.40941863426
    
100.       }
     
101.     ],
     
102.     "Duration": "7.8272ms"
     
103.   },
     
104.   {
     
105.     "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 )",
     
106.     "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 )",
     
107.     "SqlParams": [
     
108.       {
     
109.         "Name": "@p0",
     
110.         "Value": 45645.39816365741
     
111.       },
     
112.       {
     
113.         "Name": "@p1",
     
114.         "Value": 45647.32507461806
     
115.       },
     
116.       {
     
117.         "Name": "@p2",
     
118.         "Value": 45647.32541542824
     
119.       },
     
120.       {
     
121.         "Name": "@p3",
     
122.         "Value": 45647.32555755787
     
123.       },
     
124.       {
     
125.         "Name": "@p4",
     
126.         "Value": 45647.32569730324
     
127.       },
     
128.       {
     
129.         "Name": "@p5",
     
130.         "Value": 45647.32586056713
     
131.       },
     
132.       {
     
133.         "Name": "@p6",
     
134.         "Value": 45647.325952465275
     
135.       },
     
136.       {
     
137.         "Name": "@p7",
     
138.         "Value": 45647.34344556713
     
139.       },
     
140.       {
     
141.         "Name": "@p8",
     
142.         "Value": 45647.409177511574
     
143.       },
     
144.       {
     
145.         "Name": "@p9",
     
146.         "Value": 45647.409330636576
     
147.       },
     
148.       {
     
149.         "Name": "@p10",
     
150.         "Value": 45647.40941863426
     
151.       }
     
152.     ],
     
153.     "Duration": "7.5289ms"
     
154.   }
     
155. ]

复制代码

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

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

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

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




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

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


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



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

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


保留几位小数即可。



具体可参考附件~