jQuery Datatables add column on condition

Question

I have a jQuery datatable that I use to display data after making a AJAX request. However, I want to add a third column to the table if the current user is an administrator so that they can delete an entry. How would I add a third column based on a conditional statement? Thanks.

Code:

    // Create our AJAX request to get the data
    new Ajax.Request( combat_record_link,
    {
        method: 'get',
        evalJSON: 'force',
        parameters: {
            'md5check': ipb.vars['secure_hash']
        },
        onSuccess: function(t)
        {
            if( Object.isUndefined( t.responseJSON ) )
            {
                alert( "Bad Request" );
            }
            else if ( t.responseJSON['error'] )
            {
                alert( t.responseJSON['error'] );
            }
            else
            {
                jQuery('#combat_record').dataTable( {
                    "data": t.responseJSON,
                    "paging": true,
                    "ordering": true,
                    "order": [[ 0, "desc" ]],
                    "info": false,
                    "columns": [
                        { "title": "Date", "width": "10%", "data": "date"},
                        { "title": "Entry", "width": "90%", "data": "entry", "orderable": false},
                    ]
                });                 
            }
        }
    });

Thanks for asking this question, it helped me. Please be responsible to accept the working answer. — Code Lover
– Code Lover, Commented Jan 13, 2021 at 3:46

TheDude · Accepted Answer · 2014-08-24 22:32:15Z

13

You can just do:

var columns = [{ "title": "Date", "width": "10%", "data": "date"},
               { "title": "Entry", "width": "90%", "data": "entry", "orderable": false}];

if(isAdmin){
   columns.push({"title": "Delete", ...});
}

jQuery('#combat_record').dataTable( {
                    "data": t.responseJSON,
                    "paging": true,
                    "ordering": true,
                    "order": [[ 0, "desc" ]],
                    "info": false,
                    "columns": columns
});

answered Aug 24, 2014 at 22:32

TheDude

3,9722 gold badges32 silver badges51 bronze badges

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

2 Comments

Phate01 Over a year ago

This should be the accepted answer. Worked perfectly, thanks!

Code Lover Over a year ago

Thank you! I don't know why the answer is not accepted yet.

Collectives™ on Stack Overflow

jQuery Datatables add column on condition

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related