issue when sorting with custom converter

[sbalazote]

Hi, guys. i've an issue in which i can't sort by with a custom converter named 'dateARG' in my code, it keeps sorting by string i think.
The format of my custom Date is in format 'DD/MM/YYYY'.

HTML
<th data-column-id="dateARG" data-converter="dateARG"><spring:message code="common.date"/></th>

JS
var table = $("#movementsTable").bootgrid({ caseSensitive: false, converters: { dateARG: { from: function (value) { // converts from string to dateARG return moment(value, "DD/MM/YYYY"); }, to: function (value) { // converts from dateARG to string return moment(value, "DD/MM/YYYY").format("DD/MM/YYYY"); } } } });

the resulting order is:

25/01/2016
27/05/2016
27/05/2016
29/01/2016

Any ideas what could be wrong? Thx!

pd: i'm appending rows with the append() method in client-mode

[atg103]

For what it's worth I'm having the exact same issue. I'm trying to sort by price but it's doing it alphabetically (e.g., I'm seeing £90, £210, £145 instead of £210, £145, £90).

I've written a converter but it only calls the to function for rendering, not the from function to convert to numbers for sorting.

I can see this issue has been open for a while. It's a bit of a show-stopper for me, so is it likely to be picked up soon or should I be looking to use a different library?

[crisep777]

Too late response, but here we go. Converters documentation for jQuery Bootgrid is so poor.

So, what worked for me to have a right column sorting in jQuery Bootgrid is something as follow:

1. Take your list, array, or something else what you want to "bootgridizer" just before make anything else with it. For example, at the moment that you get the success in an AJAX response.

2. Maybe you'll have to avoid attributes like data-type="" inside the specification of your tag.

3. Write some lines in Javascript like these:

   yourList.forEach(function (entry) { entry["yourColumnName"] = parseInt(entry["yourColumnName"], 10); //Use the parser that you need });

Hope this runs for someone.

Cheers!