[progress Communities] [progress Openedge Abl] Forum Post: Re: How Can I Get Calculate...

[Shiva Duriseati]

Hi, Please use the following query in the script component. function callback(arr){ for(var i=0;i<arr.length;i++){ //Do Something with arr[0] and arr[1] (Since we have only two colums Username and Amount) alert(arr[0]+":"+arr[1]);//arr[0] is Username and arr[1] is Sum of the amount } } function process() { rbf_selectQuery("SELECT Username, SUM(Amount) FROM Object_A GROUP BY Username", 100, callback); } But ,instead of doing this you can still make use of view where you can apply filter logic on any field. documentation.progress.com/.../index.html Regards, Shiva

Continue reading...