anubha0408

hi All, I am having the same issue. Its working fine on JasperStudio but not on jasperserver. Has anyone resolved it ? Regards Anubha

Hi, is it resolved. I am having the same issue. Thanks and regards Anubha

HI Luke, NOTIN , IN are working fine in SQL query. i am looking for something to work similar to "LIKE" in SQL for arraylst or collection type of parameter. Regards Anubha

Hi Luked, Thank you for your response. However, i am looking for something which i can use in Query itself same as using IN or NOTIN. Any suggestions? Regards Anubha

Hi Luked, Thank you for your response. However, i am looking for something which i can use in Query itself same as using IN or NOTIN. Any suggestions? Regards Anubha

HI Team, Please assist on using arraylist parameter for LIKE values. We have a multiselect parameter of arraylist type, and in query I would like to check if any value of arraylist is LIKE '%ABC%'. Please assist how to use $X{LIKE, '%ABC%',parametername} When using the same in query its giving below error: net.sf.jasperreports.engine.JRRuntimeException: No clause function for id LIKE found. at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.resolveFunction(JRAbstractQueryExecuter.java:306) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.appendClauseChunk(JRAbstractQueryExecuter.java:562) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.appendQueryChunk(JRAbstractQueryExecuter.java:404) at net.sf.jasperreports.engine.query.JRAbstractQueryExecuter.parseQuery(JRAbstractQueryExecuter.java:379) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.<init>(JRJdbcQueryExecuter.java:176) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuterFactory.createQueryExecuter(JRJdbcQueryExecuterFactory.java:207) at com.jaspersoft.studio.data.jdbc.JDBCFieldsProvider.getFields(JDBCFieldsProvider.java:67) at com.jaspersoft.studio.data.jdbc.JDBCDataAdapterDescriptor.getFields(JDBCDataAdapterDescriptor.java:70) at com.jaspersoft.studio.property.dataset.dialog.DataQueryAdapters.doGetFields(DataQueryAdapters.java:486) at com.jaspersoft.studio.data.designer.AQueryDesignerContainer$1.run(AQueryDesignerContainer.java:49) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:119)