红袖圈 发表于 2024-3-8 11:53:24

请教给查询配置传参时in查询的写法

我在门户管理里嵌入查询配置的视图,并给设计了一些查询条件,其中一个条件是下拉多选框,可选值有待提交、已提交。脚本里写查询条件时下图的value值试了很多种写法都不对,如果直接把下拉框值赋给value,会提示数组不能给in查询的信息,如下2张图:


如果写死value值也报错,如下图




想请教一下,正确的写法是怎样的,可以示范一下写死的形式,我按照这个格式处理

wstxdyb 发表于 2024-3-11 11:31:52

会不会是因为你系统设置里禁用了ArrayList哦

红袖圈 发表于 2024-3-11 11:37:51

这个是怎么设置的,我没有设置过,怎么检查

红袖圈 发表于 2024-3-11 11:38:08

wstxdyb 发表于 2024-3-11 11:31
会不会是因为你系统设置里禁用了ArrayList哦


这个是怎么设置的,我没有设置过,怎么检查

论坛管理员 发表于 2024-3-12 09:54:52

o2server/config/general.json这个文件里

红袖圈 发表于 2024-3-12 10:10:55

本帖最后由 红袖圈 于 2024-3-12 10:13 编辑

http://img-wz3.tttking.cn/2023/0720240312101024.pnghttp://img-wz3.tttking.cn/2023/0720240312101024.png



