Jsf dataTable sortby, I want (1,2,3,4,10,15), I get (1,10,15,2,3,4). How to solve

Question

My JSF code goes like this:

<p:dataTable var="result" value="#{timerConfigurationJobList.model}" rows="10"
                         paginator="true" paginatorPosition="bottom"
                         paginatorTemplate="{RowsPerPageDropdown} {FirstPageLink} {PreviousPageLink} {CurrentPageReport} {NextPageLink} {LastPageLink}"
                         rowsPerPageTemplate="10,20,50" id="approvalTable" lazy="true">           
                <p:column sortBy="#{result.jobId}">
                    <f:facet name="header">
                        <h:outputText value="#{msg['content.jobList.jobId']}"/>
                    </f:facet>
                </p:column >
 </p:dataTable>

The result I get is this :

As can be seen in the picture: '123' is higher than '2', '4', '7' and '9'. I want it to come right at the end, so that it is 'numerically' sorted.

Am using Java and JSF 2.

Edit: In the lazy model I found this:

@Override
    public final List<T> load(int first, int pageSize, String sortField, SortOrder sortOrder,
            final Map<String, Object> filters) {

        Map<String, Sort> sorts = new HashMap<>();

        if (sortField != null) {
            if (sortOrder.equals(SortOrder.ASCENDING)) {
                sorts.put(sortField, Sort.ASC);
            } else if (sortOrder.equals(SortOrder.DESCENDING)) {
                sorts.put(sortField, Sort.DESC);
            }
            // unsorted can be ignored
        }

You are using lazy loading. You should take care of sorting in your lazy model. Could you please share your lazy model (the sorting part)? — Jasper de Vries, Apr 07 '17 at 08:27
How does that end up in your query? You will probably find the issue there. — Jasper de Vries, Apr 07 '17 at 08:39
Are they numeric in your database? Or is it a string field there? — Kukeltje, Apr 07 '17 at 09:14
Then you yourself need to do additional sorting (or change the database column — Kukeltje, Apr 07 '17 at 13:48

score 0 · Answer 1 · answered Apr 07 '17 at 23:36

There are multiple ways to solve the issue:

Change the type of column as mentioned by @Kukeltje. Not sure whether you want to change the schema.
Use sortFunction attribute of column to provide the custom sorting.
Pass the sorted list of JSF component.

Jsf dataTable sortby, I want (1,2,3,4,10,15), I get (1,10,15,2,3,4). How to solve

1 Answers1