[Barcode4j EAN128 Template]

If you want to use multiple AI : use a Barcode4J type barcode, and put either a ñ OR a <GS> character (ASCII: 29 / 0x1D) before your 2nd, 3rd, etc., Application Identifier. 

[User Defined comma separated values in paramter]

Define a parameter p_split_param which is of type java.lang.String[], and 'isForPrompting="false" '

In this p_split_param parameter, put either an empty array (new String[0]) if your real input parameter is empty, $P{your_input_param}.split(",") otherwise:

"".equals($P{P_REAL_INPUT_PARAM}) ? new String[0] :  $P{P_REAL_INPUT_PARAM}.split(",")

 

In a dummy P_WHERE_CLAUSE parameter (= isForPrompting="false" ), put: 

$P{p_split_param}.length == 0 ? " " : " WHERE $X{IN, table_id_column, p_split_param}

In your queryString put:

select ... from ...
$P!{P_WHERE_CLAUSE}

[Logging of SQL query executed...]

You can create a log4j.properties file like this one:

#############################################log4j.appender.fileout=org.apache.log4j.RollingFileAppenderlog4j.appender.fileout.File=C:/tmp/jasperstudio.loglog4j.appender.fileout.MaxFileSize=16000KBlog4j.appender.fileout.MaxBackupIndex=2log4j.appender.fileout.layout=org.apache.log4j.PatternLayoutlog4j.appender.fileout.layout.conversionPattern=%d{ABSOLUTE} %5p %c{1},%t:%L - %m%nlog4j.rootLogger=WARN, fileoutlog4j.logger.net.sf.jasperreports.engine.query=FINElog4j.logger.net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.level=FINE#############################################

Reference this file in your Jaspersoft Studio[ Professionnal].ini file (which is located in the same directory as jasper studio' exe):

-Dlog4j.configuration=file:/c:/path%to%log4j.properties%file/log4j.properties

Then restart Jaspersoft Studio.