I have a problem here, if any there parameters is null, eg, select entry.date, entry.msisdn, entry.content from entry where entry.date = null and entry.date = $P{dateTo},How can I get the result set for entry.date = $P{dateTo}
SELECT * FROM TABLE WHERE A = X AND B = Y; When A = X and B = null, I hope to query out ALL RECORDS for 'X', accordingly, when A = null and B = Y,I hope to query out ALL RECORDS for 'Y'.How to make it happen ?