[richfaces-issues] [JBoss JIRA] Commented: (RF-4403) Better support for datatable sorting in DB

[Gonzalez Adrian (JIRA)]

    [ https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12460850#action_12460850 ] 

Gonzalez Adrian commented on RF-4403:
-------------------------------------

Thanks very much for showing this code in the demo !

But IMHO, this kind of solution (getting sort and filter information by extending ExtendedDataModel and implementing Modifiable) is really complicated for such a classic use case (issuing a SELECT .. ORDER BY Sql clause). It should be really really easier.

It would be really better to be able to inject filter and sort information in the backing bean via some Jsf EL (just classic bean without any specific RF APIs).

Tomahawk achieved this kind of integration with t:commandSortHeader (see http://myfaces.apache.org/tomahawk-project/tomahawk12/tagdoc/t_commandSortHeader.html).
I know with Tomahawk you need to code an additional Jsf component and perhaps it restricts the use case to one column sort.

> Better support for datatable sorting in DB
> ------------------------------------------
>
>                 Key: RF-4403
>                 URL: https://jira.jboss.org/jira/browse/RF-4403
>             Project: RichFaces
>          Issue Type: Feature Request
>    Affects Versions: 3.2.2
>            Reporter: Sei Syvalta
>            Assignee: Ilya Shaikovsky
>             Fix For: 3.3.1
>
>         Attachments: rf4403.zip
>
>
> Currently, there are two options for sorting data in dataTable (with or without paging):
> 1. use sortBy attribute in rich:column. The downside is that the whole data set needs to be loaded from DB for sorting.
> 2. use commandLinks in rich:cloumn. The downside is that you need to manage the icons, direction etc. by yourself (all this is managed by richfaces in case 1.)
> So what I would find very useful would be to get the sort property(ies) to a bean, where it could be used in sql "select ... order by sortProperty limit start maxResults..." clause.
> Some discussion about this is also in RF-2916.
> To conclude, I'm using a custom datamodel with dataTable pagination which loads data lazily and everything is working fine. However, I would like to add sorting to the headers of table, and I would like to do that at the database level, without doing all the ui logic manually (ie. option 2).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira