1
 Follower
61
 Likes

Add aggregate functions and total footer to record list widgets

Aggregates & Queries
On our radar
Need to be able to show a total footer at the bottom of record list widgets (Table Records & List Records) and the functions necessary to calculate totals, etc.
Created on 9 Jul 2012
Comments (16)
I like the idea if a footer, but the functions of calculating totals is too dependant of what you actually want to see in the footer.
If there was a way to do a footer that we could add Expressions to, it would be a snap to just set local variables to the values we want the totals to be.

J.Ja
Just to workaround this, you can look at the ROLLUP keyword in SQL ;)

http://msdn.microsoft.com/en-us/library/ms189305(v=sql.90).aspx

Merged this idea with 'Table footer' (created on 2010-06-21 07:57:04 by J.)

Sometimes it would be handy to have a table-footer in the table widget.
especially with paging


Merged from 'Table footer' (idea created on 2010-06-21 07:57:04 by J.), on 2016-10-25 08:06:05 by Goncalo Borrega

There should be a row that would appear only once at the bottom at the table records.
This would be awesome for sums or something like that


Merged from 'Footer row in table records' (idea created on 2010-08-19 11:34:38 by Miguel Ribeiro), on 2016-10-25 08:07:23 by Goncalo Borrega
Yes, it would be great to add Totals.

Merged from 'Table footer' (idea created on 2010-06-21 07:57:04 by J.), on 2016-10-25 08:06:05 by Goncalo Borrega
This is really missing !! It shoudl be just like ShowHeader

Merged from 'Footer row in table records' (idea created on 2010-08-19 11:34:38 by Miguel Ribeiro), on 2016-10-25 08:07:23 by Goncalo Borrega

I agree.

Merged from 'Footer row in table records' (idea created on 2010-08-19 11:34:38 by Miguel Ribeiro), on 2016-10-25 08:07:23 by Goncalo Borrega
With aggregates we can group data and use some operations like SUM, COUNT, etc, but without group footers\grand totals they are as usefull as Simple Queries.

If we list numeric values in a TableRecords widget, the probability of the costumer asking for a grand total row is huge.
At this moment we still need to do a query for the table results, then do another query to calculate the grand total or just cycle the first query and calc all the values, one by one. Then we need to "inject" a new line with the grand total in the RecordList that will bind to the TableRecords.

Aggregates could do this automatically. We could have totals for each group and a grand total at the bottom of the table.


Merged from 'Aggregate + TableRecords: Group Footers & Grand Total' (idea created on 2015-03-09 12:56:49 by Carlos Henriques), on 2016-10-25 08:06:23 by Goncalo Borrega
Agree!

Merged from 'Footer row in table records' (idea created on 2010-08-19 11:34:38 by Miguel Ribeiro), on 2016-10-25 08:07:23 by Goncalo Borrega
Table/Grid footers are a must have!
It could be done with code, however outsystems claims to be a RAD tool so this feature should not be missing.

Merged from 'Footer row in table records' (idea created on 2010-08-19 11:34:38 by Miguel Ribeiro), on 2016-10-25 08:07:23 by Goncalo Borrega
Agree that this is something that is missing.

Ofourse you can make a widget for this but since cells and tables are kind of "flexible" it's pretty difficult to get columns aligned properly.

Merged from 'Footer row in table records' (idea created on 2010-08-19 11:34:38 by Miguel Ribeiro), on 2016-10-25 08:07:23 by Goncalo Borrega
Also kind of interesting how you would handle this with pagination by the way. :)

Merged from 'Footer row in table records' (idea created on 2010-08-19 11:34:38 by Miguel Ribeiro), on 2016-10-25 08:07:23 by Goncalo Borrega
I was just looking on the forum for something that did this simply


Merged from 'Aggregate + TableRecords: Group Footers & Grand Total' (idea created on 2015-03-09 12:56:49 by Carlos Henriques), on 2016-10-25 08:06:23 by Goncalo Borrega
I was looking for an answer on how to do this with outsystems, but just like many features, it just does not exists or you have to make a workaround. 
Meaning this to me is getting more and more SAP (Slow Application Development)


Merged from 'Footer row in table records' (idea created on 2010-08-19 11:34:38 by Miguel Ribeiro), on 2016-10-25 08:07:23 by Goncalo Borrega
views
597
Followers
1