tablesorter

Filter Widget Any Match

Flexible client-side table sorting

NOTE!

• This is a demo of the filter_anyMatch option (v2.13.3).
• This method has limitations in that it does not support all of the per column search features! So, at this time, the following types of queries are not allowed as the results will cause confusion:
  • Search operators - A search for values equal, greater or less than values (> >= <= <) is not allowed because tables that contain both numbers and text (in separate columns). For example:

    "Fred" > "1"  // true*
    "Fred" < "10" // false
    "Fred" > 1    // false (numeric comparisons occur with parsed table data)
    "Fred" > 1    // false
    "Fred" < 10   // false

    * For comparisons, letters have a greater ASCII value than numbers.
  • Range query - A search for any number range (1 - 10) is not allowed because, if any columns contain text, then no rows will result. The examples are the same as the search operators examples above.
  • Not Match query - A search for not matches (!a) is not allowed because tables that contain both numbers and text (in separate columns) will always show all rows. For example:

    "Frank".search("a")    //  2 (a match, so this row "may" be hidden)
    "Fred".search("a")      // -1 (a not match! so this row will always show)
    "25".search("a")        // -1 (a not match! so this row will always show)
    "1/1/2014".search("a")  // -1 (a not match! so this row will always show)

  • Allowed filters include plain text matching, fuzzy search (~), exact match ("), wild card matches( ? or *), regex (/\d/g), and logical and (a && b)/or (a|b) matches.
• Setting this option should work properly with or without the column filters. The only issue you would have is if you triggered a search on the table using an array with undefined or null array values, like this:

  // apply "2?%" filter to the fifth column (zero-based index)
  var columns = [];
  columns[5] = '2?%';
  // anyMatch will kick in on undefined column filters,
  // unless the array looks like this: columns = [ '', '', '', '', '', '2?%' ]
  $('table').trigger('search', [ columns ]);

Demo

Javascript

HTML