Updating cell value/HTML in a hidden column

jLinux · September 2015

Im using the DataTable Buttons extension to manage the visibility of the columns in a table.

When someone updates an "asset" (Meaning the data in a row), via the jQuery x-editable plugin, I use the success handler to get the username that just edited the value, as well as the timestamp, from the AJAX request result, then update the modified and modifier column values.

My question is, when someone has the column hidden, I cant update the value in the DOM, is there a way to update the cell value when its not visible?

The code im using below (I know it isnt DataTables, just my jQuery, but it might help)

$(document).ready(function(){
    wp.hooks.addAction( 'assets.xeditable.success', function(data) {
        var modified = data.response.asset.modified;
        var modifier = data.response.asset.modifier;
        var modifier_username = data.response.asset.modifier_username;

        // Get the correct row in DataTables
        var $asset_row = $( '#data-table' ).find('tbody' ).find('tr[data-row-id="' + data.asset_id + '"]' );

        // Update the Modified and Modifier columns in DataTables
        $asset_row.find( 'td.modified' ).html(modified);
        $asset_row.find( 'td.modifier' ).html('<a href="/account/details/' + modifier + '">' + modifier_username + '</a>');
    } );
});

Again, im not asking for help with the jQuery x-editable plugin, just need to know how to update the value of a cell in a hidden column within DataTables

jLinux · September 2015

I feel like I'm ALMOST there..

Function: assets.list()

/*-------------------------------------------------------------
 * Function: assets.list()
 */
// Cache the body handler
var $body = $( 'body' );

// Main reference for Assets List DataTable
var $assets_table = $( '#data-table' );

// Initialize DataTable
var $assets_dt = $assets_table.DataTable( {
    buttons: [],
    select: {
        style: 'multi'
    },
    language: {
        "search": "Filter Assets"
    },
    lengthMenu: [
        [5, 10, 15, 20, 25, 30, 40, 50, -1],
        [5, 10, 15, 20, 25, 30, 40, 50, "All"]
    ],
    pageLength: 10,
    createdRow: function ( row, data, index ) {
        wp.hooks.doAction('assets.datatable.createrow', {
            row: row,
            data: data,
            index: index
        });
    },
    dom: 'BT<"clear">lfrtip', //Bfrtip
    drawCallback:function(){
        var page_min = 5;
        var $api = this.api();
        var pages = $api.page.info().pages;
        var rows = $api.data().length;
    }
} );

Function: assets.editable()

/*-------------------------------------------------------------
 * Function: assets.editable()
 */
// String and Text xeditable fields
$( '.string-edit' ).each( function ( name, field ) {
    var $this = $( this );

    if ( ! error ) {
        // Store the current value in memory for any calls to the
        // xeditable action, and update after doAction
        var current_value = $this.text();

        // Static data for any API calls
        var asset_data = {
            asset_id:   $this.closest( 'tr' ).data('row-id'),
            row:        $this.closest( 'tr' ).index(),
            column:     $this.closest( 'tr' ).children().index($this.parent()),
            field:      $this.context.id,
            type:       'string',
            prev_value: current_value
        };

        $this.editable( {
            placement: 'top',
            // Add an additional asset_id key for the API call
            params: function (params) {
                return $.extend(params, {asset_id: params.pk});
            },
            success: function ( response, newValue ) {
                // Execute the xeditable success action
                wp.hooks.doAction('assets.xeditable.success', $.extend(asset_data, {
                    response:   response,
                    new_value:  newValue
                }));

                // Update the current_value to the new value
                current_value = newValue;
            },
            error: function(response, newValue) {
                wp.hooks.doAction('assets.xeditable.error', $.extend(asset_data, {
                    response:   response,
                    new_value:  newValue
                }));

                return response.statusText;
            }
        } );
    } else {
        $this.replaceWith( $this.text() );
    }
} );

var $assets_table = $( '#data-table' );

var $assets_dt = $assets_table.DataTable();

