You need to sign in to do that
Don't have an account?
Doondi
tablesorter not sorting $ values properly and reading digits as wrong
Hi,
I am Using TableSorter and it's not sorting $ values properly,
Any suggestion would be a great help.
Here is my Js code:
This is my Pageblocktable code:
I am Using TableSorter and it's not sorting $ values properly,
Any suggestion would be a great help.
Here is my Js code:
<script type="text/javascript"> $j = jQuery.noConflict(); $j(document).ready(function () { $j("[id$=theaddrs]").tablesorter(); }); </script>
This is my Pageblocktable code:
<apex:pageblock mode="details" id="theaddrsblock" > <apex:pageBlockTable value="{!Records}" var="r" styleclass="fixme" id="theaddrs" styleClass="tablesorter" headerClass="header"> <apex:column value="{!r.Units__c}"></apex:column> <apex:column value="{!r.Annual_Sale__c}" ></apex:column> <--10 more colomns here; which are sorting perfectly--> </apex:pageBlockTable> </apex:pageblock>This is the output am getting :
In tablesorter plug in we need to change the JS code;
some thing like this;
All Answers
Greetings to you!
Below is the sample code which I have tested in my org and it is working fine. Kindly modify the code as per your requirement. You can match your code to the below code.
Here, Max_Amount__c is a currency ($) field and it is sorting correctly.
I hope it helps you.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future.
Thanks and Regards,
Khan Anas
I used the same, even now I am not getting correct values
I used the same, even now I am not getting correct values;
by the way at line no 20, you used this id (myTable) where have you assigned it?
In tablesorter plug in we need to change the JS code;
some thing like this;