jem_2

Hi, I am using Jaspersoft Studio 6. I have a paramater where I need to have multiple selection of list. The class is collection. How should I define the values which are fetch from database? Is the class correct? I appreciate your response. Thanks!

I found a solution, but I am not sure if this will work but I will check further.. SELECT * orderlist WHERE tenant_id = 200 AND call_start BETWEEN $P{tbStartDate} AND $P{tbEndDate}AND ( $P{tbunique_id} is NULL or unique_id LIKE '%$P!{tbunique_id}%') Thank you. I appreciate the help.

Hi, I have tried it as well but no luck. By the way, I have a dataset which holds my queries and parameters. Query inside dataset as below. SELECT * orderlist WHERE tenant_id = 200 AND call_start BETWEEN $P{tbStartDate} AND $P{tbEndDate}AND unique_id = $P!{tbunique_id} The highlighted one is my dynamic filter. What happening it does not execute my query if my unique_id is null. Kindly help me with the query. Also, do I have to change my defaullt value expression of each parameter as well? Thanks!

Hi, I am a newbie and I am challenged on how to set dynamic filtering query. I have 4 parameters (startdate, enddate, uniqueid, orderid) where startdate and enddate are my static query and rest are dynamic. My mandatory field are startdate and enddate, if no input for uniqueid/orderid, it will give me all result within the range, else if uniqueid/orderid, it will search in the table the uniqueid/orderid if it is there within the range. Please let me know what I should do. I am using Jaspersoft Studio 6.3.1 Thanks!