I have the following working sample for Javascript, but I am not sure how to do the same thing with groovy . Can provide some sample ?
//javascript
if( parameters.get('client_id') == "'ALL'" )
{
query = query.replaceAll('client_id_where_clause', '');
}
else
{
query = query.replaceAll('client_id_where_clause', ' and asum."CLIENTID"= \\$P{client_id} ');
}