11

I am trying to implement multisort on Primeface datatable. We are using Primefaces v3.5. I have created a new load method in the LazyLoadClass that takes the List of SortMeta> parameter.

But I am having issues in the initial load of the table. The List of SortMeta> is null when the load method is called. I have also tried without specifying the initial sortBy and sortOrder for the datatable. In both the cases the result is the same.

Seeing that we have this new class SortMeta to support multisort, I suspect that the way to specify the initial sort field and order would have also changed. But I couldn't find any example anywhere to point the difference. The manual 3.5 doesn't mention any difference.

Why we could be getting the List of SortMeta> as null? Any pointers on example code where multisort is used with Lazyload?

Cœur
  • 37,241
  • 25
  • 195
  • 267
Murali D
  • 448
  • 1
  • 4
  • 18
  • You need to provide a list of SortMeta to sortBy. – Cagatay Civici Mar 04 '13 at 14:18
  • OK. Earlier we were giving the String of name of the column, but now, as I understand, we have bind it to a List object on the bean. Thanks! Will try this out. – Murali D Mar 04 '13 at 15:17
  • @CagatayCivici I tried `` and I have created preSortOrder as `private void buildSortOrder() { SortMeta sm1 = new SortMeta(); sm1.setSortField("resolvedDateTime"); m1.setSortOrder(SortOrder.DESCENDING); preSortOrder.add(sm1); }` but a NPE is thrown bcs the method encodeColumnHeader in DataTableRenderer is accessing UIColumn as `sortIcon = resolveDefaultSortIcon(columnSortByVe, meta.getColumn().getValueExpression("sortBy"), meta.getSortOrder().name());` – Murali D Mar 05 '13 at 09:50

1 Answers1

22

I was able to get this to work.

Essentially we need to provide the UIColumn in the SortMeta object for it to work. For the initial sort at render time, I had to find the component in my bean and assign that to the sortMeta.

Below is my code in the view xhtml

        <p:dataTable id="transDataTable" var="trans" 
        value="#{myBean.transModel}" paginator="true" rows="50"
        paginatorAlwaysVisible="false" lazy="true"
        sortMode="multiple" sortBy="#{myBean.preSortOrder}" 
        resizableColumns="true">

        <p:column headerText="User" sortBy="#{trans.user.name}" >
            #{trans.user.name}
        </p:column>
        <p:column headerText="Company" sortBy="#{trans.companyName}">
            #{trans.companyName}
        </p:column>
        <p:column headerText="Join Date" id="joinDateTime" 
            sortBy="#{trans.joinDateTime}" >
            <h:outputText value="#{trans.joinDateTime}" />
        </p:column>
    </p:dataTable>

Here is my bean code called on @PostConstruct

        /*
     * method to build initial sort order for multisort
     */
    private void buildSortOrder() {
        UIViewRoot viewRoot =  FacesContext.getCurrentInstance().getViewRoot();
        UIComponent column = viewRoot.findComponent("transDataTable:joinDateTime"); 

        SortMeta sm1 = new SortMeta();
        sm1.setSortBy((UIColumn)column);
        sm1.setSortField("joinDateTime");
        sm1.setSortOrder(SortOrder.DESCENDING);
        preSortOrder.add(sm1);          
    }

I am not sure this is the right way to do this, but it works. I am usually uncomfortable when we have to use the ids from view in the bean code, as that can introduce bugs when people are not careful.

Thanks @CagatayCivici for the quick hint.

Murali D
  • 448
  • 1
  • 4
  • 18