Responsive Column Control on Right with Server Side Processing

trevoc

I've created an extra header column in the html that is empty to store the +/- show/hide controls of the row details which is the 12'th column or id 11. I target this successfully with -1 in the columdefs.

It's working, but only after I receive the error that my server side script has no data for the column id 11 which is to hold the control.

If I target the 10'th column id, error averted, but it overlays the info in that field.

I'm guessing I need to return something to datatables to prevent the error.

is there any way to return empty strings or something without actually creating a blank column in my dbase view to return empty data?

TIA

trevoc

Not sure if datatables handles this gracefully, but for those ending up here, my workaround was to just create a dummy_column in my sql view.

select col1, col2, '' AS dummy_col3, col4 ...

and obviously include this in the server side processing script and the header for the table.