for dataset scripting , can you pls provide some sample for groovy too ?

Question

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} ');

}

Answer 1

Dear kstang,

basing on your case, this is an example of a similar groovy script (I'm using foodmart demo dataset):

def condition1 = "";
def family = parameters.get('FAMILY');

condition1 +=" and pc.product_family = "+family;

query = query.replaceAll("PLACEHOLDER_FAMILY", condition1);

Regards

Matteo

Comments

noted with thx. Merry christmas