Search

Yes it works, thanks a lot ! I'll have a look at the new Layout option, because my "dom" positions of buttons, pagination and search is a bit changed. But that's the fun ! Pierre.

upper items pagelength and search are no longer fixed.

table: '[{"table":"appointments","columns":[{"column":"","nickname":""}]},{"table":"staff","join":{"side":"LEFT","this":"ID","that":"Staff_ID"},"columns":[{"column":"Names","nickname":"Staff_names"},{"column":"Lastnames","nickname":"Staff_lastnames"}]},{"table":"patients","join":{"side":"LEFT","this":"ID","that":"Patient_ID"},"columns":[{"column":"Names","nickname":"Patient_names"},{"column":"Lastnames","nickname":"Patient_lastnames"}]}]', columns: '[{"title":"Staff","row":"Photo|Staff_names|Staff_lastnames","type":"fullname-photo","format":"title","table":"staff","other_id":"Staff_ID","parts":"photo|name|lastname","column":"Names","link_same":"edit","search":["Names","Lastnames"],"priority":1},{"title":"Paciente","row":"Patient_names|Patient_lastnames","type":"fullname","format":"medium","table":"patients","other_id":"Patient_ID","parts":"name|lastname","column":"Names","link_same":"edit","search":["Names","Lastnames"],"priority":1},{"title":"Modalidad","row":"Mode","type":"trait","format":"medium","table":"appointments","trait":"mode","priority":2},{"title":"Fecha","row":"Date","type":"date","format":"medium","table":"appointments","search":["Date"],"priority":2},{"title":"Hora","row":"Time","type":"time","format":"medium","table":"appointments","search":["Time"],"priority":2},{"title":"Creado","row":"Created","type":"Date","format":"medium","table":"appointments","priority":4},{"title":"Estado","row":"Status","type":"trait","format":"medium","table":"appointments","trait":"status","priority":3},{"title":"","type":"buttons","format":"buttons","table":"appointments","buttons":["view","edit","delete"],"priority":1}]', search: $('#s').val(), date_range_start: $('#date_range_start').val(), date_range_end:

little difficult since the search function isn't passed in

list and use the search field for the name

I am trying to do the same thing - add a button after the search field that is used as a refresh action. The example above does not produce any buttons for me. Thanks, Bruce

topStart: [ 'pageLength', 'buttons' ], topEnd: 'search' } That would bring it

some of them (e.g. search()) exist in both, but

this is a global search, it does an OR

and the like: https://datatables.net/forums/discussion/77996/more-flexibel-excel-export Search for "customize: function( xlsx