Adding and Removing a row indirectly from secondary table

Sageis1

Currently I have two tables, table 1 contains all the data, table 2 is empty, what i want is a toggle like functionality.

If i check a checkbox, it added the checked row to the new table, if i uncheck it it removes that row from the new table.

Currently I am able to get the data needed to add to the new table, I'm just not sure how to do that.

Here is the test case: http://live.datatables.net/weluyanu/47/edit

kthorngren

Use row.add() to add the row. Use row().remove() to remove the row. Use the row-selector as a function to select only the rows that match the name.

Kevin

Sageis1

@kthorngren im having issues just getting the complete data into the table, also im not sure on the logic part of removing and adding a table.

Sageis1

Here the test case: http://live.datatables.net/weluyanu/48/edit

kthorngren

The row.add() docs state this:

Data to use for the new row. This may be an array, object, Javascript object instance or a tr element.

You are adding a string. You need to place your column data in an array. Something like this:

table2.row.add([data[1]]).draw();

Kevin

Sageis1

@kthorngren Im just having issue distinguishing a check and a uncheck, do you have any idea on what to do with this

Here is the test case: http://live.datatables.net/weluyanu/49/edit

kthorngren

Look at this example from your other thread.

Kevin

Sageis1

@kthorngren, Im still having issue getting the actual data from the change event,
Here is the test case: http://live.datatables.net/lulaluye/11/edit

Also when removing the row with table.row.remove(?).draw(), for the question mark do i have to pass the data ive gotten or the row.

kthorngren

You commented out this line:

//var row2 = $(this).closest('tr').data();

This is needed to get the row that the clicked checkbox is on. In the function this is the checkbox not the row.

table.row.remove(?).draw(),

This should look like this table.row().remove().draw(). Note the row().

Kevin

Sageis1

@kthorngren, How do i access the values on the row

var row2 = $(this).closest('tr').data();

Im still having issue getting the data : http://live.datatables.net/lulaluye/13/edit

colin

You need to pass the node of the row into row(), like this:

    var row = table.row($(this).closest('tr')).data();

See updated example here: http://live.datatables.net/lulaluye/13/edit

Colin