引用：Alex.Kingdee.Cloud.WebAPI.Client;
登录验证是正常的，查询过滤条件为时间字段就直接报错了

FilterString 设置为FNumber='0001' 可以正常查询，为时间条件就会出错：

var dateJson = new

{

FormId = "PRD_ShiftGroup",

FieldKeys = "FNumber,FName,FDescription,FForbidStatus,FCreateDate",

FilterString = " FCreateDate>'2019-03-28'",

OrderString = "",

TopRowCount = 0,

StartRow = 0,

Limit = 10

};

Code(-2147467259);{InnerExWrapper:{IsEmpty:false,Data:{},HelpLink:null,Message:调用的目标发生了异常。,Source:null,StackTrace: 在 System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)\r\n 在 System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)\r\n 在 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)\r\n 在 Kingdee.BOS.ServiceFacade.KDServiceFx.ServiceExecutor.Execute(KDServiceContext context, ServiceType svcType, String[] paraValues, SerializerProxy serializeProxy, ServiceType beginMethod),TargetSite:null,ExceptionType:System.Reflection.TargetInvocationException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089,InnerException:{IsEmpty:false,Data:{发生时间：:20:23:40,错误编号：:BOS_ExecuteReader,错误来源：:null,错误信息：:ORA-01861: literal does not match format string,调用堆栈：:null,Sql语句：:SELECT FNumber, FName, FDescription, FForbidStatus, FCreateDate FROM (SELECT t0.FNUMBER FNUMBER, t0_L.FNAME FNAME, t0_L.FDESCRIPTION FDESCRIPTION, t0.FFORBIDSTATUS FFORBIDSTATUS, t0.FCREATEDATE FCREATEDATE, ROW_NUMBER() OVER( ORDER BY t0.FID ASC) FIDENTITYID FROM T_PRD_SHIFTGROUP T0 LEFT OUTER JOIN T_PRD_SHIFTGROUP_L T0_L ON (t0.FID = t0_L.FID AND t0_L.FLocaleId = 2052) WHERE (t0.FAPPROVEDATE > '2019-03-28')) SPLIST WHERE ((FIDENTITYID >= 1) AND (FIDENTITYID <= 10))},HelpLink:null,Message:ORA-01861: literal does not match format string,Source:null,StackTrace:\r\nServer stack trace: \r\n 在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior, Boolean bNewCn)\r\n 在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior)\r\n 在 Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior, Boolean bNewCn)\r\n 在 Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior)\r\n 在 Kingdee.BOS.App.Data.DBUtils.ExecuteObject[T](Context ctx, String strSQL, IDataEntityType dt, IDictionary`2 propertyTypeMaps, CommandType cmdType, SqlParam[] paramList)\r\n 在 Kingdee.BOS.App.Data.DBUtils.ExecuteDynamicObject(Context ctx, String strSQL, IDataEntityType dt, IDictionary`2 propertyTypeMaps, CommandType cmdType, SqlParam[] paramList)\r\n 在 Kingdee.BOS.App.Core.Query.QueryService.GetDynamicObjectCollection(Context ctx, QueryBuilderParemeter para, List`1 paramList)\r\n\r\nException rethrown at [0]: \r\n 在 Kingdee.BOS.WebApi.FormService.QueryBillService.ExecuteBillQuery(String data)\r\n 在 Kingdee.BOS.WebApi.FormService.WebApiServiceCall.ExecuteBillQuery(Context ctx, String data)\r\n 在 Kingdee.BOS.WebApi.ServicesStub.DynamicFormService.ExecuteBillQuery(String data),TargetSite:null,ExceptionType:Kingdee.BOS.KDExceptionDatabase, Kingdee.BOS, Version=7.2.960.7, Culture=neutral, PublicKeyToken=null,InnerException:{IsEmpty:false,Data:{},HelpLink:null,Message:ORA-01861: literal does not match format string,Source:null,StackTrace: 在 Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)\r\n 在 Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)\r\n 在 Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n 在 Kingdee.BOS.App.Data.AbstractDatabase.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior)\r\n 在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior, Boolean bNewCn),TargetSite:null,ExceptionType:Oracle.DataAccess.Client.OracleException, Oracle.DataAccess, Version=4.112.4.0, Culture=neutral, PublicKeyToken=89b483f429c47342,InnerException:null}}},ClassName:Kingdee.BOS.ServiceFacade.ServiceException,Message:ORA-01861: literal does not match format string,Data:null,InnerException:null,HelpURL:null,StackTraceString: 在 Kingdee.BOS.ServiceFacade.KDServiceFx.ServiceExecutor.Execute(KDServiceContext context, ServiceType svcType, String[] paraValues, SerializerProxy serializeProxy, ServiceType beginMethod)\r\n 在 Kingdee.BOS.ServiceFacade.KDServiceFx.ExecuteServiceModule.OnProcess(KDServiceContext context)\r\n 在 Kingdee.BOS.ServiceFacade.KDServiceFx.ModulePipeline.ExcuteRequest(KDServiceContext context)\r\n 在 Kingdee.BOS.ServiceFacade.KDServiceFx.RequestExcuteRuntime.StartRequest(RequestExtractor requestExtractor, WebContext context)\r\n 在 Kingdee.BOS.ServiceFacade.KDServiceFx.KDSVCHandler.ExecuteRequest(WebContext ctx, RequestExtractor requestExtractor)\r\n 在 Kingdee.BOS.ServiceFacade.KDServiceFx.KDSVCHandler.ProcessRequestInternal(WebContext webCtx, RequestExtractor requestExtractor),RemoteStackTraceString:null,RemoteStackIndex:0,ExceptionMethod:8\nExecute\nKingdee.BOS.ServiceFacade.KDServiceFx, Version=7.2.960.7, Culture=neutral, PublicKeyToken=null\nKingdee.BOS.ServiceFacade.KDServiceFx.ServiceExecutor\nSystem.String Execute(Kingdee.BOS.ServiceFacade.KDServiceFx.KDServiceContext, Kingdee.BOS.ServiceFacade.KDServiceFx.ServiceType, System.String[], Kingdee.BOS.ServiceFacade.SerializerProxy, Kingdee.BOS.ServiceFacade.KDServiceFx.ServiceType),HResult:-2147467259,Source:Kingdee.BOS.ServiceFacade.KDServiceFx,WatsonBuckets:null,_httpCode:500}

产品问题WEB API FilterString设置时间字段报错

产品问题 WEB API FilterString设置时间字段报错

恭喜您！

产品问题
WEB API FilterString设置时间字段报错