[progress Communities] [progress Openedge Abl] Forum Post: Re: What Is The Best Way To Loop...

[jsniemi79]

Ah, got it. You'll need to add another variable to your where clause. You need to make sure it selects the value for the current appointment. Try this and see if that does the trick. var activityArr = rbv_api.selectQuery("SELECT startDate FROM appointment WHERE R529621 = '10143598' and id = ? ORDER BY startDate DESC", 1, {!id}); if (activityArr.length > 0) { var lastDate = new Date(activityArr[0][0]); } return lastDate;

Continue reading...