Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 13:16 Go to next message
Krzysztof Leja is currently offline Krzysztof LejaFriend
Messages: 55
Registered: April 2019
Member
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 10:09]

Report message to a 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 13:31 Go to previous messageGo to next message
Andre Wegmueller is currently offline Andre WegmuellerFriend
Messages: 204
Registered: September 2012
Location: Baden-Dättwil, Switzerla...
Senior Member
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é


Eclipse Scout Homepage | Documentation | GitHub
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 10:20 Go to previous message
Krzysztof Leja is currently offline Krzysztof LejaFriend
Messages: 55
Registered: April 2019
Member
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:
  


Current Time: Thu Nov 14 21:51:19 GMT 2024

Powered by FUDForum. Page generated in 0.03445 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top