rich:datatable and sorting (data table) HELP!

[jonhsmith]

I want to have this table with column1 and column2 sorting by richfaces, but the sorting do not appear.

Can someone help? Thanks.

column1 | column2 | column3 |
value1 | value2 | s1 | s2 | s3 |
value1 | value2 | s1 | s2 | s3 |
value1 | value2 | s1 | s2 | s3 |
value1 | value2 | s1 | s2 | s3 |
value1 | value2 | s1 | s2 | s3 |
value1 | value2 | s1 | s2 | s3 |

My code is:

<rich:dataTable id="table" var="record"
value="#{tableBean.values}" rows="10" width="100%">
<f:facet name="header">

<rich:columnGroup>
<rich:column>
<h:outputText value="Column1" />
</rich:column>

<rich:column>
<h:outputText value="Column2" />
</rich:column>

<rich:column colspan="3">
<h:outputText value="Column3" />
</rich:column>

</rich:columnGroup>
</f:facet>

<rich:column sortBy="record.value1">
<h:outputText value="record.value1" />
</rich:column>


<rich:column>
<h:outputText value="record.value2" />
</rich:column>

<rich:column>
<h:outputText value="record.s1" />
</rich:column>

<rich:column>
<h:outputText value="record.s2" />
</rich:column>

<rich:column>
<h:outputText value="record.s3" />
</rich:column>
</rich:dataTable>

Can someone help? Thanks

[nbelaevski]

Hi,

Try adding "header" facets to columns.

[jonhsmith]

nbelaevski, can show me an example? Where I have to add header?

[ilya_shaikovsky]

http://livedemo.exadel.com/richfaces-demo/richfaces/sortingFeature.jsf

[jonhsmith]

I saw http://livedemo.exadel.com/richfaces-demo/richfaces/sortingFeature.jsf
But my problem is add the column3 wich is divided into three subcolums

column1 (with sorting) | column2 (with sorting)| column3 (without sorting)|
value1 | value2 | s1 | s2 | s3 |
value1 | value2 | s1 | s2 | s3 |
value1 | value2 | s1 | s2 | s3 |
value1 | value2 | s1 | s2 | s3 |
value1 | value2 | s1 | s2 | s3 |
value1 | value2 | s1 | s2 | s3 |

[ilya_shaikovsky]

Still can't see the problem . You defining the header and sortBy both for columns which should be sorted and defining just header (with just label) without sortBy for the columns which should not be sorted.

[bm97]

I am not sure, but:

To support column grouping and sorting at the same time, you have to use both "header"-facets.

For each <rich:column> AND the "header"-facet of the <rich:datatable>.

[jonhsmith]

bm97, Can you show me a simple example?
thanks

[bm97]

Here a sample, it should work.

You also forgot the value-binding/EL-expressions. Else the sortBy-attribute does not know what data to sort. Greetings

<rich:dataTable id="table" var="record" value="#{tableBean.values}" rows="10" width="100%">
 <f:facet name="header">

 <rich:columnGroup>
 <rich:column>
 <h:outputText value="Column1" />
 </rich:column>

 <rich:column>
 <h:outputText value="Column2" />
 </rich:column>

 <rich:column colspan="3">
 <h:outputText value="Column3" />
 </rich:column>

 </rich:columnGroup>
 </f:facet>

 <rich:column sortBy="#{record.value1}">
 <f:facet name="header">record.value1</f:facet>
 <h:outputText value="#{record.value1}" />
 </rich:column>


 <rich:column sortBy="#{record.value2}">
 <f:facet name="header">record.value2</f:facet>
 <h:outputText value="#{record.value2}" />
 </rich:column>

 <rich:column>
 <f:facet name="header">record.s1</f:facet>
 <h:outputText value="#{record.s1}" />
 </rich:column>

 <rich:column>
 <f:facet name="header">record.s2</f:facet>
 <h:outputText value="#{record.s2}" />
 </rich:column>


 <rich:column>
 <f:facet name="header">record.s3</f:facet>
 <h:outputText value="#{record.s3}" />
 </rich:column>

 </rich:dataTable>

[jonhsmith]

It works, but the sorting icons appear next to recor.value1 and my requirement is that the icons appear next to the column1 and column2 (on the title)

Column1 (iconst to sorting) | Column2 (iconst to sorting) |

[bm97]

You cannot have anything like

|column1 (with sorting) | column2 (with sorting)| column3 (without sorting)|
|--------------------------------------------------------------------------|
|value1 | value2 | s1 | s2 | s3 |
|value1 | value2 | s1 | s2 | s3 |

but you can have something like the following

| | merged column label |
|column1 (with sorting) | column2 (with sorting)| label |label |label |
|--------------------------------------------------------------------------|
|value1 | value2 | s1 | s2 | s3 |
|value1 | value2 | s1 | s2 | s3 |

<rich:dataTable id="table" var="record" value="#{tableBean.values}" rows="10" width="100%">
 <f:facet name="header">

 <rich:columnGroup>
 <rich:column colspan="2">
 <!-- empty column -->
 <h:outputText value="" />
 </rich:column>

 <rich:column colspan="3">
 <h:outputText value="Combined label" />
 </rich:column>

 </rich:columnGroup>
 </f:facet>

 <rich:column sortBy="#{record.value1}">
 <f:facet name="header">Column1</f:facet>
 <h:outputText value="#{record.value1}" />
 </rich:column>


 <rich:column sortBy="#{record.value2}">
 <f:facet name="header">Column2</f:facet>
 <h:outputText value="#{record.value2}" />
 </rich:column>

 <rich:column colspan="1">
 <f:facet name="header">record.s1</f:facet>
 <h:outputText value="#{record.s1}" />
 </rich:column>

 <rich:column>
 <f:facet name="header">record.s2</f:facet>
 <h:outputText value="#{record.s2}" />
 </rich:column>


 <rich:column>
 <f:facet name="header">record.s3</f:facet>
 <h:outputText value="#{record.s3}" />
 </rich:column>

 </rich:dataTable>

@Nick/ilya: Perhaps you can provide this code as sample code for the documentation/wiki?!

[jonhsmith]

Someone know how to do that?
Thanks

[jonhsmith]

thanks bm97 I think that will help me

[ilya_shaikovsky]

seems in your case you should implement external sorting by using sortOrder's bindings and links to change its states defined in header where you need.

[ilya_shaikovsky]

if the solution of bm97 will not fit your needs.