Eclipse Community Forums: Eclipse Scout » Aggregating columns in a table according to a different algorithm than the one built-in

Home » Eclipse Projects » Eclipse Scout » Aggregating columns in a table according to a different algorithm than the one built-in

Aggregating columns in a table according to a different algorithm than the one built-in [message #1820709]

Mon, 27 January 2020 08:16

Eclipse User

Hi,
Scout provides built-in support for grouping and aggregating data in tables for columns that store numeric data (INumberColumn), using one of four aggregation functions:
- minimum
- maximum
- average
- sum

This is a great thing, speeding up the generation of various statistical data sets.

But is there any simple method to add my own, custom data aggregation function (e.g. to support text/date columns or other ways of aggregating numeric fields)?

[Updated on: Tue, 28 January 2020 05:09] by Moderator

Re: Aggregating columns in a table according to a different algorithm than the one built-in [message #1820763 is a reply to message #1820709]

Tue, 28 January 2020 08:31

Eclipse User

Hi Krzysztof

In my opinion there's no simple method to extend the aggregations provided by Scout. Of course you could try to extend the Scout framework-code, but it looks like this part is not built with extensibility in mind. The relevant code is found in NumberColumn.js and aggregation.js but you would also need to change Java code. So you'd basically have to fork the Scout RT or find a clever way to override or replace existing classes with your own code.

In our own business applications built with Scout we use the built-in aggregations primarily for simple ad-hoc data analysis configured and performed by the user in the UI. For other statistical data requirements we have a separate "reports" outline that creates reports and exports data on the server-side, where you can aggregate the data any way you want. This approach has the advantage it can deal with a lot of data too. The UI is much more limited in how many table-rows it can handle, usually it does not make sense to load thousands of rows into the browser.

Cheers,
André

Re: Aggregating columns in a table according to a different algorithm than the one built-in [message #1821079 is a reply to message #1820763]

Wed, 05 February 2020 05:20

Eclipse User

Thank you Andre for the tip.
It is a pity that the built-in aggregation function cannot be easily extended.
I will therefore follow the path indicated by you, i.e. manually generating summary records on the server side.

Previous Topic:	Update Table Header Text after Smart field value Change
Next Topic:	A quick method of editing text translations

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 07 16:05:49 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter