Mottie/tablesorter

Logical Operation doesn't work correctly

Closed this issue · 3 comments

When I use the logical operation "or" on the filter it doesn't display all elements under chrome browser
bugtable1
bugtable2
bugtable3

Here the code of the table
(I use the same javascript and files of this page : https://mottie.github.io/tablesorter/docs/example-widget-filter.html)

<table id="table" class="tablesorter">
<thead>
    <tr>
        <th data-value=""  class="filter-match" data-sorter="false">&nbsp;</th>
        <th data-value=""  class="filter-match" data-sorter="false">Type</th>
        <th data-value=""  class="filter-match" data-sorter="false">PLL</th>
        <th data-value=""  class="filter-match" data-sorter="false">Title</th>
        <th data-value=""  class="filter-match" data-sorter="false">Status</th>
        <th data-value=""  class="filter-match" data-sorter="false">Approval Month</th>
        <th data-value=""  class="filter-match" data-sorter="false">Accrued</th>
        <th data-value=""  class="filter-match" data-sorter="false">PIP Code</th>
        <th data-value=""  class="filter-match" data-sorter="false">Program Type</th>
        <th data-value=""  class="filter-match" data-sorter="false">One Pager Cost</th>
        <th data-value=""  class="filter-match" data-sorter="false">Financial Cost</th>
        <th data-value=""  class="filter-match" data-sorter="false">CASEIH</th>
        <th data-value=""  class="filter-match" data-sorter="false">NHAG</th>
        <th data-value=""  class="filter-match" data-sorter="false">($/€)</th>
    </tr>
</thead>
<tbody style="font-size:8pt;">
    <tr>
        <td >

        </td>
        <td>Addendum</td>
        <td>XXXXXXXXXX, XXXX</td>
        <td >
            XXX
        </td>
        <td>Potential</td>
        <td>December 2015</td>
        <td>Not Accrued</td>
        <td>12345-2345</td>
        <td>Mandatory Safety</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>Dollar</td>
    </tr>

    <tr>
        <td >
        </td>
        <td>PIP</td>
        <td>XXXXXXXX, XXXXX</td>
        <td >
            YYYY
        </td>
        <td>Approved</td>
        <td>October 2015</td>
        <td>Not Accrued</td>
        <td>1234-1234</td>
        <td>Mandatory Safety</td>
        <td>1</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>Dollar</td>
    </tr>
    <tr>
        <td >
        </td>
        <td>PIP</td>
        <td>XXXXXXXX, XXXXXXXX</td>
        <td >
            ZZZZZ
        </td>
        <td>Approved</td>
        <td>December 2015</td>
        <td>True (November - November - December - December)</td>
        <td>CaseCode-Nh Code</td>
        <td>Mandatory Safety</td>
        <td>1</td>
        <td>237 458</td>
        <td>77 891</td>
        <td>159 567</td>
        <td>Dollar</td>
    </tr>
    <tr>
        <td >
        </td>
        <td>PIP</td>
        <td>XXXXXXXXX, XXXXX</td>
        <td >
            AAAAA
        </td>
        <td>Approved</td>
        <td>November 2015</td>
        <td>Not Accrued</td>
        <td>CASE COde-Nh Code</td>
        <td>Mandatory Safety</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>Dollar</td>
    </tr>
    <tr>
        <td >
        </td>
        <td>PIP</td>
        <td>XXXXXXX, XXXXXXXX</td>
        <td >iiiii</td>
        <td>Approved</td>
        <td>November 2015</td>
        <td>Not Accrued</td>
        <td>case code-nh code</td>
        <td>Mandatory Safety</td>
        <td>1</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>Dollar</td>
    </tr>
    <tr>
        <td >
        </td>
        <td>PIP</td>
        <td>XXXXXXX, XXXXXXX</td>
        <td >hhhhh</td>
        <td>Approved</td>
        <td>December 2015</td>
        <td>Not Accrued</td>
        <td>CODE-CODE</td>
        <td>Mandatory Safety</td>
        <td>123</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>Dollar</td>
    </tr>
    <tr>
        <td >
        </td>
        <td>PIP</td>
        <td>XXXXXXXX, XXXXXXX</td>
        <td >gfgggg</td>
        <td>Potential</td>
        <td>December 2015</td>
        <td>Not Accrued</td>
        <td/>
        <td>Mandatory Safety</td>
        <td>1 234</td>
        <td>1 234</td>
        <td>1 234</td>
        <td>0</td>
        <td>Dollar</td>
    </tr>
    <tr>
        <td >
        </td>
        <td>Overspend</td>
        <td>XXXXXXX, XXXXXXXX</td>
        <td >eeffff</td>
        <td>Potential</td>
        <td>November 2015</td>
        <td>Not Accrued</td>
        <td>CaseCode-Nh Code</td>
        <td>Mandatory Safety</td>
        <td>0</td>
        <td>-237 460</td>
        <td>-77 893</td>
        <td>-159 567</td>
        <td>Dollar</td>
    </tr>
    <tr>
        <td >
        </td>
        <td>Overspend</td>
        <td>XXXXXXXXX, XXXXXXX</td>
        <td >
            BBBBBBB
        </td>
        <td>Potential</td>
        <td>December 2015</td>
        <td>Not Accrued</td>
        <td>1234-1234</td>
        <td>Mandatory Safety</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>Dollar</td>
    </tr>
    <tr>
        <td >
        </td>
        <td>Overspend</td>
        <td>XXXXXX, XXXXXXXXX</td>
        <td >eeeeee</td>
        <td>Potential</td>
        <td>December 2015</td>
        <td>Not Accrued</td>
        <td>case code-nh code</td>
        <td>Mandatory Safety</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>Dollar</td>
    </tr>
    <tr>
        <td ></td>
        <td>Overspend</td>
        <td>XXXXXXX, XXXXXXXX</td>
        <td >eeee</td>
        <td>Potential</td>
        <td>December 2015</td>
        <td>Not Accrued</td>
        <td>CASE COde-Nh Code</td>
        <td>Mandatory Safety</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>Dollar</td>
    </tr>
    <tr>
        <td >
        </td>
        <td>Overspend</td>
        <td>XXXXXXXXX, XXXXX</td>
        <td >eee</td>
        <td>Submitted</td>
        <td>December 2015</td>
        <td>Not Accrued</td>
        <td>CODE-CODE</td>
        <td>Mandatory Safety</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>0</td>
        <td>Dollar</td>
    </tr>
</tbody>  
</table>

Hi @Kperroch!

Wow, that is an odd one. I think the change to the "or" filter type to allow other filter types.

I set up this demo to test it and yes, using "over or ad" does not return desired results, but oddly using "over|ad" does return the desired results.

I'll dig into this issue when I get some more time.

With further investigation it seem hide item which they are in a line color before ( in the screenshots white line are not taking in count ) or 1 line of 2.

Ok, it should be fixed now... silly "or" regex test wasn't correct.