级联选择器的取值写入数据中心数据表的问题

aqsj

说明1.流程表单中的数据表中的级联选择器   
       2、流程结束时，该表单数据通过脚本写入数据中心的数据表中
       3、其它数据可以正常写入，只有级联选择器的数值没有写入到数据表中

可能是我脚本中这个字段的写法不对，请问管理大大，正确的写法是怎么样的

xadmin

您可以在脚本中输出一下print("加分扣分规则：" + item.dz_CheckRules)的值，在日志查看器里看看是什么

aqsj

xadmin 发表于 2023-6-21 11:52
您可以在脚本中输出一下print("加分扣分规则：" + item.dz_CheckRules)的值，在日志查看器里看看是什么 ...

2023-06-21 13:53:53.770 [script] PRINT 加分扣分规则：（一）税收、认证存在错误,1、收入确认有误的，按10分/次扣分
2023-06-21 13:53:53.921 [script] PRINT 加分扣分规则：（二）核算方面存在的错误,1、费用摊销有误的，按1分/笔扣分
2023-06-21 13:53:53.931 [script] PRINT 加分扣分规则：（四）记账凭证、报表存在错误,1、凭证科目输入有误的，按1分/笔扣分
2023-06-21 13:53:53.954 [ApplicationServerQueuedThreadPool-55] 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, methodOST, request:http://127.0.0.1/x_query_assembl ... le/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-tokenXBzJV7ISkIBM6ngJhUYXhG74UvgVJ-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) ~[gson-2.8.9.jar:?]
        at com.google.gson.Gson.fromJson(Gson.java:963) ~[gson-2.8.9.jar:?]
        at com.google.gson.Gson.fromJson(Gson.java:1034) ~[gson-2.8.9.jar:?]
        at com.google.gson.Gson.fromJson(Gson.java:1006) ~[gson-2.8.9.jar:?]
        at com.x.query.assemble.surface.jaxrs.table.ActionRowInsert.lambda$execute$1(ActionRowInsert.java:48) ~[classes/:?]
        at java.lang.Iterable.forEach(Iterable.java:75) ~[?:?]
        at com.x.query.assemble.surface.jaxrs.table.ActionRowInsert.execute(ActionRowInsert.java:48) ~[classes/:?]
        at com.x.query.assemble.surface.jaxrs.table.TableAction.rowInsert(TableAction.java:161) ~[classes/:?]
        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) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:159) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.internal.Errors.process(Errors.java:292) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.internal.Errors.process(Errors.java:274) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.internal.Errors.process(Errors.java:244) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) ~[jaxrs-ri-2.35.jar:2.35.]
        at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1633) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at com.x.base.core.project.jaxrs.AnonymousCipherManagerUserJaxrsFilter.doFilter(AnonymousCipherManagerUserJaxrsFilter.java:37) ~[x_base_core_project.jar:?]
        at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:561) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1612) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1582) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:716) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
        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) ~[gson-2.8.9.jar:?]
        at com.google.gson.internal.bind.TypeAdapters$15.read(TypeAdapters.java:380) ~[gson-2.8.9.jar:?]
        at com.google.gson.internal.bind.TypeAdapters$15.read(TypeAdapters.java:368) ~[gson-2.8.9.jar:?]
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$1.read(ReflectiveTypeAdapterFactory.java:131) ~[gson-2.8.9.jar:?]
        at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:222) ~[gson-2.8.9.jar:?]
        ... 74 more

论坛管理员

级联选择器是一个数组，您数据表这个字段的类型用的是什么？

aqsj

论坛管理员 发表于 2023-6-25 10:18
级联选择器是一个数组，您数据表这个字段的类型用的是什么？

用的是string

aqsj

aqsj 发表于 2023-6-25 10:35
用的是string

        我更换成 stringlist  数据类型   但是统计出来 的数据会有个中括号  []   ,  怎么去掉这个括号
["（一）税收、认证存在错误","1、收入确认有误的，按10分/次扣分"]

论坛管理员

数组肯定是有[]的，如果您涉及到统计，还是建议您使用string，然后插入自建表时先把级联选择器的值转成字符串，再插入