Sorting

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”);