[SOLVED]Datagrid dynamic columns from json with formatter

[jega]

Hi.

Can't find a solution for this.

Having some column data with a formatter. The formatter is not always in the same column
[{
   "ID": 1,
   "field": "col1",
   "formatter": "formatNumber"
}, {
   "ID": 2,
   "field": "col2"
}, {
   "ID": 3,
   "field": "col3"
}]


Putting the column data in the grid

var dg = $('#dgList').datagrid({
   columns:[data]
});



Then i have this function

    function formatNumber(value,row){
        if (value < 0){
            return 'background-color:#ffee00;color:red;';
        }
    }


But i get this error:

TypeError: col.formatter is not a function

Any help

Regards Jesper

[jarry]

Please call this code instead.

Code:

[{
   "ID": 1,
   "field": "col1",
   "formatter": function(value,row){
   	return value + 'formatted';
   }
}, {
   "ID": 2,
   "field": "col2"
}, {
   "ID": 3,
   "field": "col3"
}]

[jega]

Hi Jarry.

I already have tried this, but it's not a valid json string. Try put it in jsonlint.com


I do an ajax request to my DB and create the json response like this.


jsonData = jsonData & chr(34) & "field" & chr(34) & ":" & chr(34) & rsData("COLUMN_NAME") & chr(34) & ","
jsonData = jsonData & chr(34) & "title" & chr(34) & ":" & chr(34) & rsData("COLUMN_TITLE") & chr(34) & ","
jsonData = jsonData & chr(34) & "sortable" & chr(34) & ":" & chr(34) & "true" & chr(34) & ","

and then, how to do the rest

jsonData = jsonData & chr(34) & "formatter" & chr(34) & ":" & ?


Jesper

[jarry]

Convert the 'formatNumber' string to a function before using it.

Code:

var data = [{
   "ID": 1,
   "field": "itemid",
   "formatter": "formatNumber"
}, {
   "ID": 2,
   "field": "col2"
}, {
   "ID": 3,
   "field": "col3"
}];
data.forEach(col => {
  if (col.formatter){
    col.formatter = eval(col.formatter)
  }
})
var dg = $('#dgList').datagrid({
   columns:[data]
});

[jega]

Hi Jarry

Thanks.

Now it works.