wp.hooks.addAction( 'assets.xeditable.success', function(data) {
    /*
     console.log('========================================');
     console.log('Response:', data.response);
     console.log('Asset ID:', data.asset_id);
     console.log('Row:', data.row);
     console.log('Col:', data.column);
     console.log('Field:', data.field);
     console.log('Type:', data.type);
     console.log('Old:', data.prev_value);
     console.log('Val:', data.new_value);
     */
    var modified = data.response.asset.modified;
    var modifier = data.response.asset.modifier;
    var modifier_username = data.response.asset.modifier_username;

    var $asset_row = $assets_table.find( 'tbody' ).find( 'tr[data-row-id="' + data.asset_id + '"]' );

    var modified_cell = $assets_dt.cell( $asset_row.find( 'td.modified' ) );
    modified_cell.data( modified ).draw();

    var modifier_cell = $assets_dt.cell( $asset_row.find( 'td.modifier' ) );
    modifier_cell.data( '<a href="/account/details/' + modifier + '">' + modifier_username + '</a>' ).draw();

    //$asset_row.find( 'td.modified' ).html(modified);
    //$asset_row.find( 'td.modifier' ).html('<a href="/account/details/' + modifier + '">' + modifier_username + '</a>');
} );

Error: jquery.dataTables.js:8669 Uncaught TypeError: Cannot read property 'row' of undefined

jLinux · September 2015

P.S. The above code seems to work ok as long as the column isnt hidden...

jLinux · September 2015

I guess this might be the answer?

Found it from here

It seems to be for Legacy DT though

jLinux · September 2015

Also tried to just reset it in the DOM and invalidate the cells, no success

var $assets_table = $( '#data-table' );

var $assets_dt = $assets_table.DataTable();

wp.hooks.addAction( 'assets.xeditable.success', function(data) {
    var modified = data.response.asset.modified;
    var modifier = data.response.asset.modifier;
    var modifier_username = data.response.asset.modifier_username;

    var $asset_row = $assets_table.find( 'tbody' ).find( 'tr[data-row-id="' + data.asset_id + '"]' );

    var modified_cell = $assets_dt.cell( $asset_row.find( 'td.modified' ) );
    //modified_cell.data( modified ).draw();

    var modifier_cell = $assets_dt.cell( $asset_row.find( 'td.modifier' ) );
    //modifier_cell.data( '<a href="/account/details/' + modifier + '">' + modifier_username + '</a>' ).draw();

    $asset_row.find( 'td.modified' ).html(modified);
    $asset_row.find( 'td.modifier' ).html('<a href="/account/details/' + modifier + '">' + modifier_username + '</a>');

    $assets_dt.cell( modified_cell ).invalidate().draw();
    $assets_dt.cell( modifier_cell ).invalidate().draw();
} );

jLinux · September 2015

Bump anyone?

glenderson · September 2015

I think I would use the .data method for this

