change the value of the one column in one row

guillermovil

Hi, I need to update the value of a cell in a row.
I go through the table in the following way:

            var existe = false;
            detalles.rows().every(function (value, index) {
                var data = this.data();
                if(data.prod_code == $('#prod_code').val()){
                    existe = true;

                }
            }); 

instead of
exists = true
I want to change the value of the prod_quantity column.
How can I do?

colin

Hi @guillermovil ,

You can set the data for that row with row().data() (or cell().data() for individual cells). Note you have to do the draw() afterwards, but you'll see that in the examples.

Cheers,

Colin

guillermovil

Colin, could you please give me an example?
My table is defined as follows:

        //Tabla de detalles
        var detalles = $('#detalles_table').DataTable({
            "searching": false,
            "processing": true,
            "serverSide": false,
            "lengthChange": false, 
            "info": false,           
            "paging": false,
            "columns": [
                    { "data":"prod_code", "width": "5%"},
                    { "data":"prod_descrip"},
                    { "data":"prod_cantidad", "width": "10%" },
                    { "data":"prod_precio", "width": "10%"},
                    { "data": "accion", "width": "10%"}
               ]     

        });

I tried the following but the value is not modified

$('#addRow').on( 'click', function () {
    //verifico que el producto todavía no esté en la grilla
    var existe = false;
    detalles.rows().every(function (value, index) {
        var data = this.data();
        if(data.prod_code == $('#prod_code').val()){
            existe = true;
            data.prod_cantidad++;   
            detalles.draw(false);               
        }
    });         
} );

colin

Hi @guillermovil ,

You're updating the local copy, but not writing it back.

Try changing your line 9 from

            detalles.draw(false);              

to

            this.data(data).draw(false);              

If no joy, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Cheers,

Colin

guillermovil

muchas gracias Colin!!
thank you very much Colin!!