replace value for any text

impex09

Hi, I have a table with field "Level" so in my data base this value is numeric
1 = BEGIN
2 = MEDIUM
3 = EXPERT

so, in my frontend, when the field = 1, show BEGIN, when 2 show MEDIUM, etc

thank you

ntstravel

Use a render function, so in your columns option:

{
    data: 'level_id',
    // return the name of the level, given the id
    render: function (data, type, row) {
        switch(data) {
        case 1:
            return 'One';
            break;  
        case 2:
            return 'Two';
            break;
        default:
            return 'Error!';
        }
    },
},

This could be better done (not hard-coded like this) by passing your JS an associative array and looking up the result. But see if you can get it working like this for now.

allan

I'd suggest also reading the orthogonal data manual page as you might want to order by the level_id rather than alphabetically.

Allan