[progress Communities] [progress Openedge Abl] Forum Post: Re: Aggregation

[Ricardo Perdigao]

Hi Giorgi, Here is a resource that might be helpful: I've created a sample for you using the Customer table on the Sports2000 Database. Here is the steps I've followed: ========= Created a Grid for Customer using a blank view ========= Created a REST Service for Customer in the Sports2000 database (PDSOE) Created a DataSource in KUIB to access my Service Created a View using the Blank Template on KUIB 1.1 Created a DataSource called customerDS and pointed to Customer data Created a Grid called customerGrid and linked customerDS to it ======================================================= ============ Implement Aggregate on view-factory.js ============ onShow: function($scope, customData) { this.scope = $scope; // Aggregate the value of CreditLimit for min and max $scope._$ds['customerDS'].aggregate([{ field: "CreditLimit", aggregate: "min" }, { field: "CreditLimit", aggregate: "max" } ]); // Change the template on a single column on the Grid to display aggregates for CreditLimit for (var i = 0; i Min: #= min # Max: #= max # '; } } }, ======================================================= I don't know how familiar you are with KUIB 1.1, so it is hard for me to know how much detail you will need. Please let me know if you need further explanation on the sample above. Warm Regards, Ricardo Perdigao

Continue reading...