Equality comparison for null fails in input control, 4.7

Issue:

In 4.7 the following query for a query-based input control will fail when the value of parameter is null:

select * from foo where column = $P{parameter}

Resolution:

Query-based input controls now support the $X{} syntax to handle equality comparisons with null values as input. The following query will fail when the value of parameter is null:

select * from foo where column = $P{parameter}

Instead, use the following syntax:

select * from foo where $X{EQUAL, column, parameter}

The $X{EQUAL...} syntax will generate the correct SQL to compare the value of the parameter when it is null. For any other types of comparison, such as greater than, use the $P{} syntax.

References:

4.7 Release Notes - Upgrading Input Controls to 4.7 http://support.jaspersoft.com/download_preview.php?pl=1#ReleaseNotes