How to add extra columns?

Ok… found a similar topic in a discussion forum at datatables.net

The solution sounds simple but I can’t get it up and running. I have to use aoColumns and mDataProp to define a null value for the extra column.

Example looks like

"aoColumns": [
            {
               "mDataProp": null,
               "sClass": "control center",
               "sDefaultContent": '<img src="'+sImageUrl+'details_open.png'+'">'
            },
            { "mDataProp": "engine" },
            { "mDataProp": "browser" },
            { "mDataProp": "grade" }
        ]

But how do I add those options to my dtoptions? There are square and curly brackets which will brake the shortcode of cfdb-datatable if i use them.

Any help would be appreciated.

Thanks in advance!

– Markus

Is it really that simple??? I’ve got a database with 5 fields:

aaa,bbb,ccc,ddd,eee

And my cfdb-datatable shortcode looks like this:

[cfdb-datatable form="Eingabemaske" unbuffered="true" filter="submit_time>-$_GET(zeitraum)" show="aaa,bbb,ccc,ddd,eee" headers="aaa=Header1,bbb=Header2,ccc=Header3,ddd=Header4,eee=Header5" dt_options="bJQueryUI:true,aLengthMenu:new Array(10,25,50),sScrollX:'100%',iDisplayLength:10,bScrollCollapse:true,bPaginate:true,bProcessing:true,sPaginationType:'two_button'"]

I’ve just added the name of a field which isn’t in my db and… it works!

[cfdb-datatable form="Eingabemaske" unbuffered="true" filter="submit_time>-$_GET(zeitraum)" show="aaa,bbb,ccc,ddd,eee,notindb" headers="aaa=Header1,bbb=Header2,ccc=Header3,ddd=Header4,eee=Header5,notindb=NotInDB" dt_options="bJQueryUI:true,aLengthMenu:new Array(10,25,50),sScrollX:'100%',iDisplayLength:10,bScrollCollapse:true,bPaginate:true,bProcessing:true,sPaginationType:'two_button'"]

The empty field is easily filled with content (Edit-Button, Delete-Button, etc.) after reading this great post: Make links clickable in tables.

Maybe my posts are helpful for others…

Regards

– Markus