级联选择器的取值写入数据中心数据表的问题
说明1.流程表单中的数据表中的级联选择器2、流程结束时，该表单数据通过脚本写入数据中心的数据表中
3、其它数据可以正常写入，只有级联选择器的数值没有写入到数据表中
可能是我脚本中这个字段的写法不对，请问管理大大，正确的写法是怎么样的
您可以在脚本中输出一下print("加分扣分规则：" + item.dz_CheckRules)的值，在日志查看器里看看是什么 xadmin 发表于 2023-6-21 11:52
您可以在脚本中输出一下print("加分扣分规则：" + item.dz_CheckRules)的值，在日志查看器里看看是什么 ...
2023-06-21 13:53:53.770 PRINT 加分扣分规则：（一）税收、认证存在错误,1、收入确认有误的，按10分/次扣分
2023-06-21 13:53:53.921 PRINT 加分扣分规则：（二）核算方面存在的错误,1、费用摊销有误的，按1分/笔扣分
2023-06-21 13:53:53.931 PRINT 加分扣分规则：（四）记账凭证、报表存在错误,1、凭证科目输入有误的，按1分/笔扣分
2023-06-21 13:53:53.954 ERROR com.x.query.assemble.surface.jaxrs.table.TableAction - id:89dad6d9-c074-4454-a0a4-7d75e722ff6b, name:com.x.query.assemble.surface.jaxrs.table.TableAction, message:java.lang.IllegalStateException: Expected STRING but was BEGIN_ARRAY at path $.dz_CheckRules, exception:com.google.gson.JsonSyntaxException, id:89dad6d9-c074-4454-a0a4-7d75e722ff6b, name:com.x.query.assemble.surface.jaxrs.table.TableAction, message:java.lang.IllegalStateException: Expected STRING but was BEGIN_ARRAY at path $.dz_CheckRules, exception:com.google.gson.JsonSyntaxException, person:cipher, method:POST, request:http://127.0.0.1/x_query_assemble_surface/jaxrs/table/jianchaTable/row, remoteHost:127.0.0.1, emoteAddr:127.0.0.1, head:Cache-Control:no-cache, no-transform
Accept:text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
Access-Control-Allow-Credentials:true
Access-Control-Allow-Methods:GET, POST, OPTIONS, PUT, DELETE, HEAD, TRACE
x-token:PXBzJV7ISkIBM6ngJhUYXhG74UvgVJ-2ygGd-L0N0gg
User-Agent:Java/11.0.16.1
Connection:keep-alive
Host:127.0.0.1
Pragma:no-cache
Content-Length:1644
Access-Control-Allow-Headers:x-requested-with, x-request, Content-Type, x-cipher, x-client, x-token
Content-Type:application/json;charset=UTF-8, body:[
{
"subject": "南池柳文化传媒（宁波）有限公司",
"dz_EnterpriseId": "宁安税代账第0003号",
"dz_EnterpriseNature": "小规模纳税人",
"dz_CustomerType": "小规模纳税人",
"dz_Department": "代理记账一组",
"dz_ProjectLeader": "顾晓雅",
"dz_CheckPerson": "严珂娜",
"dz_CheckData": "2023-06-20",
"dz_CheckScore": -14,
"dz_DeductPoints": -10,
"dz_BonusPoints": 0,
"dz_CheckRules": [
"（一）税收、认证存在错误",
"1、收入确认有误的，按10分/次扣分"
],
"dz_CheckExplain": "1处收入确认错误",
"dz_CheckReply": "已改正"
},
{
"subject": "南池柳文化传媒（宁波）有限公司",
"dz_EnterpriseId": "宁安税代账第0003号",
"dz_EnterpriseNature": "小规模纳税人",
"dz_CustomerType": "小规模纳税人",
"dz_Department": "代理记账一组",
"dz_ProjectLeader": "顾晓雅",
"dz_CheckPerson": "严珂娜",
"dz_CheckData": "2023-06-20",
"dz_CheckScore": -14,
"dz_DeductPoints": -2,
"dz_BonusPoints": 0,
"dz_CheckRules": [
"（二）核算方面存在的错误",
"1、费用摊销有误的，按1分/笔扣分"
],
"dz_CheckExplain": "2处费用分摊错误",
"dz_CheckReply": "已改正"
},
{
"subject": "南池柳文化传媒（宁波）有限公司",
"dz_EnterpriseId": "宁安税代账第0003号",
"dz_EnterpriseNature": "小规模纳税人",
"dz_CustomerType": "小规模纳税人",
"dz_Department": "代理记账一组",
"dz_ProjectLeader": "顾晓雅",
"dz_CheckPerson": "严珂娜",
"dz_CheckData": "2023-06-20",
"dz_CheckScore": -14,
"dz_DeductPoints": -2,
"dz_BonusPoints": 0,
"dz_CheckRules": [
"（四）记账凭证、报表存在错误",
"1、凭证科目输入有误的，按1分/笔扣分"
],
"dz_CheckExplain": "2处",
"dz_CheckReply": "已改正"
}
]..
com.google.gson.JsonSyntaxException: java.lang.IllegalStateException: Expected STRING but was BEGIN_ARRAY at path $.dz_CheckRules
at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:226) ~
at com.google.gson.Gson.fromJson(Gson.java:963) ~
at com.google.gson.Gson.fromJson(Gson.java:1034) ~
at com.google.gson.Gson.fromJson(Gson.java:1006) ~
at com.x.query.assemble.surface.jaxrs.table.ActionRowInsert.lambda$execute$1(ActionRowInsert.java:48) ~
at java.lang.Iterable.forEach(Iterable.java:75) ~[?:?]
at com.x.query.assemble.surface.jaxrs.table.ActionRowInsert.execute(ActionRowInsert.java:48) ~
at com.x.query.assemble.surface.jaxrs.table.TableAction.rowInsert(TableAction.java:161) ~
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) ~
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) ~
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) ~
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:159) ~
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) ~
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) ~
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) ~
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) ~
at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) ~
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) ~
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) ~
at org.glassfish.jersey.internal.Errors.process(Errors.java:292) ~
at org.glassfish.jersey.internal.Errors.process(Errors.java:274) ~
at org.glassfish.jersey.internal.Errors.process(Errors.java:244) ~
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) ~
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) ~
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684) ~
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) ~
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) ~
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) ~
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) ~
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) ~
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763) ~
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1633) ~
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609) ~
at com.x.base.core.project.jaxrs.AnonymousCipherManagerUserJaxrsFilter.doFilter(AnonymousCipherManagerUserJaxrsFilter.java:37) ~
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609) ~
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:561) ~
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1612) ~
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1582) ~
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59) ~
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:716) ~
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~
at org.eclipse.jetty.server.Server.handle(Server.java:516) ~
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) ~
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556) ~
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) ~
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) ~
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) ~
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) ~
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) ~
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) ~
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) ~
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) ~
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) ~
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) ~
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) ~
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) ~
at java.lang.Thread.run(Thread.java:829) ~[?:?]
Caused by: java.lang.IllegalStateException: Expected STRING but was BEGIN_ARRAY at path $.dz_CheckRules
at com.google.gson.internal.bind.JsonTreeReader.nextString(JsonTreeReader.java:181) ~
at com.google.gson.internal.bind.TypeAdapters$15.read(TypeAdapters.java:380) ~
at com.google.gson.internal.bind.TypeAdapters$15.read(TypeAdapters.java:368) ~
at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$1.read(ReflectiveTypeAdapterFactory.java:131) ~
at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:222) ~
... 74 more 级联选择器是一个数组，您数据表这个字段的类型用的是什么？ 论坛管理员 发表于 2023-6-25 10:18
级联选择器是一个数组，您数据表这个字段的类型用的是什么？
用的是string aqsj 发表于 2023-6-25 10:35
用的是string
我更换成 stringlist数据类型 但是统计出来 的数据会有个中括号[] ,怎么去掉这个括号
["（一）税收、认证存在错误","1、收入确认有误的，按10分/次扣分"] 数组肯定是有[]的，如果您涉及到统计，还是建议您使用string，然后插入自建表时先把级联选择器的值转成字符串，再插入
页:
[1]