Ksql如果实现in

starchen · 发表于 2018-11-26 16:37:12

Ksql如何实现in呢？？？
mainActivity.windowDialog1Receive = function(event){
var data = justep.xbl("bizData1");
var inid = event.data.join(',');
data.setFilter('TEST_APPLICATION_INFO',"TEST_APPLICATION_INFO in('"+ inid +"')" );
data.refreshData();
console.log(data);
debugger;
};

以上是代码，
以下为报错信息：、
2018-11-26 16:36:26 [JVM]start...59624E41901D45B0AF5B6966B31F4FF4, process: /met
rodetection/asset_information/process/sample_diff_manage/sample_diff_manageProce
ss, activity: mainActivity, action: queryDiffAppAction
2018-11-26 16:36:26 excute stream action, params:{executeContext=, action=queryD
iffAppAction, parameters={"filter":"(TEST_APPLICATION_INFO in('85,86,87'))","lim
it":20,"variables":{},"columns":"APP_DOC_ID,APP_DOC_NO,aSSIGNEDMANUFACTUREID,pRO
DUCTMANUFACTUREID,pRODUCTNAME,dETECTIONOBJECTTYPE,dEVICETYPE,bUSINESSID,lINEID,d
ECTIONBASEDONNAME,cONTACTPERSON,cONTACTMOBILE,cONTACTTELEPHONE,cONTACTEMAIL,cONT
ACTADDRESS,cONTACTPOSTCODE,cONTACTFAXNUMBER,aPPLICATIONDATE,eXPECTENDINGDATE,pRO
DUCTSTYLE,cOMPANYTYPE,aPPLICATIONFIELDS,dEVELOPMENTTOOLS,cOMPILERENVIRONMENT,pRO
DUCTCONFIGURATION,fEATURESANDMODELS,tESTINGREQUIREMENTS,oPERATORID,mNITLTELEPHON
E,mNITLFAXNUMBER,mNITLMOBILE,mNITLEMAIL,mNITLADDRESS,mNITLPOSTCODE,rECEIPTER,rEC
EIPTDATE,mEMO,COMPANY_PROMISE,iNSTALLREQUIRE,pROCESSUNIT,ASSIGNED_MANUFACTURE_NA
ME,PRODUCT_MANUFACTURE_NAME,REGISTERED_TRADMARK,PRODUCT_MANUFACTURE_ADDRESS,PROC
ESS_UNIT_ADDRESS,SOFTWARE_VERSION,PRODUCT_TYPE,PRODUCT_LIFE,PRODUCT_BATCH,DETECT
ION_PROJECT,OTHER_INSTRUCTIONS,SAMPLE_RETURN,TEST_DETECTION_JCLCJB_ID,TEST_DETEC
TION_JCLCJB1,fSQR,fSQRQ,fSQWJ,fSQLX,APP_DOC_ID_SQ,fJCJGBG_ID,fJCBGFBGL_ID,bUSINE
SSIDCNAME,bUSINESSIDENAME,TEST_APPLICATION_INFO","offset":0}, executor=, activit
y=mainActivity, process=/metrodetection/asset_information/process/sample_diff_ma
nage/sample_diff_manageProcess, translateParameter={"transformIdcolumn":true,"ro
wsConfig":{"concept":"TEST_APPLICATION_INFO","sequence":"APP_DOC_ID,APP_DOC_NO,a
SSIGNEDMANUFACTUREID,pRODUCTMANUFACTUREID,pRODUCTNAME,dETECTIONOBJECTTYPE,dEVICE
TYPE,bUSINESSID,lINEID,dECTIONBASEDONNAME,cONTACTPERSON,cONTACTMOBILE,cONTACTTEL
EPHONE,cONTACTEMAIL,cONTACTADDRESS,cONTACTPOSTCODE,cONTACTFAXNUMBER,aPPLICATIOND
ATE,eXPECTENDINGDATE,pRODUCTSTYLE,cOMPANYTYPE,aPPLICATIONFIELDS,dEVELOPMENTTOOLS
,cOMPILERENVIRONMENT,pRODUCTCONFIGURATION,fEATURESANDMODELS,tESTINGREQUIREMENTS,
oPERATORID,mNITLTELEPHONE,mNITLFAXNUMBER,mNITLMOBILE,mNITLEMAIL,mNITLADDRESS,mNI
TLPOSTCODE,rECEIPTER,rECEIPTDATE,mEMO,COMPANY_PROMISE,iNSTALLREQUIRE,pROCESSUNIT
,ASSIGNED_MANUFACTURE_NAME,PRODUCT_MANUFACTURE_NAME,REGISTERED_TRADMARK,PRODUCT_
MANUFACTURE_ADDRESS,PROCESS_UNIT_ADDRESS,SOFTWARE_VERSION,PRODUCT_TYPE,PRODUCT_L
IFE,PRODUCT_BATCH,DETECTION_PROJECT,OTHER_INSTRUCTIONS,SAMPLE_RETURN,TEST_DETECT
ION_JCLCJB_ID,fSQR,fSQRQ,fSQWJ,fSQLX,APP_DOC_ID_SQ,fJCJGBG_ID,fJCBGFBGL_ID,bUSIN
ESSIDCNAME,bUSINESSIDENAME,space-column,TEST_DETECTION_JCLCJB1"},"dataType":"row
-list","cellnameByRelation":false,"useNamespace":true}, actionFlag=__action_0__}
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor143.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl
.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.justep.system.action.Engine.invokeActions(Native Method)
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127
)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103
)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http
11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出
错, KSQL: SELECT TEST_APPLICATION_INFO,TEST_APPLICATION_INFO.APP_DOC_ID as APP_DO
C_ID,TEST_APPLICATION_INFO.APP_DOC_NO as APP_DOC_NO,TEST_APPLICATION_INFO.aSSIGN
EDMANUFACTUREID as aSSIGNEDMANUFACTUREID,TEST_APPLICATION_INFO.pRODUCTMANUFACTUR
EID as pRODUCTMANUFACTUREID,TEST_APPLICATION_INFO.pRODUCTNAME as pRODUCTNAME,TES
T_APPLICATION_INFO.dETECTIONOBJECTTYPE as dETECTIONOBJECTTYPE,TEST_APPLICATION_I
NFO.dEVICETYPE as dEVICETYPE,TEST_APPLICATION_INFO.bUSINESSID as bUSINESSID,TEST
_APPLICATION_INFO.lINEID as lINEID,TEST_APPLICATION_INFO.dECTIONBASEDONNAME as d
ECTIONBASEDONNAME,TEST_APPLICATION_INFO.cONTACTPERSON as cONTACTPERSON,TEST_APPL
ICATION_INFO.cONTACTMOBILE as cONTACTMOBILE,TEST_APPLICATION_INFO.cONTACTTELEPHO
NE as cONTACTTELEPHONE,TEST_APPLICATION_INFO.cONTACTEMAIL as cONTACTEMAIL,TEST_A
PPLICATION_INFO.cONTACTADDRESS as cONTACTADDRESS,TEST_APPLICATION_INFO.cONTACTPO
STCODE as cONTACTPOSTCODE,TEST_APPLICATION_INFO.cONTACTFAXNUMBER as cONTACTFAXNU
MBER,TEST_APPLICATION_INFO.aPPLICATIONDATE as aPPLICATIONDATE,TEST_APPLICATION_I
NFO.eXPECTENDINGDATE as eXPECTENDINGDATE,TEST_APPLICATION_INFO.pRODUCTSTYLE as p
RODUCTSTYLE,TEST_APPLICATION_INFO.cOMPANYTYPE as cOMPANYTYPE,TEST_APPLICATION_IN
FO.aPPLICATIONFIELDS as aPPLICATIONFIELDS,TEST_APPLICATION_INFO.dEVELOPMENTTOOLS
as dEVELOPMENTTOOLS,TEST_APPLICATION_INFO.cOMPILERENVIRONMENT as cOMPILERENVIRO
NMENT,TEST_APPLICATION_INFO.pRODUCTCONFIGURATION as pRODUCTCONFIGURATION,TEST_AP
PLICATION_INFO.fEATURESANDMODELS as fEATURESANDMODELS,TEST_APPLICATION_INFO.tEST
INGREQUIREMENTS as tESTINGREQUIREMENTS,TEST_APPLICATION_INFO.oPERATORID as oPERA
TORID,TEST_APPLICATION_INFO.mNITLTELEPHONE as mNITLTELEPHONE,TEST_APPLICATION_IN
FO.mNITLFAXNUMBER as mNITLFAXNUMBER,TEST_APPLICATION_INFO.mNITLMOBILE as mNITLMO
BILE,TEST_APPLICATION_INFO.mNITLEMAIL as mNITLEMAIL,TEST_APPLICATION_INFO.mNITLA
DDRESS as mNITLADDRESS,TEST_APPLICATION_INFO.mNITLPOSTCODE as mNITLPOSTCODE,TEST
_APPLICATION_INFO.rECEIPTER as rECEIPTER,TEST_APPLICATION_INFO.rECEIPTDATE as rE
CEIPTDATE,TEST_APPLICATION_INFO.mEMO as mEMO,TEST_APPLICATION_INFO.COMPANY_PROMI
SE as COMPANY_PROMISE,TEST_APPLICATION_INFO.iNSTALLREQUIRE as iNSTALLREQUIRE,TES
T_APPLICATION_INFO.pROCESSUNIT as pROCESSUNIT,TEST_APPLICATION_INFO.ASSIGNED_MAN
UFACTURE_NAME as ASSIGNED_MANUFACTURE_NAME,TEST_APPLICATION_INFO.PRODUCT_MANUFAC
TURE_NAME as PRODUCT_MANUFACTURE_NAME,TEST_APPLICATION_INFO.REGISTERED_TRADMARK
as REGISTERED_TRADMARK,TEST_APPLICATION_INFO.PRODUCT_MANUFACTURE_ADDRESS as PROD
UCT_MANUFACTURE_ADDRESS,TEST_APPLICATION_INFO.PROCESS_UNIT_ADDRESS as PROCESS_UN
IT_ADDRESS,TEST_APPLICATION_INFO.SOFTWARE_VERSION as SOFTWARE_VERSION,TEST_APPLI
CATION_INFO.PRODUCT_TYPE as PRODUCT_TYPE,TEST_APPLICATION_INFO.PRODUCT_LIFE as P
RODUCT_LIFE,TEST_APPLICATION_INFO.PRODUCT_BATCH as PRODUCT_BATCH,TEST_APPLICATIO
N_INFO.DETECTION_PROJECT as DETECTION_PROJECT,TEST_APPLICATION_INFO.OTHER_INSTRU
CTIONS as OTHER_INSTRUCTIONS,TEST_APPLICATION_INFO.SAMPLE_RETURN as SAMPLE_RETUR
N,TEST_APPLICATION_INFO.TEST_DETECTION_JCLCJB_ID as TEST_DETECTION_JCLCJB_ID,TES
T_DETECTION_JCLCJB as TEST_DETECTION_JCLCJB1,TEST_DETECTION_JCLCJB.fSQR as fSQR,
TEST_DETECTION_JCLCJB.fSQRQ as fSQRQ,TEST_DETECTION_JCLCJB.fSQWJ as fSQWJ,TEST_D
ETECTION_JCLCJB.fSQLX as fSQLX,TEST_DETECTION_JCLCJB.APP_DOC_ID_SQ as APP_DOC_ID
_SQ,TEST_DETECTION_JCLCJB.fJCJGBG_ID as fJCJGBG_ID,TEST_DETECTION_JCLCJB.fJCBGFB
GL_ID as fJCBGFBGL_ID,BUSINESS_TYPE_CODE.bUSINESSIDCNAME as bUSINESSIDCNAME,BUSI
NESS_TYPE_CODE.bUSINESSIDENAME as bUSINESSIDENAME  FROM TEST_APPLICATION_INFO TE
ST_APPLICATION_INFO  optional  join TEST_DETECTION_JCLCJB TEST_DETECTION_JCLCJB
on TEST_APPLICATION_INFO.TEST_DETECTION_JCLCJB_ID = TEST_DETECTION_JCLCJB option
al  join BUSINESS_TYPE_CODE BUSINESS_TYPE_CODE on BUSINESS_TYPE_CODE  =  TEST_DE
TECTION_JCLCJB.fSQLX WHERE ((TEST_APPLICATION_INFO in('85,86,87'))) LIMIT 0, 20
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.BizData.query(Unknown Source)
at System_code.queryDiffAppActive(System_code.java:1485)
... 25 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql:
(SELECT  TEST_APPLICATION_INFO.APP_DOC_ID AS APP_DOC_ID, TEST_APPLICATION_INFO.A
PP_DOC_NO AS APP_DOC_NO, TEST_APPLICATION_INFO.ASSIGNED_MANUFACTURE_ID AS aSSIGN
EDMANUFACTUREID, TEST_APPLICATION_INFO.PRODUCT_MANUFACTURE_ID AS pRODUCTMANUFACT
UREID, TEST_APPLICATION_INFO.PRODUCT_NAME AS pRODUCTNAME, TEST_APPLICATION_INFO.
DETECTION_OBJECT_TYPE AS dETECTIONOBJECTTYPE, TEST_APPLICATION_INFO.DEVICE_TYPE
AS dEVICETYPE, TEST_APPLICATION_INFO.BUSINESS_ID AS bUSINESSID, TEST_APPLICATION
_INFO.LINE_ID AS lINEID, TEST_APPLICATION_INFO.DECTION_BASED_ON_NAME AS dECTIONB
ASEDONNAME, TEST_APPLICATION_INFO.CONTACT_PERSON AS cONTACTPERSON, TEST_APPLICAT
ION_INFO.CONTACT_MOBILE AS cONTACTMOBILE, TEST_APPLICATION_INFO.CONTACT_TELEPHON
E AS cONTACTTELEPHONE, TEST_APPLICATION_INFO.CONTACT_EMAIL AS cONTACTEMAIL, TEST
_APPLICATION_INFO.CONTACT_ADDRESS AS cONTACTADDRESS, TEST_APPLICATION_INFO.CONTA
CT_POSTCODE AS cONTACTPOSTCODE, TEST_APPLICATION_INFO.CONTACT_FAX_NUMBER AS cONT
ACTFAXNUMBER, TEST_APPLICATION_INFO.APPLICATION_DATE AS aPPLICATIONDATE, TEST_AP
PLICATION_INFO.EXPECT_ENDING_DATE AS eXPECTENDINGDATE, TEST_APPLICATION_INFO.PRO
DUCT_STYLE AS pRODUCTSTYLE, TEST_APPLICATION_INFO.COMPANY_TYPE AS cOMPANYTYPE, T
EST_APPLICATION_INFO.APPLICATION_FIELDS AS aPPLICATIONFIELDS, TEST_APPLICATION_I
NFO.DEVELOPMENT_TOOLS AS dEVELOPMENTTOOLS, TEST_APPLICATION_INFO.COMPILER_ENVIRO
NMENT AS cOMPILERENVIRONMENT, TEST_APPLICATION_INFO.PRODUCT_CONFIGURATION AS pRO
DUCTCONFIGURATION, TEST_APPLICATION_INFO.FEATURES_AND_MODELS AS fEATURESANDMODEL
S, TEST_APPLICATION_INFO.TESTING_REQUIREMENTS AS tESTINGREQUIREMENTS, TEST_APPLI
CATION_INFO.OPERATOR_ID AS oPERATORID, TEST_APPLICATION_INFO.MNITL_TELEPHONE AS
mNITLTELEPHONE, TEST_APPLICATION_INFO.MNITL_FAX_NUMBER AS mNITLFAXNUMBER, TEST_A
PPLICATION_INFO.MNITL_MOBILE AS mNITLMOBILE, TEST_APPLICATION_INFO.MNITL_EMAIL A
S mNITLEMAIL, TEST_APPLICATION_INFO.MNITL_ADDRESS AS mNITLADDRESS, TEST_APPLICAT
ION_INFO.MNITL_POSTCODE AS mNITLPOSTCODE, TEST_APPLICATION_INFO.RECEIPTER AS rEC
EIPTER, TEST_APPLICATION_INFO.RECEIPT_DATE AS rECEIPTDATE, TEST_APPLICATION_INFO
.MEMO AS mEMO, TEST_APPLICATION_INFO.COMPANY_PROMISE AS COMPANY_PROMISE, TEST_AP
PLICATION_INFO.INSTALL_REQUIRE AS iNSTALLREQUIRE, TEST_APPLICATION_INFO.PROCESS_
UNIT AS pROCESSUNIT, TEST_APPLICATION_INFO.ASSIGNED_MANUFACTURE_NAME AS ASSIGNED
_MANUFACTURE_NAME, TEST_APPLICATION_INFO.PRODUCT_MANUFACTURE_NAME AS PRODUCT_MAN
UFACTURE_NAME, TEST_APPLICATION_INFO.REGISTERED_TRADMARK AS REGISTERED_TRADMARK,
TEST_APPLICATION_INFO.PRODUCT_MANUFACTURE_ADDRESS AS PRODUCT_MANUFACTURE_ADDRES
S, TEST_APPLICATION_INFO.PROCESS_UNIT_ADDRESS AS PROCESS_UNIT_ADDRESS, TEST_APPL
ICATION_INFO.SOFTWARE_VERSION AS SOFTWARE_VERSION, TEST_APPLICATION_INFO.PRODUCT
_TYPE AS PRODUCT_TYPE, TEST_APPLICATION_INFO.PRODUCT_LIFE AS PRODUCT_LIFE, TEST_
APPLICATION_INFO.PRODUCT_BATCH AS PRODUCT_BATCH, TEST_APPLICATION_INFO.DETECTION
_PROJECT AS DETECTION_PROJECT, TEST_APPLICATION_INFO.OTHER_INSTRUCTIONS AS OTHER
_INSTRUCTIONS, TEST_APPLICATION_INFO.SAMPLE_RETURN AS SAMPLE_RETURN, TEST_APPLIC
ATION_INFO.TEST_DETECTION_JCLCJB_ID AS TEST_DETECTION_JCLCJB_ID, TEST_DETECTION_
JCLCJB.fID AS TEST_DETECTION_JCLCJB1, TEST_DETECTION_JCLCJB.fSQR AS fSQR, TEST_D
ETECTION_JCLCJB.fSQRQ AS fSQRQ, TEST_DETECTION_JCLCJB.fSQWJ AS fSQWJ, TEST_DETEC
TION_JCLCJB.fSQLX AS fSQLX, TEST_DETECTION_JCLCJB.APP_DOC_ID_SQ AS APP_DOC_ID_SQ
, TEST_DETECTION_JCLCJB.fJCJGBG_ID AS fJCJGBG_ID, TEST_DETECTION_JCLCJB.fJCBGFBG
L_ID AS fJCBGFBGL_ID, BUSINESS_TYPE_CODE.BUSINESS_ID_CNAME AS bUSINESSIDCNAME, B
USINESS_TYPE_CODE.BUSINESS_ID_ENAME AS bUSINESSIDENAME, TEST_APPLICATION_INFO.aP
PLICATION_NO FROM TEST_APPLICATION_INFO TEST_APPLICATION_INFO LEFT JOIN TEST_DET
ECTION_JCLCJB TEST_DETECTION_JCLCJB ON TEST_APPLICATION_INFO.TEST_DETECTION_JCLC
JB_ID = TEST_DETECTION_JCLCJB.fID LEFT JOIN BUSINESS_TYPE_CODE BUSINESS_TYPE_COD
E ON BUSINESS_TYPE_CODE.bUSINESS_ID = TEST_DETECTION_JCLCJB.fSQLX  WHERE  TEST_A
PPLICATION_INFO.aPPLICATION_NO IN (?) ), binds: [85,86,87]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 30 more
Caused by: java.sql.SQLException: Implicit conversion from datatype 'VARCHAR' to
'INT' is not allowed.  Use the CONVERT function to run this query.

at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365
)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:4
18)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedSta
tement.java:693)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:96)
... 31 more