Hi,
I'm trying to generate a completly dynamical filter for a workflow.
I have a reference attribute in the workflow class with a cql filter only with {client:Filter} filled
The reference attribute points to a superclass. Example superclass ClassA with child ClassB and ClassC.
Now the workflow fills the string field Filter with the cql code like this: from ClassB where Attribute=999
or like this: from ClassA where Attribute1=111 & Attribute2=222 and so on.
The filter works fine but I get every time twice CMDBWorkflowExceptions exceptions.
Is there an alternativ workaround to generate a filter like this or to suppress the exception?
Call: services/json/management/modcard/getcardlist?_dc=1487774290276
---------------------------------------------------------------------
Error: CMDBWorkflowException[type=CQL_COMPILATION_FAILED,parameters={},detailMessage=,cause=org.cmdbuild.exception.CMDBWorkflowException@440bde13,stackTrace={org.cmdbuild.exception.CMDBWorkflowException$WorkflowExceptionType.createException(CMDBWorkflowException.java:53),org.cmdbuild.cql.facade.CQLFacade.compileAndAnalyze(CQLFacade.java:51),org.cmdbuild.logic.data.access.QuerySpecsBuilderFiller.fillQuerySpecsBuilderWithFilterOptions(QuerySpecsBuilderFiller.java:185),org.cmdbuild.logic.data.access.QuerySpecsBuilderFiller.create(QuerySpecsBuilderFiller.java:113),org.cmdbuild.logic.data.access.DataViewCardFetcher.fetch(DataViewCardFetcher.java:200),org.cmdbuild.logic.data.access.DefaultDataAccessLogic.fetchCardsWithClassName(DefaultDataAccessLogic.java:549),org.cmdbuild.logic.data.access.DefaultDataAccessLogic.fetchCards(DefaultDataAccessLogic.java:535),org.cmdbuild.servlets.json.management.ModCard.getCardList(ModCard.java:457),sun.reflect.GeneratedMethodAccessor1662.invoke(Unknown Source),sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43),java.lang.reflect.Method.invoke(Method.java:498),org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:104),org.cmdbuild.servlets.JSONDispatcher.doGet(JSONDispatcher.java:70),javax.servlet.http.HttpServlet.service(HttpServlet.java:622),javax.servlet.http.HttpServlet.service(HttpServlet.java:729),org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292),org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207),org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52),org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240),org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207),org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:188),org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346),org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262),org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240),org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207),org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:48),org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346),org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262),org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240),org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207),org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31),org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240),org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207),org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:52),org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346),org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262),org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240),org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207),org.cmdbuild.filters.LocalizationFilter.doFilter(LocalizationFilter.java:127),org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346),org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262),org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240),org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207),org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212),org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106),org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502),org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141),org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79),org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616),org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88),org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522),org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095),org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672),org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500),org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456),java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142),java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617),org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61),java.lang.Thread.run(Thread.java:745)},suppressedExceptions=[]]
at org.cmdbuild.exception.CMDBWorkflowException$WorkflowExceptionType.createException(CMDBWorkflowException.java:53)
at org.cmdbuild.cql.facade.CQLFacade.compileAndAnalyze(CQLFacade.java:51)
at org.cmdbuild.logic.data.access.QuerySpecsBuilderFiller.fillQuerySpecsBuilderWithFilterOptions(QuerySpecsBuilderFiller.java:185)
at org.cmdbuild.logic.data.access.QuerySpecsBuilderFiller.create(QuerySpecsBuilderFiller.java:113)
at org.cmdbuild.logic.data.access.DataViewCardFetcher.fetch(DataViewCardFetcher.java:200)
at org.cmdbuild.logic.data.access.DefaultDataAccessLogic.fetchCardsWithClassName(DefaultDataAccessLogic.java:549)
at org.cmdbuild.logic.data.access.DefaultDataAccessLogic.fetchCards(DefaultDataAccessLogic.java:535)
at org.cmdbuild.servlets.json.management.ModCard.getCardList(ModCard.java:457)
at sun.reflect.GeneratedMethodAccessor1662.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:104)
at org.cmdbuild.servlets.JSONDispatcher.doGet(JSONDispatcher.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:188)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:48)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:52)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.cmdbuild.filters.LocalizationFilter.doFilter(LocalizationFilter.java:127)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)