Search

but if aData = null or undefined aData.length is break it can't continue Correct. That's why I said it needs to be an empty array and not either null or undefined. If there is no data, then DataTables currently expects that to be explicitly the case by there being an empty array. Allan

there is a large wasted area on both sides Try adding width="100%" to your table in HTML. For example: <table id="example" class="display" width="100%"></table> Kevin

Hello, I have just see you have now working! Good work :smile:

How can edit the post ? I wish to edit with some sample code.

Yeah that did the trick, Thanks

The search is bein send to the server, it is not workin on the client side. The problem is that for the rows that the data was added like this is not working: mRender": function ( data, type, row ) { return row.ID + '<br><span class="ft-red">' + row.NAME + "</span>"; }, For the columns that the data was added like this is working fine: mRender": "ID"

So here is the code that solved my problem. Using id in the URL string did exactly what I needed. remove: { type: 'DELETE', dataSrc: "data.vehicles", processData: false, //add _id_ to the end of the url url: apiPathProtected + "vehicle/_id_", beforeSend: function (request) { request.setRequestHeader("X-Access-Token", user.token); request.setRequestHeader("Content-Type", "application/json"); },

I fixed this by removing the default event handler and put on my own. http://live.datatables.net/cixegedi/1/edit $(document).ready( function () { $(document).on("preInit.dt", function(){ var fil = $("#example_filter input"); // remove default event hanlder fil.off(); // add one for key down fil.on("keydown", function(evtObj){ // whatch for the return key var keycode = (event.keyCode ? event.keyCode : event.which); if(keycode == 13){ $('#example').DataTable().search(this.value).draw(); } }); // watching for the return key is not obviouse for all my users so // I just used a regular button below for this but on my own work // I used a maginfying glass icon button. var btn = $("<button type='button'>Go</button>"); fil.after(btn); btn.on("click", function(){ $('#example').DataTable().search(fil.val()).draw(); }); }); var table = $('#example').DataTable( {} ); } );

Hi Bindrid, thanks for the enlightening example last posted, these two have been useful in me moving forward. I now have a class "editable" that I can selectively apply to the DataTable() what surprises me is that it seems to be such a complicated task to process the logic. Is there really no way, having selected cells that are editable and having added the class "editable" to the table that we can flag up to DataTables() which fields can be input? handling each cell event in such detail each and every cell thats entered seems a huge amount of coding for such a simple requirement. And adding an input ... why is that? as something that is so JQuery biased I am surprised that I can't just do something like $("#mytable").DataTables().editableClass("editable"); job done ! Can I apply any logic to the cells() collection to skip processing if the class is not set to editable? Something in a single line of code perhaps? jON

hey , can you update the jsfiddle , i got the same problem , thanks for your help