[REST API & Collection parameters issue]

hi All,

 

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

 

Regards

Anubha

[Page number reset based on grouping.]

Hi,

 

is it resolved. I am having the same issue.

 

Thanks and regards

Anubha

[LIKE keyword in Arraylist]

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

[LIKE keyword in Arraylist]

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

[LIKE keyword in Arraylist]

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

[LIKE keyword in Arraylist]

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)