Search

Thanks, I will try it. I'm very impressed with your quick answer on all post!

Looks pretty good - just two small things: The ID isn't on the INPUT element, it's on the div wrapper. So your selector should be: $("#records_filter input").autocompleteArray( Make sure this runs after the DataTables initialisation. I've just tired that and with works nicely. Allan

Hi Bill, Super - good to hear you got it sorted! Useful information for anyone else using Zend Framework. Allan

Link to test case: https://live.datatables.net/heniqedu/1/edit?html,js,output 1. Select 'Add Condition' 2. Data: Position 3. Condition should default to 'Empty' 4. Note that the table does not update despite 3 records not having a Position set 5. There is no external way to even trigger the DataTable redraw; one must manually change the Condition to something else such as 'Not Empty' and then change it back to 'Empty' which defeats the purpose. Description of problem: It's possible to define a searchuilder.defaultCondition for a column such as '=', '<', '>', 'null', '!null', etc. When selecting a SearchBuilder condition that does not have an input field such as Empty (null) or Not Empty (!null), SearchBuilder does not trigger a rebuild. This is likely because while the default condition loads, there isn't an onChange event that is fired. Desired outcome: When a searchuilder.defaultCondition is set for a column and that default condition does not have a value input, then DataTables should automatically perform a rebuild with all of the current conditions.

HI , i am working on datatable custom searchbuider, its not working fine for a column which have dropdown in it . let say it has three options in dropdown, the custom searchbuilder is merging all options and showing as a single value. i want there, a dropdown , having all option , as in that column . see , i have three options 1-voted, 2-not voted ,3- requested but its merging all as single .

Hi, I stumbled over https://datatables.net/forums/discussion/68111/single-column-searchpane-on-header-mouseover and as it is from April 2021 mentioning an update in summer, I could not find any reference in the current documentation, if this has been implemented nor a sample configuration. As I would actually love to see the feature, has it be implemented OR is this still Work in Progress? Thanks a lot Rainer

Is is possible to customize the conditions in the searchBuilder for specific fields? For example, with some field I never want to offer "ends with" or "does not contain". Only some fields can handle "between". That kind of thing. It seems that you can customize the condition based on type https://datatables.net/extensions/searchbuilder/customConditions but I'm wondering if there's a way to do it based on the specific field. I'm using a custom server-side processing script, so I only want to present to the user operators and conditions that are handled by the server.

Link to test case: https://codepen.io/jchintall2019/pen/PoRpMZb Debugger code (debug.datatables.net): Error messages shown: {"fieldErrors":[],"error":"Table part of the field \"bankName\" was not found. In Editor instances that use a join, all fields must have the database table set explicitly.","data":[],"ipOpts":[],"cancelled":[]} Description of problem: Hello, I have been attempting to build a HTML with select option for the field "vendor". The database deals with banking transactions for home networks needing to have budget planning and tracking actual banking at home. This table will not be used as a published website. In order to avoid duplication with incorrect spelling of vendors I have created a table of vendors. However, trouble exists. I would appreciate reviewing of the attached html, php and js files. and let me know the resolution(s). Thanks John

Link to test case: Debugger code (debug.datatables.net): Error messages shown: Description of problem:

I need to use saved pages of website for future reference but my saved page has duplicate search,paging how can I avoid getting like that please help me with this