Hi
Sorting does not work for date, and amount with dollar sign, I am using dom4j to create an XML file to pass to loadXMLString treeGrid method. Any help would be greatly appreciated
please find my below code
mygrid = new dhtmlXGridObject(‘gridbox’);
mygrid.imgURL = “<%=request.getContextPath()%>/secure/images/”;
mygrid.selMultiRows = true;
mygrid.attachEvent(“onRowSelect”,doOnRowSelected);
mygrid.enableCellIds(true);
mygrid.setHeader("<bean:message key=‘vehicleDailyStatement.asOfPriorEOD’/> , , ,<html:label key=‘vehicleDailyStatement.principal’/>
<html:label key=‘vehicleDailyStatement.balance’/>,<html:label key=‘vehicleDailyStatement.units’/>,<html:label key=‘vehicleDailyStatement.description’/>,<html:label key=‘vehicleDailyStatement.interest’/>,<html:label key=‘vehicleDailyStatement.flats’/>,<html:label key=‘vehicleDailyStatement.insurance’/>,<html:label key=‘vehicleDailyStatement.fees’/>,<html:label key=‘vehicleDailyStatement.floor’/>
<html:label key=‘vehicleDailyStatement.floordate’/> ,<html:label key=‘vehicleDailyStatement.maturity’/>
<html:label key=‘vehicleDailyStatement.maturitydate’/>,<html:label key=‘vehicleDailyStatement.duplicate’/>
<html:label key=‘vehicleDailyStatement.COV’/>,<html:label key=‘vehicleDailyStatement.subvened’/>,<html:label key=‘vehicleDailyStatement.stock’/>
<html:label key=‘vehicleDailyStatement.number’/>");
mygrid.setInitWidthsP(“21,1,1,8,4,12,8,8,7,7,7,6,3,3,6”);
mygrid.setColAlign(“left,left,left,left,left,left,left,left,left,left,left,left,left,left,left”);
mygrid.setColTypes(“tree,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ch,ch,ro”);
mygrid.setColSorting(“na,str,str,int,int,str,str,str,str,date,date,date,na,na,str”);
<%
Document document = DocumentHelper.createDocument();
Element rowsElement = document.addElement(“rows”);
Element rowElement = rowsElement.addElement(“row”);
rowElement.addAttribute(“id”, “vehicleDailyStatementInq”).addAttribute(“bgColor”, “#e6f6f7”);//setText(""+ " “+”" );
Element cellElement = rowElement.addElement(“cell”);
String xpath = request.getContextPath();
if(dlrOpen)
cellElement.addAttribute(“image”,“contract.gif”);
else
cellElement.addAttribute(“image”,“expand.gif”);
String navAway = StringUtils.buildNavigateAway(“dealerSummaryInq”, “dealerSummaryInq”, true, dealerKey);
cellElement.setText("<a href= “#” id = “NavigateAway” >" + vehicleDailyStmtDetail.getDealerName()+ “”);
// cellElement.setText(vehicleDailyStmtDetail.getDealerName());
// cellElement.addAttribute(“image”,“expand.gif”);
rowElement.addElement(“cell”).setText(" “);
rowElement.addElement(“cell”).setText(” “);
rowElement.addElement(“cell”).setText(”"+vehicleDailyStmtDetail.getPrincipalBalAmt()+"");
rowElement.addElement(“cell”).setText(""+vehicleDailyStmtDetail.getUnits()+"");
//rowElement.addElement(“cell”).setText(" “);
rowElement.addElement(“cell”).setText(” “);
rowElement.addElement(“cell”).setText(”"+vehicleDailyStmtDetail.getInterestAmt()+"");
rowElement.addElement(“cell”).setText(""+vehicleDailyStmtDetail.getFlatsAmt()+"");
rowElement.addElement(“cell”).setText(""+vehicleDailyStmtDetail.getInsuranceAmt()+"");
rowElement.addElement(“cell”).setText(""+vehicleDailyStmtDetail.getFeesAmt()+"");
rowElement.addElement(“cell”).setText(" “);
rowElement.addElement(“cell”).setText(” “);
rowElement.addElement(“cell”).addAttribute(“disabled”, “true”).addAttribute(“id”,“Dcov”);
rowElement.addElement(“cell”).addAttribute(“disabled”, “true”).addAttribute(“id”,“Subv”);
rowElement.addElement(“cell”).setText(” “);
String strDOM =document.asXML().replaceAll(”"", “’”);
%>
Sorting does not work for date
The default “date” sorting accepts dates in js compatible format only. ( which is mm/dd/yyyy )
If you are using any other format you can
- use dhxCalendar column type and setDateFormat
- use custom sorting routine ( dhtmlx.com/docs/products/dhtmlxG … d_art_sort )
Thanks for quick reply
As suggest i used ron with number Format but still i dont see columns sorting correctly any suggestion?
mygrid.setNumberFormat(“0.00”,“6”);
mygrid.setColAlign(“left,left,left,left,left,left,left,left,left,left,left,left,left,left,left,left”);
mygrid.setColTypes(“tree,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ch,ch,ro,ro”);
mygrid.setColSorting(“na,na,na,int,int,str,ron,ron,ron,ron,date,date,na,na,int,int”);
mygrid.setColTypes(“tree,ro,ro,ro,ro,ro,ron,ro,ro,ro,ro,ro,ch,ch,ro,ro”);
mygrid.setColSorting(“na,na,na,int,int,str,int,ron,ron,ron,date,date,na,na,int,int”);