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

datatable, el, jsf, primefaces, sum

Solution

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>

Problem

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?

Original source