L
lCira9
Guest
Hi, My EVAL block is completely working in the Test EVAL[ ]. However, when I put it in an Email Template there is an error: ERROR: Error missing ) after for-loop control (line #4) in formula: var rbv_api = new Packages.com.rb.core.services.api.ServerSideAPI(1, 5790); function wrapper() { var email = rbv_api.selectQuery("SELECT email, id FROM collector",20000); var user = null; for (var i = 0; i email.length; i++) { if ( "bobsemail@gmail.com" == email[0]) { user = email[1]; }... This error also occurs when you remove the quotes in "bobsemail@gmail.com" when in Test EVAL[ ]. But in the email template, even if there are quotes, the error occurs. This the whole eval block: var email = rbv_api.selectQuery("SELECT email, id FROM collector",20000); var user = null; for (var i = 0; i email.length; i++) { if ( "{!#CURR_USER.email#text}" == email[0]) { user = email[1]; } } var statementList = rbv_api.selectQuery("SELECT statement_collector, id FROM statement",20000); var index = 0; var total = 0; for(var j = 0 ; j statementList.length ; j++) { if(statementList[j][0] != null && statementList[j][0] == user) { var currDate = rbv_api.formatDate(new Date(), "yyyy-MM-dd"); var paidList = rbv_api.selectQuery("SELECT amount_paid, createdAt, R8427 FROM pr_receipt", 20000); for(var i = 0; i paidList.length; i++) { var date = rbv_api.formatDate(paidList[1], "yyyy-MM-dd"); if(currDate == date && paidList[2] == statementList[j][1]) total += +paidList[0]; } } } return total; Thanks.
Continue reading...
Continue reading...