update data in reports from creator/ criteria
I understand how to update data in a zohoreports table with the deluge tasks zoho.reports.updatedata ( BASE, TABLE, map, Criteria) but i don't success to use a criteria depending of the value of an input field.
My example is :
trans1 = map();
trans1.put("Agence", input.Agence);
trans1.put("AFFECTATION ANALYTIQUE", input.AFFECTATION_ANALYTIQUE);
trans1.put("LIBELLE", input.LIBELLE);
a = "AFFECTATION ANALYTIQUE='" + input.AFFECTATION_ANALYTIQUE + "'";
mapResponse = zoho.reports.updatedata("BASE", "Table", trans1, a);
I have tried
a = "AFFECTATION ANALYTIQUE=" + input.AFFECTATION_ANALYTIQUE ;
too
Please an help !