row select - selector-modifier

montoyam

I have a table where I want to select all records where a data field has a value. Is this possible?

something like:

table.rows(Users.UserID != '').select();

kthorngren

Use the row-selector as a function to return the rows that Users.UserID != ''.

Kevin

montoyam

with that advice this is what I came up with...not sure if it is the best/only way???

        var indexes = RequestDetailTable.rows().eq(0).filter(function (rowIdx) {
            console.log(RequestDetailTable.cell(rowIdx, 5).data());
            return RequestDetailTable.cell(rowIdx, 5).data() == null ? false : true;
        });
        RequestDetailTable.rows(indexes)
            .nodes()
            .to$()
            .addClass('highlight');
        RequestDetailTable.rows('.highlight').select();

kthorngren

In the row-selector docs see the function example which is used to return just the rows that match criteria.

Kevin

kthorngren

Here is an example:
http://live.datatables.net/xulifexe/1/edit

Kevin

montoyam

oh, yeah, that is MUCH cleaner... thanks!!

        RequestDetailTable
            .rows(function (idx, data, node) {
                return data.Users.UserID != null ? true : false;
            })
            .select();