Separator with Columnfilterwidget

Hi,

thanks for your post, and sorry for the trouble.

1.) Have you tried the Sorting plugins Extension from https://tablepress.org/extensions/datatables-sorting-plugins/ ?
If so, can you please post a link to the page with the table?

2.) Yes, the ColumnFilterWidgets Extension does not support further parameters at the moment. I will take a look if I can integrate this, and then let you know here.

Regards,
Tobias

Hi,

good news: I’ve extended the ColumnFilterWidgets Extension with a new parameter that allows adding that sParameter value to the JS code.
To use that, just re-install the Extension from tablepress.org/extensions/datatables-columnfilterwidgets/ and then extend your table’s Shortcode with a new parameter to

[table id=123 datatables_columnfilterwidgets=true datatables_columnfilterwidgets_separator="," /]

The value of that parameter will be inserted as the sParameter value that you have been using so far.

Regards,
Tobias

Hi Tobias,

What a great chap you are. Thanks so much.

I’ve now moved everything over to Tablepress so I’m only left with one problem – the currency sort.

Here’s an example of the code I’m using:

"aoColumnDefs": [ { "bSortable": true, "aTargets": [ 3,4,8,9,10] }, { "bSortable": false, "aTargets": [ "_all" ] }, { "sType": "numeric-comma", "aTargets": [ 9,10 ] }]

The first part turns off the sorting on all except columns 3, 4, 8, 9 & 10. The last bit should enable currency sorting on columns 9 & 10. These contain prices in ￡ (an example here) or in € (an example here).

After going over and over the code searching for a syntax error, I noticed a table where I’d forgotten to put the currency sign in and this one seems to sort ok.

So I’m guessing it’s the currency symbol that’s causing the problem but I really need to show it in each cell or it’s too easy to get mixed up. I know the euro and ￡ will probably soon reach parity but we’re not quite there yet ??

Is there a way to get my prices sorting properly like they did in Reloaded?

REgards
Jeremy

Hi Jeremy,

good to hear that the Separator now works ??

About the currency sorting: You’ll actually just have to use a different data type. “numeric-comma” is used when the comma is the decimal separator, which is not the case in your table, where it is a thousand separator. Just change your “Custom Command” to

"aoColumnDefs": [ { "bSortable": true, "aTargets": [ 3,4,8,9,10] }, { "bSortable": false, "aTargets": [ "_all" ] }, { "sType": "formatted-num", "aTargets": [ 9,10 ] }]

and the sorting should work. That “formatted-num” type will strip all currency symbols and the comma for the sorting.

Regards,
Tobias

Hi Tobias,

I’ve amended my tables accordingly. The prices now sort fine though there’s one thing that surprised me.

I have a number of holidays that have to be priced on request, denoted in the price column by the text “ask”. I assumed these would sort to the top or the bottom of the prices but they seem to just spread throughout when sorted.

The prices around them sort in order so it’s not a big issue but do you know if there’s any way to get the “ask”s to go to the top or bottom of the sort?

regards
Jeremy

Hi,

good to hear that the sorting now works better.

The “ask” issue is however indeed weird. Can you post a link to an affected table? The ones from above don’t seem to have such an “ask” cell.
Also, I’m not sure why the “ask” doesn’t go to the top or bottom. From my understanding of the code, it should be treated as 0, so that it should move to the top or bottom (unless of course you have both negative and positive values in the cell).

Regards,
Tobias

Hi Tobias,

Actually, it’s even odder than I thought. Try this table:

Turkey Flotilla Prices

If you sort on the column headed “With Flights”, the first click doesn’t actually get the sort right at all, though it does shuffle the rows a bit.

Click to sort again and the descending order seems right, albeit with the “ask”s appearing part way down in a group with just one numeric value in the middle of them.

Click again and now the ascending order is correct but with the “ask”s again grouped part way down the list, again with a single value in the middle of them.

Strange!

Hi,

thanks for the link. Yes, this is indeed strange… And unfortunately, I have no idea what’s causing this, or how to fix it ?? Sorry.
My assumption is that the “formatted-num” type is just not suited for columns with both currency and string values.

Best wishes,
Tobias