Multi-Value String Mapping

The multiValue attribute allows a developer to accept a delimited value like "Value1;Value2;Value3" from the user. It will then split out the individual values and bind those separately into the report query during execution.

This type of mapping must always be used in conjunction with the macro${multiSelectFilter}.

This macro will insert the sql fragment once for each value between the delimiters, combining them with an OR conjunction by default. For example:

You can provide a third optional parameter for the conjunction. Possible values are 'OR' and 'AND', where 'OR' is the default value. Thus the following expressions are equivalent:

AND conjunction example:

The above macro will evaluate to:

In case no value is provided for the param, the macro automatically uses "filterIfNotNull" logic to remove the filter entirely.

Please refer to the javadocs for SqlService for more information on the multiSelectFilter macro.

By default, when multiValue is enabled, it allows a maximum of 5 values. If you want to increase this max, you must add an additional explicit attribute:

Also, the max number of wildcard values is controlled independently from the total max. In the example above, you have extended the max number of values to 20, but the max number of wildcards within that 20 is still only 5. (This is done to give you more control from a performance perspective.) To adjust the max number of wildcards within the overall max, use the maxNumberOfWildcardValues attribute.