Search

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.

I don't see a way to change the color of the word Use CSS - .dataTables_filter { color: red } for example. I don't understand what you mean by controlling the placement and that it is shown in the center. Can you link to a test page showing the issue please. However, placement is controlled by CSS, so something in the CSS you are using must be aligning it center (although I can't say what without a test case). Allan

Tangerine gave you all of the information required to meet your requirements. With respect, we will not just provide sample code but can provide guidance. If you show us what you have tried, we might be able to offer some suggestions. Allan

Because I'm an idiot! :) We've all been there.... :-)

Thanks, Allan! That worked perfectly!