var table = $(#yourtable).DataTable();
var d = table.row(#yourRow).data();
d[0] (or d["columnName"]) = "New Value";
table.row(#yourRow).data(d).draw();

jLinux · September 2015

@glenderson, did you see my 2nd post? The code snippet in the bottom?... Here it is again

/*-------------------------------------------------------------
 * Function: assets.editable()
 */
// String and Text xeditable fields
$( '.string-edit' ).each( function ( name, field ) {
    var $this = $( this );
 
    if ( ! error ) {
        // Store the current value in memory for any calls to the
        // xeditable action, and update after doAction
        var current_value = $this.text();
 
        // Static data for any API calls
        var asset_data = {
            asset_id:   $this.closest( 'tr' ).data('row-id'),
            row:        $this.closest( 'tr' ).index(),
            column:     $this.closest( 'tr' ).children().index($this.parent()),
            field:      $this.context.id,
            type:       'string',
            prev_value: current_value
        };
 
        $this.editable( {
            placement: 'top',
            // Add an additional asset_id key for the API call
            params: function (params) {
                return $.extend(params, {asset_id: params.pk});
            },
            success: function ( response, newValue ) {
                // Execute the xeditable success action
                wp.hooks.doAction('assets.xeditable.success', $.extend(asset_data, {
                    response:   response,
                    new_value:  newValue
                }));
 
                // Update the current_value to the new value
                current_value = newValue;
            },
            error: function(response, newValue) {
                wp.hooks.doAction('assets.xeditable.error', $.extend(asset_data, {
                    response:   response,
                    new_value:  newValue
                }));
 
                return response.statusText;
            }
        } );
    } else {
        $this.replaceWith( $this.text() );
    }
} );
 
var $assets_table = $( '#data-table' );
 
var $assets_dt = $assets_table.DataTable();
 
wp.hooks.addAction( 'assets.xeditable.success', function(data) {
    /*
     console.log('========================================');
     console.log('Response:', data.response);
     console.log('Asset ID:', data.asset_id);
     console.log('Row:', data.row);
     console.log('Col:', data.column);
     console.log('Field:', data.field);
     console.log('Type:', data.type);
     console.log('Old:', data.prev_value);
     console.log('Val:', data.new_value);
     */
    var modified = data.response.asset.modified;
    var modifier = data.response.asset.modifier;
    var modifier_username = data.response.asset.modifier_username;
 
    var $asset_row = $assets_table.find( 'tbody' ).find( 'tr[data-row-id="' + data.asset_id + '"]' );
 
    var modified_cell = $assets_dt.cell( $asset_row.find( 'td.modified' ) );
    modified_cell.data( modified ).draw();
 
    var modifier_cell = $assets_dt.cell( $asset_row.find( 'td.modifier' ) );
    modifier_cell.data( '<a href="/account/details/' + modifier + '">' + modifier_username + '</a>' ).draw();
 
    //$asset_row.find( 'td.modified' ).html(modified);
    //$asset_row.find( 'td.modifier' ).html('<a href="/account/details/' + modifier + '">' + modifier_username + '</a>');
} );

Error: Uncaught TypeError: Cannot read property 'row' of undefined on jquery.dataTables.js:8669

jLinux · September 2015

@glenderson When I try your code:

var $assets_table = $( '#data-table' );

var $assets_dt = $assets_table.DataTable();

// Use a plugin hook to update the table row after any update
wp.hooks.addAction( 'assets.xeditable.success', function(data) {

    console.log('========================================');
    console.log('Response:', data.response);
    console.log('Asset ID:', data.asset_id);
    console.log('Row:', data.row);
    console.log('Col:', data.column);
    console.log('Field:', data.field);
    console.log('Type:', data.type);
    console.log('Old:', data.prev_value);
    console.log('Val:', data.new_value);

    var modifier = data.response.asset.modifier;
    var modified = data.response.asset.modified;
    var modifier_username = data.response.asset.modifier_username;

    var $asset_row = $assets_table.find( 'tbody' ).find( 'tr[data-row-id="' + data.asset_id + '"]' );

    var d = $assets_dt.row($asset_row).data();
    d[2] = modifier;
    d[3] = modified;
    $assets_dt.row($asset_row).data(d).draw();

    var modified_cell = $assets_dt.cell( $asset_row.find( 'td.modified' ) );
    modified_cell.data( modified ).draw();

    var modifier_cell = $assets_dt.cell( $asset_row.find( 'td.modifier' ) );
    modifier_cell.data( '<a href="/account/details/' + modifier + '">' + modifier_username + '</a>' ).draw();

    //$asset_row.find( 'td.modified' ).html(modified);
    //$asset_row.find( 'td.modifier' ).html('<a href="/account/details/' + modifier + '">' + modifier_username + '</a>');

    //$assets_dt.cell( modified_cell ).invalidate().draw();
    //$assets_dt.cell( modifier_cell ).invalidate().draw();
} );

The error alert: DataTables warning: table id=data-table - Requested unknown parameter '[object Object]' for row 0. For more information about this error, please see http://datatables.net/tn/4

And in the console: Uncaught TypeError: Cannot assign to read only property 'display' of Sep 18, 2015, 7:06:22 MST

glenderson · September 2015

I'm not sure what your modifier and modified are supposed to be sorry, but they should be the new contents of cell (2) and cell (3). Please note [2] and [3] can only be used if you don't name your columns. If you name, then then d["columnName"] must be used.

Here's a simple fiddle using parts of your code.

http://jsfiddle.net/glenderson/om30e27x/

It's takes the table and updates the "name" column in row #1 to be "A New User". There is first an alert just to show the contents of the row prior to change.

Hope this helps.

jLinux · September 2015

The issue that im referring to though, (the thread topic), is that I cant update the content of the cell, if the column is hidden...

glenderson · September 2015

Here's an update that better shows how to hide the column, display the column, and apply an update to the column.

Please note, the jQuery selector is ONLY picking up the first row <TR>. To accurately select a row, I would suggest including an id on each row.

http://jsfiddle.net/glenderson/om30e27x/3/

The "myColumn" class is applied to the "name" column as part of the table initialization.
myColumn is initially hidden.
You can toggle the display of the "name" column via the button.
Enter a new value for Row #1 (always row #1 in this example).
Hit the button to apply the change.
Whether the row is displayed or not, it gets updated.

jLinux · September 2015

Thanks so far @glenderson

Good news! I got the Modifier and Modified columns to update, even when the column is hidden..

Bad news Since Im updating the entire row, it breaks the (x-editable)[https://vitalets.github.io/x-editable/] in the cell thats being updated.. Code below:

// Use a plugin hook to update the table row after any update
wp.hooks.addAction( 'assets.xeditable.success', function(data) {
    console.log('========================================');
    console.log('Resp:',  data.response);
    console.log('Asset:', data.asset_id);
    console.log('Row:',   data.row);
    console.log('Col:',   data.column);
    console.log('Field:', data.field);
    console.log('Type:',  data.type);
    console.log('Old:',   data.prev_value);
    console.log('Val:',   data.new_value);

    var modifier = data.response.asset.modifier;
    var modified = data.response.asset.modified;
    var modifier_username = data.response.asset.modifier_username;

    var $asset_row = $assets_table
        .find( 'tbody' )
        .find( 'tr[data-row-id="' + data.asset_id + '"]' );

    var row_data = $assets_dt.row($asset_row).data();

    row_data["modified"] = modified;
    row_data["modifier"] = '<a href="/account/details/' + modifier + '">' + modifier_username + '</a>';

    $assets_dt.row($asset_row).data(row_data).draw();
} );

So I think if I redraw the cell, (not the whole row) it should work...

But when I comment out the last row with the draw(), and add...

            var modified_cell = $assets_dt.cell( $asset_row.find( 'td[data-field="modified"]' ) );
            modified_cell.data( modified ).draw();

I get the error posted above, which is jquery.dataTables.js:8669 - Uncaught TypeError: Cannot read property 'row' of undefined

I believe it breaks the x-editable because when the whole row is redrawn, it takes it from the DOM again (as thats the source), and xeditable changes the contents of the cell when its completed, so those are conflicting actions

jLinux · September 2015

And heres the DOM elements of the table, you can see the row > td has the modifier and modified data-field attribute values
http://d.pr/i/1fK6E

jLinux · September 2015

@glenderson I really appreciate you trying to help me out with this btw, its really holding me back

allan · September 2015

I've just thrown together this test case and is seems to work just fine for me.

Try simplifying your selector and use:

$assets_dt.cell( 'td[data-field="modified"]' )

Failing that, please link to a test case showing the issue.

Allan

jLinux · September 2015

Uhm... that will always just update the very first row though... every row in that column has data-field="modified"

jLinux · September 2015

Here, I tried to replicate it as much as I could on live.datatables.net, I had to use the more complicated selector in the cell so it would update just the necessary row...

http://live.datatables.net/duluravi/1/edit?html,js,output

it will update the value if its visible, but if its not, it wont

Whats more, the error when viewing the JS console (Not the console in the editor, no idea where that gets its data..) the error is exactly what I see.. :-D Yay, now I can replicate it.

glenderson · September 2015

With colVis, the columns are not just being hidden, they are literally being removed from the DOM. If you inspect the element, you will see they are totally removed from the DOM, not just set to display:hidden. As such, jQuery selectors cannot locate the data-modified attribute because the td does not exist in the jQuery space. It only exists in the dataTable data array. if you alert on your value, it will be NaN.

If you use the table.row(row).draw(d) method, it works for a named column. But if your modified column can be any column, and it can be hidden, then you'll need a completely different manner of specifying which column is being updated per row. You cannot rely on the DOM because the column might be removed, and thus jQuery cannot find it.

If you hide the columns with a class instead of colVis, then your code should work.

In looking into the button.colVis extension, I could not figure out how to easily access that stored array. In theory, you should be able to access the stored invisible column to determine if there's the attribute of data-field. But, it was tasking me too long to figure it out. Sorry.

So I then starting thinking about putting the modified column name into a row attribute instead.

<tr data-modified="value">....</tr>
<tr data-modified="id">....</tr>

Then you can read what column by the data-modified value was modified, and it can be different for each row. Since you know the row, read the column data-modified value, then update the data[] value, and cell().draw(d) just that cell. Only thing I could think of quickly to overcome your issue.

allan · September 2015

I had assumed that the editable library you are using was adding the modified attribute.

What glenderson says is absolutely correct (although I would suggest avoiding hiding DataTables elements with a class and use DataTables methods instead).

To get the cell - just use the cell() method :-). Here is your example updated: http://live.datatables.net/duluravi/7/edit

Allan

jLinux · September 2015

@allan, that example works for you? The cell gets updated when the col is hidden? It doesnt for me. @glenderson, how about you? Give it a shot

jLinux · September 2015

I tried some new stuff, like redrawing just the cell, but it didnt seem to work (unless im doing it wrong)

var $assets_table = $( '#data-table' );

var $assets_dt = $assets_table.DataTable();

// Use a plugin hook to update the table row after any update
wp.hooks.addAction( 'assets.xeditable.success', function(data) {
    console.log('========================================');
    console.log('Resp:',  data.response);
    console.log('Asset:', data.asset_id);
    console.log('Row:',   data.row);
    console.log('Col:',   data.column);
    console.log('Field:', data.field);
    console.log('Type:',  data.type);
    console.log('Old:',   data.prev_value);
    console.log('Val:',   data.new_value);

    var modifier = data.response.asset.modifier;
    var modified = data.response.asset.modified;
    var modifier_username = data.response.asset.modifier_username;

    var $asset_row = $assets_table.find( 'tbody' ).find( 'tr[data-row-id="' + data.asset_id + '"]' );

    var row_data = $assets_dt.row($asset_row).data();
    
    row_data["modified"] = modified;
    row_data["modifier"] = '<a href="/account/details/' + modifier + '">' + modifier_username + '</a>';
    

    // None of the below seem to work when trying to redraw just the cell
    //$assets_dt.cell( $asset_row.find('td[data-field="modified"]') ).draw();
    //$assets_dt.cell( 'tr[data-row-id="' + data.asset_id + '"] td[data-field="modified"]' ).draw();
    //$assets_dt.cell( 3 ).draw();
    //$assets_dt.cell( $asset_row.find('td[data-field="modified"]') ).data({ modified: modified }).draw();
} );

The very last try however, $assets_dt.cell( $asset_row.find('td[data-field="modified"]') ).data({ modified: modified }).draw();, seems to update the modified column, with an object?

@glenderson

Then you can read what column by the data-modified value was modified, and it can be different for each row. Since you know the row, read the column data-modified value, then update the data[] value, and cell().draw(d) just that cell. Only thing I could think of quickly to overcome your issue.

The Rows each have a data-row-id attribute that I use to find the rows, the row ID is the asset ID, and each cell has a data-field='field-name' which is also the name of the DataTable column, when DataTable is actually initialized, the jQuery goes through and gets these attributes (since they're also in the header, the same way), heres the relevant code for the initialization

list: function () {
    "use strict";

    // Cache the body handler
    var $body = $( 'body' );

    // Main reference for Assets List DataTable
    var $assets_table = $( '#data-table' );

    var columns = [];

    // Get the names of the columns (In the IDs of the first header)
    $assets_table.find( 'thead' ).eq( 0 ).find( 'tr' ).find( 'th' ).each( function ( i, v ) {
        columns.push( {
            data: $( this ).attr( 'id' )
        } );
    } );

    // Initialize DataTable
    var $assets_dt = $assets_table.DataTable( {
        columns: columns,
        conditionalPaging: {
            style: 'fade',
            speed: 500
        },
        searchHighlight: true,
        // Have to add an empty buttons initiation, so buttons can be added later
        buttons: [],
        select: {
            style: 'multi'
        },
        language: {
            "search": "Filter Assets"
        },
        lengthMenu: [
            [ 5, 10, 15, 20, 25, 30, 40, 50, - 1 ],
            [ 5, 10, 15, 20, 25, 30, 40, 50, "All" ]
        ],
        pageLength: 10,
        createdRow: function ( row, data, index ) {
            wp.hooks.doAction( 'assets.datatable.createrow', {
                row: row,
                data: data,
                index: index
            } );
        },
        dom: 'BT<"clear">lfrtip'
    } );

    // Set the search text in the URL hash whenever a search is executed
    $assets_dt.on( 'search.dt', function () {
        window.location.hash = $assets_dt.search();
    } );

    // See if a search string is set in the URL hash, if so, execute a DT search
    var search_str = window.location.hash.substring( 1 );
    if ( search_str ) {
        $assets_dt.search( search_str ).draw();
    }
}

Heres the DOM
http://d.pr/i/1cHa6

Does that help at all?

jLinux · September 2015

For now, I kinda just decided to show the columns using column().visible() before the value gets updated... I guess thats not a terrible idea, it will have the viewer realize the values were updated. I might have the color change and fade out (since the value that was updated in the row does the same)

wp.hooks.addAction( 'assets.xeditable.success', function(data) {
    console.log('========================================');
    console.log('Resp:',  data.response);
    console.log('Asset:', data.asset_id);
    console.log('Row:',   data.row);
    console.log('Col:',   data.column);
    console.log('Field:', data.field);
    console.log('Type:',  data.type);
    console.log('Old:',   data.prev_value);
    console.log('Val:',   data.new_value);

    var modifier = data.response.asset.modifier;
    var modified = data.response.asset.modified;
    var modifier_username = data.response.asset.modifier_username;

    var $asset_row = $assets_table.find( 'tbody' ).find( 'tr[data-row-id="' + data.asset_id + '"]' );

    // Show the modified/modifier columns
    $assets_dt.column( 2 ).visible( true, false );
    $assets_dt.column( 3 ).visible( true, false );

    // Update/draw modified datetime
    $assets_dt.cell( $asset_row.find( 'td[data-field="modified"]' ) ).data( modified ).draw();

    // Update/draw modifier link
    $assets_dt.cell( $asset_row.find( 'td[data-field="modifier"]' ) );.data( '<a href="/account/details/' + modifier + '">' + modifier_username + '</a>' ).draw();
} );

That works for now I suppose :-\ Im showing the columns using the numerical value of the column, such as table.column( 2 ).visible( true, false );, is there a way to use the name of the column? Such as whats defined when the table is initiated? (like table.column( 'modified' ).visible( true, false );, which I tried, and failed)

One more question since I'm here, related to this.

As you can see [here|http://d.pr/i/1cHa6], the modified column/cells have a data-filter attribute, with the actual Unix timestamp, is it possible to update that value as well?

Thanks for the support thus far @allan @glenderson!

allan · September 2015

Oops - I hid the wrong column while testing it...

is there a way to use the name of the column? Such as whats defined when the table is initiated

Yes.

I'll come back to this when I'm able, I'm sure there is a better way.

Allan

jLinux · September 2015

@allan

I'll come back to this when I'm able, I'm sure there is a better way.

I would think so too, the DT API is very powerful, I was thinking that there was an easy solution that I just wasn't seeing and couldn't find.

Thanks!

jLinux · September 2015

@allan

Yes

Ok. I got it to work in the same function I initialized the table in, but if I go to a different function, where I re-initialize the DT to have access to it, it doesnt work, and if I pass the column names when I re-initialize the table, it still doesnt work, it alerts:

DataTables warning: table id=data-table - Cannot reinitialise DataTable. For more information about this error, please see http://datatables.net/tn/3

Test Case, but if you dont have time to look at this, thats fine, the col visibility one is more important, lol (Plus it would void the need for this)

allan · September 2015

Your example doesn't use the columns.name property which is required to name a column if you want to use that name in a column selector. This is referenced in the column selector documentation I linked to above.

Allan

jLinux · September 2015

Oh wow, weird, when I used columns.data, it would work when referencing them by the name (of the data) in the same scope, so I thought that was fine. weird.

Thanks!

Updating cell value/HTML in a hidden column

Updating cell value/HTML in a hidden column

Answers

Howdy, Stranger!

Categories

DataTables

Updating cell value/HTML in a hidden column

Updating cell value/HTML in a hidden column

Answers

Howdy, Stranger!

Quick Links

Categories

DataTables