Search

I am, yes. Thanks for the rapid response!

This example is demonstrating that for input elements, you could do something similar for select, Colin

Yep, you can remove options - see this manual page. In this example, it's removing the "=" option for numbers - you can confirm that by looking at the "Age" column, Colin

@kthorngren @sandy Also, for my current setup: http://live.datatables.net/jahazase/19/edit There are duplicate filters or searchpanes in only safari. For example, there is a custom "New or Maintenance" filter and there is an auto generated "New or Maintenance" filter. This only occurs in Safari. I only want the custom panes or filters to show.

Hi @pgerundt , SearchPanes uses the stateSaveParams event to add the SearchPanes data to the state object. This event listener is set after the one set in the datatables initialisation. I'd suggest that you set your listener after SearchPanes has initialised. You could set a listener inside the datatables initComplete option - at this point SearchPanes will have already set it's listener and yours should run after the options have been added. Thanks, Sandy

You can use a closure function for the options as well. That supports executing your own SQL-statement if you like: https://editor.datatables.net/manual/php/joins#Closure---custom-function Something like this could work (not tested). It uses the built-in Editor db-handler which is typically called $db. If you called it differently you would need to change that in the code below. Field::inst('returns.member','member') ->searchPaneOptions( function() use ($db) { $stmt = ('SELECT DISTINCT id AS `value`, member AS `label` FROM returns WHERE member = :ab_foods LIMIT 1'); $result = $db ->raw() ->bind(':ab_foods','ab foods') ->exec($stmt);` return $result->fetchAll(PDO::FETCH_ASSOC); }),

Hi @fiji885 , Just to let you know that we have implemented this and it will be available in the next SearchBuilder release which we hope will be in the next few weeks. Until then you can access the fix from the nightly builds. Until then, you can see it in action at this example. Thanks, Sandy

Hi @ECEGROUPE , Take a look a this example. There are a few changes required to the function I linked above as it is in typescript. The main addition to get this working is /*****************************************************************************************/ addOption("AlwaysPresent", "AlwaysPresent") /*****************************************************************************************/ Hope this helps, Sandy

That is the XHR response. You will want to look at the request tab and the parameters sent in the request. Also note that draw: 0 is incorrect. This is a sequence number and Datatables starts with 1. 0 will not be sent nor expected by Datatables. See the server Side Processing docs for more details. This might be the issue you are seeing. Kevin

Ok. Thanks Allan.