format data from server

chrisg123

I receive an 'amount' from the server as an integer (ex. 1000)
I know using the render method I can change its display format in the table, however, I would like to change the underlying value client side. (ex. amount/100) for all rows

How might I do this?

chrisg123

Solved my own question:

ajax: {
            url:myUrl,
            dataSrc: function(json){//format data from server here
                for (var i=0,l=json.length; i<l; i++) {
                    val = json[i];
                    if(val.hasOwnProperty('amount')){
                        transaction.amount = transaction.amount/100;
                    }

                }
                return json;
            }...

and if you are using editor:

 ajax: {
            url:"myEditorUrl",
            data: function(d){// convert back for server submit
                d.data.amount = d.data.amount * 100;
            }...

 editor.on('postSubmit', function(e,json,data,action) {
        json.row.amount = json.row.amount /100;//convert response from server back again

    } );

allan

Thanks for posting back - that is absolutely how I would suggest doing it myself.

Allan