Search

I'm searching for a solution to recreate this complex header using the dom options.

AFAIK FIxedHeader and complex headers are still not supported. See this thread. I believe Allan wants to post DT version 2 by the end of year.

The dt parameter of the select event gives you the Datatables API instance. So you don't need let table = $('#items').DataTable();. You can just use dt instead like this:

I think that I see the root of my issue.

Masterful! Is the table-cell DataTables or jQuery?

The export does only work on the data in the table itself. You didn't post fnOpen(), so I can't see what it's doing there, but there are a few forum threads (such as here, here and here) which explai…

Oh, I was looking in "DataTablesSrc" repo instead of "

Thanks for your response. It really resolve the problem.

I am using nested tables as shown in example below. The nesting part of table is working fine and it displays correctly. Problem is when I export to Excel or PDF then it only shows main table and not…

I would say the reason the colspan is set to the number of columns in the table is that it will have predicable behavior. Setting it to a large number may have unpredictable results with certain bro…

The missing colspan is in the "No Matching Records Found" cell

Datatables doesn't support dynamically adding columns. To add columns you will need to use destroy(), add the new columns then reinitialize Datatables. Can you use your legacy function to insert co…

https://live.datatables.net/hugutaju/11/edit?html,js,console,output

Ideas are always dangerous ;-)

Kevin,

Link to test case: https://jsfiddle.net/sleepy_loco/8muh20r3/

There are a few options columnDefs.targets that can be used. See the docs for all options. You can pass a variable to columnDefs.targets, something like this:

Yup - the DataTables / Bootstrap 5 integration stylesheet which is available in the datatables.net-bs5 package handles that. It sounds like you haven't included that stylesheet so you also aren't get…

heh, just a silly worse case scenario, but if I had 100000 rows and just wanted to load 1 row, I would probably see the screen flicker with all the awesome secret data. The SQL server does a pivo…

I am using Editor with Selectize, which loads the options as expected and I can successfully select multiple options and save to the database. However, when I go to edit that record, specifically the…