Search

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…

On a related note, there's a tiny typo on https://datatables.net/extensions/searchpanes/layout#Displaying-Panes-Vertically

I'm trying to move the searchPanes to the left of my table, and doing something wrong. I was hoping to find a live example of

Hello all,

Oops, it was a very long day... and forgot to use CSS !

I'm not clear if you are asking one or two questions.

One option might be to add the select-enabled class to the row instead of a cell. This way you can use the row-selector of a class in combination of the selector-modifier. Something like this:

With an Mjoin, currently no, that is not possible at this time. You can use a left join with an arbitarily complex expression, but Mjoin is a simple matching condition.