Databases
StackOverflow2013
Postsdbo
POUsing jquery tablesorter filter to filter by the start of the column's text
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUsing jquery tablesorter filter to filter by the start of the column's text
    primarykey
    data
    text
    <p>I'd like to be able to filter a column of last names using the tablesorter filter. The filter should only match starting with the first character of each name. For example, let's say you had the following three names:</p> <p>Gilbert</p> <p>Baggins</p> <p>Godfrey</p> <p>If the filter text was just "g", I'd only want this result:</p> <p>Gilbert</p> <p>Godfrey</p> <p>And not match the either of the gs in Baggins.</p> <hr> <p>After studying the .tablesorterFilter's source code some more, I was able to figure out how to do it. </p> <p>You need to create a function that is passed 3 parameters. The first parameter is the contents of the HTML element. The second parameter is a string array of the words the user has typed into the filter container. The third parameter is a boolean for case sensitivity. You pass a reference to this function in the .tablesorterFilter filterFunction. I just copied and pasted the .tablesorterFilter's default has_words function and modified it to provide the functionality I'm looking for. I named it filterbyfirstcolumn and passed a reference to it as filterFunction.</p> <p>Here's the appropriate code snippet from my program:</p> <pre><code> function filterbyfirstcolumn(str, words, caseSensitive) { var text = caseSensitive ? str : str.toLowerCase(); var allwords = ""; for (var i=0; i &lt; words.length; i++) { allwords += words[i]; if (i != words.length - 1) allwords += " "; } if (text.indexOf(allwords) != 0) return false; return true; } $("#tblSearchContacts") .tablesorter({debug: false, widgets: ["zebra"], headers: { 0: { sorter: false }, 4: { sorter: false }, 5: { sorter: false }, 6: { sorter: false }, 7: { sorter: false }, 8: { sorter: false } }, sortList: [[1,0]]}) .tablesorterPager({ container: $("#pagerOne"), positionFixed: false, size : 20 }) .tablesorterFilter({filterContainer: $("#txtFilter"), filterClearContainer: $("#btnClear"), filterColumns: [3], filterCaseSensitive: false, filterFunction: filterbyfirstcolumn});` </code></pre> <p>Hopefully others may find this useful. Using a similar technique you could do all kinds of neat stuff with the filter.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMark
    1. USMark
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUsing jquery tablesorter filter to filter by the start of the column's text
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI've just tried google searching for a solution and have had no luck. The filterFunction may be what I need to use, but I can't find anything that really explains how to use it. I'm new to javascript and jquery so I don't as yet understand how plugins are coded. So examining the source code has not provided any revelations to date. You'd think that this would be a common request and an easy solution to find, but... Maybe I'm just not looking in the right place. :(
      singulars
      1. POUsing jquery tablesorter filter to filter by the start of the column's text
      1. USMark
    2. COTry the [documentation](http://tablesorter.com/docs/index.html#Examples)
      singulars
      1. POUsing jquery tablesorter filter to filter by the start of the column's text
      1. USAndrew
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload