Auto calculate total sum of a column with numeric data in datatable footer

Question

When numeric data are listed in a <p:dataTable> (or <h:dataTable>), is there any way to get the total sum in the summary row in table's footer without calculating it in the backing bean and providing it as again another bean property?

did you try javascript? – Johny T Koshy Dec 08 '13 at 20:59 — Johny T Koshy, Dec 08 '13 at 20:59
How can I use Javascript? – Buddhika Ariyaratne Dec 09 '13 at 02:09 — Buddhika Ariyaratne, Dec 09 '13 at 02:09

BalusC · Accepted Answer · 2015-08-24T13:06:54.267

18

If your environment supports Java EE 7's new EL 3.0 (e.g. WildFly 8), then you can make use of new support for Java 8-like Stream and Lambda operations in EL (yes, this works even when using Java 7).

In your particular case, you can use the EL 3.0 equivalent of Java 8's IntStream#sum() (or DoubleStream#sum(), depending on property type):

<h:dataTable value="#{bean.items}" var="item">
    <h:column>
        #{item.number}
    </h:column>
    <f:facet name="footer">
        Total: #{bean.items.stream().map(item->item.number).sum()}
    </f:facet>
</h:dataTable>

edited Aug 24 '15 at 13:06

answered Aug 26 '14 at 18:56

BalusC

1,082,665
372
3,610
3,555

2

Works well, but not when you filter the datatable. How can you manage it ? – Quentin T. Apr 24 '17 at 12:03

Auto calculate total sum of a column with numeric data in datatable footer

1 Answers1

Linked