"I don't think a custom parser can "always force null data to the
bottom."
Maybe it's outside your skill level, but it is *definitely* do-able
without touching one single character of code inside tablesorter.js
you were on the right track with the ".addParser" method but there's
no need to edit it inside the core code
On Mar 23, 3:28 pm, Ptang <al...@modwest.com> wrote:
> On Mar 13, 5:52 am, MorningZ <morni...@gmail.com> wrote:
>
> > A custom parser would *definitely* handle this
>
> I don't think a custom parser can "always force null data to the
> bottom."
>
> The custom parsers just normalize cell contents into "numeric" or
> "text" format and that result is then sent on to the sorting routine.
> This means that if you use a custom parser to set a null data (or "*"
> or "n/a") to be treated as "zzzzz" (text) or 99999999 (numeric) then
> those cells will be pushed to the bottom for ASCENDING sorts. But when
> a user clicks the th header again for DESCENDING sorts, then those
> cells with null data will be on top.
>
> I think the point of the original question was that when there is no
> data in a cell, that cell is irrelevant/useless to any sorting, and
> therefore should ALWAYS be pushed to the bottom of the column.
>
> The only way to do that at this stage is to patch
> jquery.tablesorter.js in 3 places (assuming that cells with only '-'
> are the "null" ones):
>
> ts.addParser({
> id: /***************** choose an existing numeric parser to
> edit, or create a new one **********/
> format: function(s) {
> + if(s == '-') return "0.000"; // flags this float for
> sortNumeric() as string type, while type juggling will treat as zero
>
> function sortNumeric(a,b) {
> + if(a === '0.000') return 1; // tests for string type set by
> numeric Parser, means this cell has the '-'
> + else if(b === '0.000') return -1; // force cells with just
> "-" always to bottom
> return a-b;
>
> function sortText(a,b) {
> + if(a == '-') return 1;
> + else if(b == '-') return -1; // force cells with just "-"
> always to bottom
> return ((a < b) ? -1 : ((a > b) ? 1 : 0));
>
> It is a bad hack, but is the best I can do to always force empty cells
> or cells with no data to the bottom of the sorted column.
