WhereClauseBinding - innoventsolutions/birt-functions-lib GitHub Wiki

Placed in a DataSet's before method, this functions will add to the where clause to place a SQL snippet into the expression which will be evaluated at runtime binding a parameter and its values to the where clause. Arguments:

1. reportContext
2. the data set (this)
3. operator (String) "IN" or "LIKE"
4. data type (String)
5. parameter name (String)

The function returns a snippet that needs to be appended onto the end of the query text.

NOTE: the parameter name must match a parameter and is also the name of the field that is being filtered.

Example:

this.queryText += CustomFunctions.WhereClauseBinding(reportContext, this, "LIKE", "string", "customername");