How to Convert Datatables Value from Integer to String

Question

I have a problem like my title. Here is the data I want to convert:

I want to convert 1 to Active and 0 to Not Active.

This is my datatables script:

$(function () {
            $('#userTable').DataTable({
                "paging": true,
                "lengthChange": true,
                "searching": true,
                "ordering": true,
                "info": true,
                "autoWidth": true,
                "scrollX": true,
                "ajax": {
                    "url" : "admin/auth/getUserData",
                    "dataSrc" : function(json) {
                        console.log(json);
                        return json.Users
                    }
                },
                "columns": [
                    { "data": "Username"},
                    { "data": "Email"},
                    { "data": "Fullname"},
                    { "data": "IdentityNumber"},
                    { "data": "InstitutionName"},
                    { "data": "UserStatus"},
});
        });

In our logic, it must be

if("data":"UserStatus" == 1)
    document.write("Active");
else
    document.write("Not active");

I've tried the code above but it failed to get the output I want. Can anybody help me fix this? Thanks

I believe you missed the "columns" part of it, so it doesn't know where to actually check and get the value 1 Could you show us the HTML that you're using for this section as well? — aashnisshah
– aashnisshah, Commented Dec 7, 2015 at 5:20
The line if("data":"UserStatus" == 1) is not valid JavaScript. — Ram
– Ram, Commented Dec 7, 2015 at 5:23
try to get value by ID or class , then check inside if condition — Shasha
– Shasha, Commented Dec 7, 2015 at 5:26

davidkonrad · Accepted Answer · 2015-12-07 06:03:12Z

9

You can use a columns render function to do that :

"columns": [
   { "data": "Username"},
   { "data": "Email"},
   { "data": "Fullname"},
   { "data": "IdentityNumber"},
   { "data": "InstitutionName"},
   { "data": "UserStatus",
      render : function(data) {
         return data == '0' ? 'Not Active' : 'Active';
      }
   }
]

answered Dec 7, 2015 at 6:03

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Convert Datatables Value from Integer to String

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related