Tuesday, August 20, 2013

Pentaho Report Design: Report parameter with SQL 'LIKE' syntax

Awesome Solution...

SELECT * FROM CUSTOMERS
WHERE customername LIKE CONCAT(${name_parameter} , '%')

No comments: