Title: Separator with Columnfilterwidget
Last modified: August 20, 2016

---

# Separator with Columnfilterwidget

 *  Resolved [JezF](https://wordpress.org/support/users/jezf/)
 * (@jezf)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/separator-with-columnfilterwidget/)
 * Hi Tobias,
 * I’ve started migrating to Tablepress from Table Reloaded following our exchanges
   a few days ago. I have a couple of problems:
 * 1) I can’t get the currency sorting to work. However before we try and solve 
   this, more important is:
 * 2) Many of my tables use the ColumnFilterWidgets Separator facility (you probably
   know this but more details here: [Separator](http://datatables.net/extras/thirdparty/ColumnFilterWidgets/DataTables/extras/ColumnFilterWidgets/separator.html))
 * I use a comma, so for example if a holiday is available for 2-4 people, I enter
   2,3,4 in the cell. If the user filters for holidays for 3 people it shows any
   rows containing a 3, eg 2,3,4 or 3,4,5,6 etc.
 * With Reloaded, I did this with some code in the Custom Commands field but now
   ColumnnFilterWidgets is an extension this code is ignored.
 * How do I get this working in Tablepress?
 * Many thanks again for your time.
 * [http://wordpress.org/extend/plugins/tablepress/](http://wordpress.org/extend/plugins/tablepress/)

Viewing 8 replies - 1 through 8 (of 8 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/separator-with-columnfilterwidget/#post-3483330)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * 1.) Have you tried the Sorting plugins Extension from [http://tablepress.org/extensions/datatables-sorting-plugins/](http://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
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/separator-with-columnfilterwidget/#post-3483438)
 * 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
 *  Thread Starter [JezF](https://wordpress.org/support/users/jezf/)
 * (@jezf)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/separator-with-columnfilterwidget/#post-3483453)
 * 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](http://www.sailingchoices.com/prices/bareboat-yacht-charter-prices/turkey-bareboat-prices-in-gbp/))
   or in € (an example [here](http://www.sailingchoices.com/prices/bareboat-yacht-charter-prices/croatia-bareboat-prices-in-euros-july-october/)).
 * 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](http://www.sailingchoices.com/prices/bareboat-yacht-charter-prices/turkey-bareboat-prices-in-euros/)
   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
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/separator-with-columnfilterwidget/#post-3483455)
 * 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
 *  Thread Starter [JezF](https://wordpress.org/support/users/jezf/)
 * (@jezf)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/separator-with-columnfilterwidget/#post-3483456)
 * 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
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/separator-with-columnfilterwidget/#post-3483457)
 * 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
 *  Thread Starter [JezF](https://wordpress.org/support/users/jezf/)
 * (@jezf)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/separator-with-columnfilterwidget/#post-3483458)
 * Hi Tobias,
 * Actually, it’s even odder than I thought. Try this table:
 * [Turkey Flotilla Prices](http://www.sailingchoices.com/prices/flotilla-holiday-prices/turkey-flotilla-prices/turkey-flotilla-prices-1-week-april-june/)
 * 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!
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/separator-with-columnfilterwidget/#post-3483459)
 * 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

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Separator with Columnfilterwidget’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

## Tags

 * [ColumnFilterWidgets](https://wordpress.org/support/topic-tag/columnfilterwidgets/)

 * 8 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [13 years, 1 month ago](https://wordpress.org/support/topic/separator-with-columnfilterwidget/#post-3483459)
 * Status: resolved