How can I retrieve a row based on column values using jQuery DataTables?

Question

Is there a way to lookup a row in jQuery DataTables based upon column values? For example, can I determine which row contains a value of "foo" in column 1 and a value of "bar" in column 2? I would like to programmatically determine which row contains these values. Is the best solution to simply keep a separate data structure that ties the values and the row indexes together? I am wanting to delete a table row with columns containing the given values.

I am using DataTables 1.8.0 and jQuery 1.5.1.

glortho · Accepted Answer · 2011-06-22 19:31:44Z

6

I would get the data with fnGetData, loop through the rows and use $.inArray:

function getRow(table_id, arg1, arg2) {
    var oTable = $('#' + table_id).dataTable(),
        data = oTable.fnGetData(),
        row, i, l = data.length;

    for ( i = 0; i < l; i++ ) {
        row = data[i];

        // columns to search are hard-coded, but you could easily pass this in as well
        if ( $.inArray(arg1, row) == 0 && $.inArray(arg2, row) == 1 ) {
            return $('#' + table_id + ' tr').eq(i);
        }
    }
    return false;
}

$row = getRow('table_id', 'foo', 'bar');

NOTE: Untested

edited Jun 22, 2011 at 19:31

answered Jun 22, 2011 at 19:15

glortho

13.2k8 gold badges51 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Abe Miessler · Accepted Answer · 2011-06-22 21:11:19Z

2

Try using this selector:

$("tr td:nth-child(2):contains('value')").siblings(":contains('test')")

Take a look at this fiddle:

http://jsfiddle.net/B4wMp/8/

DataTable just gets rendered as a plain old html table.

edited Jun 22, 2011 at 21:11

answered Jun 22, 2011 at 19:10

Abe Miessler

85.7k104 gold badges323 silver badges496 bronze badges

1 Comment

glortho Over a year ago

Nice and concise, though contains will return true on partial values when you don't want it to – returning true for new york when you've asked for new. To target a specific column, you'll also have to add ...siblings.eq(column_n)..., making sure you choose the right one from the array based on the new indices that result from excluding the originally selected element.

user3214451 · Accepted Answer · 2018-05-13 22:00:24Z

0

I had a similar requirement. I'm using Datatable as well, but with a version >=1.10. fnGetData() is now missing.

Here is an adaptation of @glortho 's answer:

function getRow(tableId, propName, propValue) {
        var oTable = $('#' + tableId).DataTable(),
            data = oTable.rows().data(),
            row, i, l = data.length;

        for ( i = 0; i < l; i++ ) {
            row = data[i];


            if (row[propName] == propValue) {

                return $(`#${tableId}  tr`).eq(i+1);
            }
        }


        return false;
    }

answered May 13, 2018 at 22:00

user3214451

1243 bronze badges

Collectives™ on Stack Overflow

How can I retrieve a row based on column values using jQuery DataTables?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related