2:14 a.m.
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
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 sorting
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
2:16 a.m.
New subject: [JBoss JIRA] Updated: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Sei Syvalta updated RF-4403:
----------------------------
Description:
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).
was:
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 sorting
logic manually (ie. option 2).
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
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
6:57 a.m.
New subject: [JBoss JIRA] Updated: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Nick Belaevski updated RF-4403:
-------------------------------
Fix Version/s: Wishes
Assignee: Denis Morozov
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: Denis Morozov
Fix For: Wishes
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
7:24 a.m.
New subject: [JBoss JIRA] Commented: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Sei Syvalta commented on RF-4403:
---------------------------------
There's also a second use case for this. For example, if you use JPA entity directly
in a dataTable, but you need some additional "derived"/calculated fields. If you
store them in a map in a bean, you can't sort using sortBy, because data is not
contained in that object.
For example:
<rich:column sortBy="#{data.abc}">
<h:outputText value="#{data.abc}" />
</rich:column>
<rich:column> <!-- can't use sortBy -->
<h:outputText value="#{bean.someMap[data.id]}" />
</rich:column>
Is there any chance this issue could be addressed in RF 3.3.0?
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: Denis Morozov
Fix For: Wishes
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
7:48 a.m.
New subject: [JBoss JIRA] Updated: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Denis Morozov updated RF-4403:
------------------------------
Assignee: Nick Belaevski (was: Denis Morozov)
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: Nick Belaevski
Fix For: Wishes
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
2:07 p.m.
New subject: [JBoss JIRA] Work started: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Work on RF-4403 started by Nick Belaevski.
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: Nick Belaevski
Fix For: Wishes
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
10:54 a.m.
New subject: [JBoss JIRA] Work stopped: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Work on RF-4403 stopped by Nick Belaevski.
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: Nick Belaevski
Fix For: Wishes
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
10:54 a.m.
New subject: [JBoss JIRA] Updated: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Nick Belaevski updated RF-4403:
-------------------------------
Attachment: rf4403.zip
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: Nick Belaevski
Fix For: Wishes
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
10:56 a.m.
New subject: [JBoss JIRA] Commented: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Nick Belaevski commented on RF-4403:
------------------------------------
Example showing sorting/filtering in DB is attached
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: Nick Belaevski
Fix For: Wishes
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
11:04 a.m.
New subject: [JBoss JIRA] Updated: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Nick Belaevski updated RF-4403:
-------------------------------
Attachment: (was: rf4403.zip)
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: Nick Belaevski
Fix For: Wishes
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
11:04 a.m.
New subject: [JBoss JIRA] Updated: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Nick Belaevski updated RF-4403:
-------------------------------
Attachment: rf4403.zip
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: Nick Belaevski
Fix For: Wishes
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
11:10 a.m.
New subject: [JBoss JIRA] Assigned: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Ilya Shaikovsky reassigned RF-4403:
-----------------------------------
Assignee: Ilya Shaikovsky (was: Nick Belaevski)
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
11:10 a.m.
New subject: [JBoss JIRA] Updated: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Ilya Shaikovsky updated RF-4403:
--------------------------------
Fix Version/s: 3.3.1
(was: Wishes)
to be reused at richfaces-demo
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
11:29 a.m.
New subject: [JBoss JIRA] Commented: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
David Sheth commented on RF-4403:
---------------------------------
Note for other people wanting to build the example: In my case at least, the pom in the
attachment only makes a package if I change the hibernate dependency from 3.2.6.GA to
3.2.6.ga , to match http://repository.jboss.com/maven2/org/hibernate/hibernate/3.2.6.ga/
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
11:50 a.m.
New subject: [JBoss JIRA] Commented: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Nick Belaevski commented on RF-4403:
------------------------------------
http://www.hibernate.org/248.html
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
11:52 a.m.
New subject: [JBoss JIRA] Updated: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Nick Belaevski updated RF-4403:
-------------------------------
Attachment: (was: rf4403.zip)
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
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
11:56 a.m.
New subject: [JBoss JIRA] Updated: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Nick Belaevski updated RF-4403:
-------------------------------
Attachment: rf4403.zip
Thank you for pointing to that! I've updated archive
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
1:17 p.m.
New subject: [JBoss JIRA] Commented: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
David Sheth commented on RF-4403:
---------------------------------
I noticed something when looking at the generated SQL: It appears that a pair of queries
(one for data, and one for the count) are being run to regenerate the jsf model, and then
another pair is being run to get the data for the new page. Unfortunately, running two
variations of the query with every request won't work for use cases where the query is
expensive, as it often is.
Perhaps you could integrate SerializableDataModel into your example, to show people how to
avoid running that first pair of queries?
Implementation note: To enable the example to run on JBoss, I set the two jsf jars and
the logging jar to the "provided" scope. To avoid an error message, I changed
the destroy method to check if the session is actually still open before closing it. i.e.
if (session != null && session.isOpen()) {
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
3:51 p.m.
New subject: [JBoss JIRA] Commented: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
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_commandSor...).
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
3:53 p.m.
New subject: [JBoss JIRA] Commented: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Gonzalez Adrian commented on RF-4403:
-------------------------------------
Sorry, a better link :
http://myfaces.apache.org/tomahawk-project/tomahawk12/tagdoc/t_commandSor...
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
1:38 p.m.
New subject: [JBoss JIRA] Updated: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Jay Balunas updated RF-4403:
----------------------------
Component/s: component-tables
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
Components: component-tables
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
6:27 a.m.
New subject: [JBoss JIRA] Work started: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Work on RF-4403 started by Ilya Shaikovsky.
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
Components: component-tables
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
5:04 a.m.
New subject: [JBoss JIRA] Work stopped: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Work on RF-4403 stopped by Ilya Shaikovsky.
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
Components: component-tables
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
8:03 a.m.
New subject: [JBoss JIRA] Resolved: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Ilya Shaikovsky resolved RF-4403.
---------------------------------
Resolution: Done
modifiable model sample implemented at rf-demo
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
Components: component-tables
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
12:58 p.m.
New subject: [JBoss JIRA] Updated: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Nick Belaevski updated RF-4403:
-------------------------------
Attachment: (was: rf4403.zip)
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
Components: component-tables
Affects Versions: 3.2.2
Reporter: Sei Syvalta
Assignee: Ilya Shaikovsky
Fix For: 3.3.1
Attachments: rf4403 (1).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
12:58 p.m.
New subject: [JBoss JIRA] Updated: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Nick Belaevski updated RF-4403:
-------------------------------
Attachment: rf4403 (1).zip
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
Components: component-tables
Affects Versions: 3.2.2
Reporter: Sei Syvalta
Assignee: Ilya Shaikovsky
Fix For: 3.3.1
Attachments: rf4403 (1).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
3:41 a.m.
New subject: [JBoss JIRA] Assigned: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Tsikhon Kuprevich reassigned RF-4403:
-------------------------------------
Assignee: Mikhail Vitenkov (was: Ilya Shaikovsky)
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
Components: component-tables
Affects Versions: 3.2.2
Reporter: Sei Syvalta
Assignee: Mikhail Vitenkov
Fix For: 3.3.1
Attachments: rf4403 (1).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
1:31 p.m.
New subject: [JBoss JIRA] Closed: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Mikhail Vitenkov closed RF-4403.
--------------------------------
Assignee: Nick Belaevski (was: Mikhail Vitenkov)
Verified at 3.3.1.CR2
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
Components: component-tables
Affects Versions: 3.2.2
Reporter: Sei Syvalta
Assignee: Nick Belaevski
Fix For: 3.3.1
Attachments: rf4403 (1).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
11:53 a.m.
New subject: [JBoss JIRA] Commented: (RF-4403) Better support for datatable sorting in DB
[
https://jira.jboss.org/jira/browse/RF-4403?page=com.atlassian.jira.plugin...
]
Nick Belaevski commented on RF-4403:
------------------------------------
New version of Hibernate data model coupled with Seam transactions and entityConverter
together with livedemo example added to JIRA as patch file in RF-7061 - we're going to
commit it just after 3.3.1 release in order not to affect release demo stability.
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
Components: component-tables
Affects Versions: 3.2.2
Reporter: Sei Syvalta
Assignee: Nick Belaevski
Fix For: 3.3.1
Attachments: rf4403 (1).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
6095
days inactive
6339
days old
richfaces-issues@lists.jboss.org
28 comments
9 participants
participants (9)
-
David Sheth (JIRA) -
Denis Morozov (JIRA)
-
Gonzalez Adrian (JIRA)
-
Ilya Shaikovsky (JIRA)
-
Jay Balunas (JIRA)
-
Mikhail Vitenkov (JIRA)
-
Nick Belaevski (JIRA)
-
Sei Syvalta (JIRA)
-
Tsikhon Kuprevich (JIRA)