3.7版本bizfilter组件时间过滤有问题

qweasdzxc

3.7版本bizfilter组件时间过滤有问题，会自动转换选择的时间格式，导致找不到，CONVERT(datetime ,?, 120)是系统默认的转换，在数据库里的是带毫秒的，SQL如下：
SELECT  XFJ_Storage_M.fID AS XFJ_Storage_M, XFJ_Storage_M.FALLOCATIONTYPE AS fAllocationType, XFJ_Storage_M.FBIZSTATE AS fBizState, XFJ_Storage_M.FBIZSTATENAME AS fBizStateName, XFJ_Storage_M.FCREATEDEPARTMENT AS fCreateDepartment, XFJ_Storage_M.FCREATEDEPARTMENTCODE AS fCreateDepartmentCode, XFJ_Storage_M.FCREATEDEPARTMENTID AS fCreateDepartmentID, XFJ_Storage_M.FCREATEPERSONCODE AS fCreatePersonCode, XFJ_Storage_M.FCREATEPERSONFID AS fCreatePersonFID, XFJ_Storage_M.FCREATEPERSONFNAME AS fCreatePersonFName, XFJ_Storage_M.FCREATEPERSONID AS fCreatePersonID, XFJ_Storage_M.FCURRENTACTIVITIES AS fCurrentActivities, XFJ_Storage_M.FCURRENTEXECUTORS AS fCurrentExecutors, XFJ_Storage_M.FSTORAGECODE AS fStorageCode, XFJ_Storage_M.FSTORAGENAME AS fStorageName, XFJ_Storage_M.FSTORAGEREMARK AS fStorageRemark, XFJ_Storage_M.FSTORAGESECTIONTIME AS fStorageSectionTime, XFJ_Storage_M.FSTORAGESTATUS AS fStorageStatus, XFJ_Storage_M.FSTORAGESTATUSCODE AS fStorageStatusCode, XFJ_Storage_M.FSTORAGETIME AS fStorageTime, XFJ_Storage_M.FSTORAGETITLE AS fStorageTitle, XFJ_Storage_M.FSTORAGETYPES AS fStorageTypes, XFJ_Storage_M.FTRANSFERSINBOUND AS fTransfersInBound, XFJ_Storage_M.FTRANSFERSOUTBOUND AS fTransfersOutBound, XFJ_Storage_M.FTRANSFERSSTATUS AS fTransfersStatus, XFJ_Storage_M.FWORKCODE AS fworkCode, XFJ_Storage_M.FWORKID AS fworkID, XFJ_Storage_M.FWORKNAME AS fworkName, XFJ_Storage_M.VERSION AS version FROM XFJ_STORAGE_M XFJ_Storage_M  WHERE  (fStorageTypes = ?) AND (XFJ_Storage_M.FCREATEPERSONID = ?) AND (XFJ_Storage_M.FSTORAGETIME = CONVERT(datetime ,?, 120))

jishuang

数据库中的毫秒是怎么存储上的？通过平台input日期框编辑保存的？

qweasdzxc

jishuang 发表于 2017-9-7 11:18
数据库中的毫秒是怎么存储上的？通过平台input日期框编辑保存的？

在ontology里默认值的

jishuang

本地也设置的默认值存到数据库中的就没有

qweasdzxc

jishuang 发表于 2017-9-7 14:17
本地也设置的默认值存到数据库中的就没有

3.7版本  SQL SERVER数据库，我本地是有的

jishuang

把新增数据保存时 的sql语句打出来看看

qweasdzxc

jishuang 发表于 2017-9-7 15:39
把新增数据保存时 的sql语句打出来看看

