Filtering using a natural sort

[bogal]

In my app i have a column that can have digits 1-10 (including decimals), or the string 'All'. I am able to sort these columns with the following code:

$("table").tablesorter({ textSorter: { 1: function(a, b) { x = parseFloat(a); y = parseFloat(b); return x === 0 && y === 0 ? b.length - a.length : $.tablesorter.sortNatural(a, b); } }, });

... i was wondering if the same can be applied to filtering? I am using the filter widget and whilst it works as it should, would like the filtering to always include rows with 'All' in the results? So when the dropdown is populated with the values from the table, say the user selects 3, all rows containing 3 and All are filtered. This should only happen on this column, other columns that are filterable(?) should not have this behaviour.

[Mottie]

Hi @bogal!

I'm not exactly sure what you mean.

If you want rows with "All" to always show, then try the following code (demo):

$(function() {
  $("table").tablesorter({
    theme: "blue",
    widgets: ["zebra", "filter"],
    widgetOptions: {
      filter_defaultFilter: {
        // "all" will always show
        1: "{q}|all"
      }
    }
  });
});

[bogal]

Again, thanks for the quick reply. Your interpretation of the issue is spot on, and although the fiddle shows exactly what i am looking to achieve, it isn't working on my site. On mine (i should have stated), i am not using an input to filter the results, but the select (dropdown) box - that is the only difference between them.

[Mottie]

What I think you need then is to add the following classes to the header (demo & ref):

<th class="filter-select filter-match">Numeric</th>

[bogal]

Works perfectly. Thanks for taking the time to help, much appreciated :)