I have Column Named CaseNo in Table EventMaster (It is concatenation of Case No "of " Year I am fetching CaseNo from CaseMaster and Year from YearMaster ) .Now I wanted to Sort this column How can I achieve this .
<rich:dataTable value="#{eventMaster.eventMasterList}" var="event" id="table"
rows="10" rowClasses="even-row, odd-row ">
<rich:column style="width:7%;">
<f:facet name="header">#{lbl['label.casenumber']}</f:facet>
<h:outputText value="#{event.caseNo}"/>
</rich:column>
<rich:column style="width:12%;">
<f:facet name="header">#{lbl['label.scheduleevent']}</f:facet>
<h:outputText value="#{event.eventDateString}"/>
</rich:column>
Criteria crt = session.createCriteria(merc.dao.EventMasterDao.class).add(Restrictions.eq("isDeleted", "N")).addOrder(Order.asc("eventDate"));
fetchList = (ArrayList<EventMasterDao>) crt.list();