Skip to Content (Press Enter)
Back to Ideas
68
Like
Follow Idea
Add aggregate functions and total footer to record list widgets
1922Views
17Comments
On our RadarOn our Radar
Frontend (App Interfaces)

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.

09 Jul 2012
Copy link to comment
2016-04-21 20-09-55
J.
 
MVP
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.
11 Jul 2012
Copy link to comment
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
14 Jul 2012
Copy link to comment
Just to workaround this, you can look at the ROLLUP keyword in SQL ;)

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

12 Nov 2012
Copy link to comment
2016-04-21 20-09-55
J.
 
MVP

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
21 Jun 2010
Copy link to comment
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
17 Sep 2010
Copy link to comment
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
09 Mar 2015
Copy link to comment
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
14 May 2015
Copy link to comment

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
19 Aug 2010
Copy link to comment
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
19 Mar 2014
Copy link to comment

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
04 Jul 2014
Copy link to comment
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
01 Apr 2015
Copy link to comment
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
01 Apr 2015
Copy link to comment
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
03 Apr 2015
Copy link to comment
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
03 Apr 2015
Copy link to comment
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
17 Nov 2015
Copy link to comment
2016-11-21 23-23-05
Gonçalo Borrêga
Merged this idea with 'Table footer' (created on 2010-06-21 07:57:04 by J.)
25 Oct 2016
Copy link to comment
Changed the category to
Frontend
30 Jul 2021
Copy link to comment

Having the capability to add a footer to a table would be huge plus for various reasons. It is in the HTML specifications, why is this not available in OutSystems with the Table widget?

08 Nov 2023
Copy link to comment