Add aggregate functions and total footer to record list widgets

By Gerry on 9 Jul 2012
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.
J.11 Jul 2012
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.
Justin James14 Jul 2012
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
Gonçalo Almeida12 Nov 2012
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

J.21 Jun 2010

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
Vítor Oliveira17 Sep 2010
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
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
Joanna Gaynor14 May 2015
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
Miguel Ribeiro19 Aug 2010

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
Rodrigo Diniz19 Mar 2014
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
Ana Ramalho4 Jul 2014

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
freek1 Apr 2015
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
Daniel de Witte1 Apr 2015
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 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