data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA8oAAAA9CAIAAAD6cgdfAAAXe0lEQVR4nO3dv4/jxtkH8Ecv8j/YxnvwRNA1nsYMbCCFcbQAC9i3yI2SxgVhgMCpiCresdRb0GcWr0qdWSmFDhBisEiTl7wU7wI0IPPgIoAPphtes8JmjATx/RV6C+q3ONSP5e5Kt98PAuQ8y515OBxyR6PhTOXevXt0RcJLXHI0K7xqRgAAAAAAp+0/Ssgj7Dux7iZJEHiihOwAAAAAAE7Vr0rIQ7RdXQ6dzvlFmpaQHQAAAADAqSqhe81rjOJBL0TXGgAAAADuujImhwAAAAAAABGhew0AAAAAUCJ0rwEAAAAASnO1udfCC1o6Y3JoYFE+AAAAAACqlLDuNQAAAAAAEBEmhwAAAAAAlGhjcgjnfPqvdGUVa1U6HC1ue11TZ0RyaDR7SxeNC0EX4W6X8crXnduBbzIiIoqxtScAAAC89da619xut6tERIzpcrDoDAnPb7FYSiK6jPop1rjeBxfi/sWu3dnyiLbJRobW2yiWn7Xc6iC0dohH1R6IiDgXRGGaciEoVLeItNfUelkvu3rAWQAAAACclrXuddqzLCIiEl7SWP2RHFjXOfQovMSlzdFNLux2y9QZEcl42LE2O4tHYTFQvBGk8HxXp9jZqTtbZkg1RjLKKzPtNbUdMyloD/ys26JOmIq224gKutcAAAAAd0pZc685X8wiKI/wfLd+OTA0TdOMETO7dvlllEB4vkkjQ9M0Y0Cm74n5T7gduCyO41sM7prwszqNzlPiNSYvL247GgAAAIBjccXutfASz7aDIOl2u10/mXcsue0FSZIkSRJ4YqlLnJfO7SBJElcn0t3sZ9NshOfqsdOcbree9gYxq59x4naQLPVghZcENp/mE3hekCSBZ9tBkiSJt607roiTi6X0rV160dDlsN9LiSgN+0OpNxbR0chpWtGWDJbiEfnlqurNE0JVob7JZhUazLMSXrJSxYv8Z7nYtrd0fO7pekEQBL7JmNmd///2Wio827VmAgAAAHCyrj56rderg47WbDabmtHPpnYIzzdpYGiaZjgj5s7HnPPT015T0zQnJoodTdM0bTpDRDR0iqNw3gsLGiRZ9X5xNJf9pjEk3awONM2J9fpZcUdREedZg6KOlo2Zrw5H5+A1RnI8mxyRjiWx2vx1wF5vjwk1wvNdNnIMTdO0TkRnYpGeGyeR3mpkgRqO1N22mBba1DTNGMpZhS7eawwtbVrX6/Ugnenoe13fEmVodTqdQUzx0Oh0RpJix+h0+gfM2hFtl42ml7wTNc4KaxkAAADgNFy9ey1H/dnE2+nLe9lobpiN5s7GnAvS8/Eay3rXou3q0tG0TkRsazDjlNKxpJ3mKyjjCXvWdMic0l4UL3WXC3A7mA37bv0QUBBPZzZYH8575gX1Nq/8NNw1TkW5S/lv/YU0pRqTl+dper/K4ihMD15MhtVrgnMiSkNrnw8iAAAAAMfqars25lK9U6d+125rdvEgJKKLS0kHLj4hvMSdjcrOlocriEfYQctk8868vCzKZ2q6QgYJ2q1zv+GQeluMmh9uv+vCba9dJcYYUdurMp2IPK/WP+Sd09Ayal631TVddtTvrQIAAADs4Rq2lVmdHrE9vQCrcUrHkvSGIOL3q1tHr1WySRHLU08K4hGea8rsfcr1mRTb81mdKrKPEuutlHIVzqPokojJ0SC6JJLxKIqi80OL7lnNZjOb2mK2MTkEAAAA3gLXsWtjGMXMbAtORFzYLV2OztOidCLKhqZXOnnpWGazLMK+EzM3SboNkrMf6K1sGgYXdmvbXOG94yQieUnpzvln+WSvV4q2yeLosGkOYRQzs2uL2ZnZYmucB1uu6vX8C38xTcNwTCwe9MJwTExGvTDcZUnv+aekOW57Nt5nBAAAgLfNtWyKHlrGkFp+kiS+W5dOZ/alvyqdKFsYhEx/aVmLsD+UesvmlIZWU9O0pmU1NSskCi1ndmi3MR4dvuqdIp6wP5T1bM2N3fIPLWNIdT9JEr9FQ2Npyki2UoerT9fwKH5HkkLLcGTdnZ4ZnYeLdGW9HSK0HFn3F2uKhJYxZK6flbr9fGdr8YmGvscnidDKPiXNFzJJe31qdJMkp9oAAAAATlbl3r17eenCSxrR8q6NK/95U7gd+HXpdCzsWnJjhJe0Llc3UadbawAAAAAAp2Zt9Hq+LrK7MUVgtih18aLI5Up7TWNAre7Nl3y3CHu27DRfnXxS0B4AAAAAIIdq9BruFC68rjvdeh5fFgAAAAAcDt1rAAAAAIDSHP5q43wf7bU39lTpN4iLbK8SuA7syeT5s9sO4u46gvvr1OH5cDNQz3AVp9l+lvaXu+6STrZ+DvvLdXrne3j3Ott6WzOGcrf0m8PPGq32QfsmAhy727+/Th2eDzcD9QxXgfZT7K7Vzwme77UszFcm4e09Spf2rOYdXuPi8avJ843/ff6B4uiHk+evJp+spn3+18njh4cUzR5Oun+dlth9tn0P+7fAAe3zmsxfQ02SIPB2XVF8r/i58ILZ2PnuRRybO/58uDFHVc/Hc5+qZPfvPMbsW6q35nX+U/87foTt56jq5wac4Pkefff6TlnrjzJVn3jTB4uDv/6o8uijyqOPKj8R/d8X03//5bXiFy8qb4j+c7Wg996nfx+wrfvDyZdP6W//PS2x/y39/skh8VNJ9XDUOOfX8T1X7GiapmmdAbX80v8yC893adCZblraiWrtq5dwTfUAUIqy2ueO+UjJpltv8bM6SXxBBXDC1rrXXHjBbHBq+W8ntxfpVxm0Ws5/OZ+8crOP766+WBNw66fHxbzU1eng89zXw887r2xukCLQPX1Aj2ejuY+fKNJn48TsyeTLpTnN7Mnkyz8WHU9E9HDy/Bl9/tfJ8/+ZtP9nhynRm/m8pl82jnm3MM7M58824q8Rvax8P+vHyxf09bNt+eTFfxP1oJLfPldm083/o6h9qtq58BLPtoMg6Xa7XT/7hYL2xoWdfz9ukYZWZ0iLbeZz8ymIP//4GqM4mi8qk4Y9a744uvo+Wj71RYc/rx7W681WPB+Wq0d1Xysc1fOB20ESeF6QJIFnZ4Et6nqv81XGr2w/84oIbHv5uryt9Xxb92luO18bCF2+T+RoxFo2JxJtU45GhfkfEs8+133f9qmK59T/jhe2n+J+EbeDJMm/U68U5xHVT85M6qUk1f1FtVlAOxV7ROe7n5XutfB8l40cIxucojOxSDdpYGiaZjgj5nYPHbTKhr8MTdM0Yzmf/HKzSaZOPB+T276ryXReqrO68aBou2zkzMbcGvPTKjgvvdWIOpqmaYYjdbd96JdCj7+ZvPtd5auPKo8+qvxA9MlSOj2vPPqo8tXTyrtPpzM35HnlzYPFPI3ffko/fbt+/KMvFsdPPZi897zy6A+Vzh8qX/1pezyb5f77Z3rv/nSWyLzP+q/XheU+mLz37Ub8Y6IHk+4z+mRj/Hiv+G+gHhRU7TPtNR1pdm2eNRnpNHtpUftU5UNERHq9OuhozWazqRn9WYPOb2/irEFZsmaMyPT3+XIyHUua7Xyfn09B/PnHjyXprcCzN94vOej5kFMPBc+fvPpU3tfqSjmy5wPRZb9pDEk3qwNNc2K9fsb3P191/Ir2kzViQ9M0Y0D1xYr2b2c93/J9uplP2B9KvbG4eiZbbH47Ph9R/YyLhh5H5/P6Uea/Xzx7Xnei/dqnIp5T/zte2H4KnnvcDrp16WiLZW73q7fTqJ/lvzNT96vZrs5F52tWo87ufy+O6Hz3s9y9Fg1dDju9rDWkYa8XLqX3wzRLHcQsu8n2tpQPpUv5qMotEavXsk5BGlrz7AvOS45mcYZRvN58dvVw8uHPlf4zyr7i+/4Zfb+U/r8viIjkC/rbS/rNGRERvaYff6aPH06P+a/36YcX68fT66XjM/MfEUnVDJDCcv8l6d0asRq9+Zk+/Izo/uSdnyv/LC43N/4Xla+eErFJ65vp3OvNcneK/7rrQUXVPomyfeRNPwhcPXa2/XUoymepaRGl6UbiSnsLe9b0rqC0d3g73DsfxfGhZTiSmOn6fvbpf/N893g+bNbDDs+f9frMva8PcCvPByKS45TSsaTsz9Fmubueb3664jqun9cVyt3XbdVzrpu5T3PySc9H8/61aOi06F0Tpecjqndb+nKaOv+94jnguu/bPq/1etHxtp+N5161HfimHKzMFb6BeruF+gmjmFXv0+LrSV5j2cZ0RedbRn/yds53L79a/JPXGMloc0MRVfq+eI0R0/3EnKfIyzLzVwoto+Z1W13TZSTjYWf6nXZRuXJ89XhYjUjS5vQ5VToR/eU5PX9E7AXd+4ze/Lny/fz49ydfvloc9uYfZcbzz3/QO7+m3zL68XnlvUf0yeywonIV8csXlU7Wx/2AHn8zefyw8vWLQ+K/1npQUbXPqbA/bPkmDTvbehdb8smlaG/CDlomm89E356Pwr75qI5PQ6uZnT63Pd/1RGiFpT4fVM+f3PpU3Nd7u6Xng8re56uuh9zriHrO3OJ9mp6PpN+yedi739Dl0Fh+pKS9gTRdOQiJ7K357xPP3tddoej467xex9h+VOUyncWS9IagMFw+/lrr7Zbq5+JSug1B1GCS2Bk/pzqTg/TtPd99LHWv07Gkeo0TrUWgSt9XOpYUDza/GSor/6Kie1azR0RceL7bFj0rvIFy5ZjoU2K03hNVpRMRvaj89HTy2w8q7z2gH/+0dPzLyqPdXxM8IJ5fT97LBokfTX73Kb35blu5TBH/3Gv64SX9rnZo/NdZDyqq9pnhdteUwyEzu/Z5s7B/UZzPHoTnmtIxmtnnbeElrT1+eekhs28+uxyf9qLYbNU4UVrm80H1/FHUZ+59fUjRt/F8UAaz//nmpyuuI+p5Gswt3qdpbxCbrTM+rupy1F878dDSQiKi2dBaSffvAdc9P/ay6m1/R9d+VOXKYcfq3fcSN7AvZn8tbqDebqV+svztBht1BtXu2ZmcznUqOl9WTjxH1R7yLE8OCaOYmV07m/HNhW2LpfS24FlqS8+G/qfScfYpbV1OehjFujt/4UHY3rQAVblERHRxuTG3JyO8tdcGVLjt2bmHFZ5XCV5Ufnp/0n4yXQfjkyezudcvKj+9P/n9QyIi9pB+94B+PF/80g8v6Td/nHz4c+Xvr5fyebCYFf3Jk8nnB62apyz3ovLmAX34svI90d+/o3fep1/G28rNy4c9mTx+OFv04wP6+MEO+ahdYz2oqNonzWYtWr1e05Grcytz2mdBPvuSl9lDggu7pa/8RHXfTQv1uiYN51NGC/LJv7/yjue2582nXXO7oc/GAhT3UTZX2+br+SgVPH/y6lN5X2eO//mgsuf5FtVD7nVfP68Dy506kXq+rftUJYxiZvrujie7b/5lXPei0PevtxP+O05EqvZTWG5oOTEzFzN/D2tvx18/YRSzep2NztMwkvU6m80kKjjfgniO/3z3sPJqY2gZjqy7fpIkSbdB5+EifUgtP0kS361Lp7MyeBdaTszc7G1kXpweWoaT5ZMk3QZFswJU5RJln/PJ9PPeOGbZhIFt0l6fGt0kSZLEb9HQWHycKjyvMnz9ReWXTydfvpo8fzX5mGZzr4m+/qJCjybPX02+fDr55enKqnnff0vvPKA3362MDc+Pf/5q8jFV/v6CDpNf7mv6ZTbRQo6JaLEqn7Lcl5V/f7aej3xW+eGzSTtbafubCf258vWLbfmoXWs9KKjap/AWU65Dy4l1d9ES89qnKp99w+kPZd2d5jIexWs/zbvvpu+2d1s0MOZj7IX55MSvOD7t9aNGN7uREr++dCcp7qPQcmZZ58Sfd8Lq509Ofarv66njfz4o7He+yviV1z20jCFz/Sz31fS3tp5v7T5V/lYUE1E82H6y++Zf0nUvKOCAejvpv+OkbD/F5YaWMaRFB/vA9nb09XNxKRmT45To4pKm/5qWqzjfeHjZ6M7iWf8y+OjPd3eVe/fu3VbZV6b6AkB4SSO6lW+vAOBY4PmwA+ElrUujeL7TFqjnQ3A78Ku3M8mCqJTrXha0n2J3rX7envM96W1lNq4B55xz4a2+dw0AdxGeDwrCXixKXMKXp6jnA6wuyHdDZZZ73cuC9lPsrtXP23O+v9p+yMngdrtbZyTlaPMLTAC42/B8mAnPI6+buIyIZFz6l6eo5y2El7g6ydhp3nD1XO91LwvaT7G7Vj8nfL4nPTkEjki//01uerv9xQ1HAgAAAHCLNkav+XxLtjQ9zg+3sIbbXtfUGZEcrs6l40LQRbjbZcR1BwAAACjDWvdaeH6LxVIS0WXUT0N0tPbAhbh/sWt3tjyibbKRoW1+08fPWm51EFo7xMPtdrtKRMSYLtdet+FcEIVpyoWgEC0CAAAAoNDm3Gs5sK5zhovwEpecjdc/ubDbLVPPZoUdvjHYdVsMFG8EKTzf1Sl2durOlhmScpOitNfUdswk7VkWEWUv567lf9ZtUSdMRdttROheAwAAABTbd+UQzhezCMojPN+tXw4MTdM0Y7S8FPtREZ5v0sjQNM0Y0MruItwOXBbHOy55ekr4WZ1G5ynx2ny5eAAAAABQ2rF7LbzEs+0gSLrdbtdfrAvPbS/I9pkIVjbayUvndpAkiavPN7+YZZPt2tHsZSOjaW8Qs/oZJ24HywvQC2+6fwa3gyTwvCBJAs+2gyRJEm9bd1wRJxdL6Vu79KKhy2G/lxJRGvaHcmXTvJHTtKItGSzFI/LLVdWbJ4SqQn2TzSp0sb+I8JKVKl7kP8vFtr21fYA2TtcLgiDwTcbM7vz/t9cSAAAAwJ22++i1Xq8OOlqz2WxqxnS3ZeH5Jg0MTdMMZ8Tc+Zhzfnraa2qa5sREsaNpmqZNZ4iIhk5xFM77nEGDJKveL47mst80hqSb1YGmObFePyvuKCriPGtQ1NGyMfPV4egcvMZoviERpePlTVLTXm+PCTXC8102cgxN07RORGdikZ4bJ5HeamSBGo7U3baYFtrUNM0YylmFLt5rDC1tWtfr9SCd6eh7fdvmuqHV6XQGMcVDo9MZSYodo9PpH+msHQAAAIAjsXv3Wo76s4m305f3stHcMBvNnY05F6Tn4zWW9a5F29Wlo2mdiNjWYMYppWNJO81XUMYT9qzpkDmlvShe6i4X4HYwG/bd+iGgIJ7ObLA+nPfMC+ptXvlpuGucinKX8t/6C2lKNSYvz9P0fpXFUZhiUREAAACALa6wrYzqnTr1u3Zbs4sHIRFdXEqqHhZTtmB/Jp6+QFkQj7CDlsnmnXl5WZTPVNpraj0iErRb537DIfW2GDU/3H7Xhdteu0qMMaK2V2U6EXlerX+s75wCAAAAHIkrdK/TsaR6bXN/eFV6AVbjFI4lmQ1B4cX96tbRa5XQ0jYmaSjjEZ5rSsdoZuPCwktae+Rz4IeIgngOqLdSylU4j6KzRkuXIyeiRovFoyga49VGAAAAgC32XTlkWRjFzGwLTkRc2C1djs7TonQiyoamVyY3pGOZzbII+07M3CTpNkjOfqC3smkYXNitbXOF946TiOTltLO8S/5ZPtnrlaJtsjg6bAHDMIqZ2bXF7MxssTXOgy1X9Xr+hb+YpmE4JhYPemE4JiajXhje+JLeAAAAACfnCqPXRKFl1Lyun7hEJGOnM5s4oEonyhYGqbt+YtJs2kXYH7b8ls3DXmg1VzqsltMIskNl7IxiqpcbZ9gfNrpuYrq75j/LxySS8dBYmjKymEyiJ4m7Pp8kJx/yuq6flTzsWMVxHiy0nEaQhTs0mr00tIxa4PuJSzIebj/f2Vp8oqHHkVV8LAAAAAAQEVHl3r17S/8pvKQRFXYNrwW3A78unY6FXUtujPCS1uXqJup0lQbQ73+Tm95uf3FIeAAAAACnaXNyyGxR6uJFkcuV9prGgFrdmy/5bhH2bNFsvjr5ZL5OtnvwFBwAAAAAoI3Ra3i7ceF13enW8yV/WYDRawAAAABC9xoAAAAAoERXWTkEAAAAAABWoHsNAAAAAFAadK8BAAAAAEqD7jUAAAAAQGnQvQYAAAAAKA261wAAAAAApfl/D30TpaBPgYkAAAAASUVORK5CYII=
我这里没有这个配置文件呢,只有collect.jsoncoverToWebServerexternalDataSources.jsonmessages.jsonternaryManagement.jsontoken.jsonweb.json 这几个
页: [1]
查看完整版本: 请教给查询配置传参时in查询的写法