Search

Thanks for your question - however, per the forum rules can you link to a test case showing the issue please. This will allow the issue to be debugged. Information on how to create a test page, if you can't provide a link to your own page can be found here. Thanks, Allan

This isn't a DataTables issue, but rather a Bootstrap one. As you note, if you remove Bootstrap the issue goes away. By default Bootstrap 3 removes the clear icon. Allan

Argh. never mind, had 2 tags. Removed the bad one, all is good.

For those interested, here is a solution http://stackoverflow.com/a/36274599/615379

A workaround I'm using right now is to build a filter string with pipe character (regex or) table.column(2).search('Tokyo|New York', true, false).draw();

could you please be specific. or provide a screenshot.

With the server side option selected, your URL should be http://thetfn.in/TFN/dev/dbui_beta/dbui/jsondata.php Upon selection of Next, Previous, Page 1, 2, 3, etc., the URL is appended by dataTables with ?draw=##& .... &start=## &length=## ... in either the URL for GET or header request body for POST. You are most interested in the start and length. Start is the starting record, length is the number of records selected for display. dataTable will determine the correct values to be passed. With each pagination event (Next, Previous), dataTables fires off the ajax event with the modified URL. It's up to your ajax page to grab the request variables (start, length, etc) and create the proper SQL.

you need to calculate automatic width calculation on fixed column during searching. Then there is alternative way other than timeout method. Editing source code helps me to achive that interactively resize function with nowrap. For each draw with fixed column & pagination, function _fnCloneLeft in source code is working. I also found that width & layout is calculated at init time & colvis hide/show using function this._fnColCalc(); //calculating colwidth this._fnGridLayout(this); //rearrange layout So I add the above two function at the end of _fnCloneLeft function in source code.This may provide dynamic resize of fixed column with pagination and searching.

Can you link to a test case showing the issue so I can debug it and understand what the issue is please. Where can I simulate 50000 rows of data JSFiddle, CodePen, http://live.datatables.net etc. Allan

Hi ThomD, Thanks for the interest in my problem The question is: How do I implement the multi filter select on a form generated from using Generator and Editor? The form is working as it should, but i want add the multi filter select functionality and im having trouble implementing it. This is a very new project and the DB is not loaded with a lot of data. I'm still trying to work up the functionality. Any advice or guidance is appreciated. All the best.