1. 2017-09-07 15:58:51 [SQL Time]sql 执行时间：15ms, exec KSQL: INSERT INTO XFJ_Storage_M XFJ_Storage_M(XFJ_Storage_M, XFJ_Storage_M.version, XFJ_Storage_M.fAllocationType, XFJ_Storage_M.fBizState, XFJ_Storage_M.fBizStateName, XFJ_Storage_M.fCreateDepartment, XFJ_Storage_M.fCreateDepartmentCode, XFJ_Storage_M.fCreateDepartmentID, XFJ_Storage_M.fCreatePersonCode, XFJ_Storage_M.fCreatePersonFID, XFJ_Storage_M.fCreatePersonFName, XFJ_Storage_M.fCreatePersonID, XFJ_Storage_M.fCurrentActivities, XFJ_Storage_M.fCurrentExecutors, XFJ_Storage_M.fStorageCode, XFJ_Storage_M.fStorageName, XFJ_Storage_M.fStorageRemark, XFJ_Storage_M.fStorageSectionTime, XFJ_Storage_M.fStorageStatus, XFJ_Storage_M.fStorageStatusCode, XFJ_Storage_M.fStorageTime, XFJ_Storage_M.fStorageTitle, XFJ_Storage_M.fStorageTypes, XFJ_Storage_M.fTransfersInBound, XFJ_Storage_M.fTransfersOutBound, XFJ_Storage_M.fTransfersStatus, XFJ_Storage_M.fworkCode, XFJ_Storage_M.fworkID, XFJ_Storage_M.fworkName) VALUES (:XFJ_Storage_M, :version, :fAllocationType, :fBizState, :fBizStateName, :fCreateDepartment, :fCreateDepartmentCode, :fCreateDepartmentID, :fCreatePersonCode, :fCreatePersonFID, :fCreatePersonFName, :fCreatePersonID, :fCurrentActivities, :fCurrentExecutors, :fStorageCode, :fStorageName, :fStorageRemark, :fStorageSectionTime, :fStorageStatus, :fStorageStatusCode, :fStorageTime, :fStorageTitle, :fStorageTypes, :fTransfersInBound, :fTransfersOutBound, :fTransfersStatus, :fworkCode, :fworkID, :fworkName)
   
2.   --> sql:INSERT INTO XFJ_STORAGE_M (XFJ_STORAGE_M.fID, XFJ_STORAGE_M.VERSION, XFJ_STORAGE_M.FALLOCATIONTYPE, XFJ_STORAGE_M.FBIZSTATE, XFJ_STORAGE_M.FBIZSTATENAME, XFJ_STORAGE_M.FCREATEDEPARTMENT, XFJ_STORAGE_M.FCREATEDEPARTMENTCODE, XFJ_STORAGE_M.FCREATEDEPARTMENTID, XFJ_STORAGE_M.FCREATEPERSONCODE, XFJ_STORAGE_M.FCREATEPERSONFID, XFJ_STORAGE_M.FCREATEPERSONFNAME, XFJ_STORAGE_M.FCREATEPERSONID, XFJ_STORAGE_M.FCURRENTACTIVITIES, XFJ_STORAGE_M.FCURRENTEXECUTORS, XFJ_STORAGE_M.FSTORAGECODE, XFJ_STORAGE_M.FSTORAGENAME, XFJ_STORAGE_M.FSTORAGEREMARK, XFJ_STORAGE_M.FSTORAGESECTIONTIME, XFJ_STORAGE_M.FSTORAGESTATUS, XFJ_STORAGE_M.FSTORAGESTATUSCODE, XFJ_STORAGE_M.FSTORAGETIME, XFJ_STORAGE_M.FSTORAGETITLE, XFJ_STORAGE_M.FSTORAGETYPES, XFJ_STORAGE_M.FTRANSFERSINBOUND, XFJ_STORAGE_M.FTRANSFERSOUTBOUND, XFJ_STORAGE_M.FTRANSFERSSTATUS, XFJ_STORAGE_M.FWORKCODE, XFJ_STORAGE_M.FWORKID, XFJ_STORAGE_M.FWORKNAME) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? )
   
3. --> binds:[D36A25274838419D8D95629A2D1B9F6C, 0, null, 0, 未导入, 测试部门1, testdpt1, hLHIOeATWHFAjUkjwfl, testpsm3, /ORG01.ogn/hLHIOeATWHFAjUkjwfl.dpt/yGmTzzZ07tEiGlubdJw.pos/wK2tR1pawIoKo5XF2bo@yGmTzzZ07tEiGlubdJw.psm, /起步软件/测试部门1/测试岗位2/测试人员3, wK2tR1pawIoKo5XF2bo, null, null, DRDH201709070004, 测试人员3, qwer, 2017-09-07, 未导入, 0, 2017-09-07 15:58:10.965, qwer, SH, null, null, 是, null, null, null]

复制代码

jishuang

你好楼主，这个问题需要我在本地环境进行问题重现，所以会花费较长时间，请你耐心等待，我完成后会第一时间反馈结果，谢谢！

jishuang

目前先不用要等的方式去过滤可以用两个时间的大小等于和小于等于去过滤

你好楼主，您反馈的这个现象通过验证是产品缺陷，我们已提交到产品组(内部编号：2017090700010)，感谢楼主的支持与配合。