P
Paulh0763
Guest
Returning undefined...see debug log Parsed Formula 001 var rbv_api = new Packages.com.rb.core.services.api.ServerSideAPI(9355387, 9356526); 002 003 function wrapper() { 004 rbv_api.setVerbose(true) 005 006 var activityArr = rbv_api.selectQuery("SELECT startDate FROM appointment WHERE R529621 = '10143598' AND id = ? ORDER BY startDate DESC", 1, 29033275); 007 008 if (activityArr.length > 0) 009 { 010 var lastDate = new Date(activityArr[0][0]); 011 } 012 rbv_api.println(lastDate) 013 return lastDate; 014 } 015 wrapper(); Formula return type: Date/Time (Adjust to user time zone) Debug ==>selectQuery: SELECT A.EVENT_DATE FROM RB_OBJ_DATA A WHERE A.OBJ_DEF_ID=9357701 AND (A.INTG11 = '10143598' AND A.OBJ_ID = ?) ORDER BY A.EVENT_DATE DESC arg[1]: 2.9033275E7 undefined Result NULL Do you think I need perhaps an actual date field and a trigger that will set that date field using the above script? Thanks again...appreciate the help.
Continue reading...
Continue reading...