Search

Thanks lads!

If you don't ever want to show those rows then the best option is to remove them from the props.props array before initializing Datatables. If you want them in the Datatables but not displayed you can use column().search.fixed(). Provide the user the ability to set/reset a flag to display blank names and check the flag in the column().search.fixed() function to determine if blank names should be shown. To answer your question you would use clear() then rows.add() to clear the original data and update the table with the filteredData. This would be the less efficient than just removing the unwanted data before initializing Datatables. Kevin

Thanks! I renamed the title property and it's working as expected now.

I was able to get this to work. The code is looking for keypress event to work with live searching. I added this line after setting the value and it worked: this.dispatchEvent(new KeyboardEvent('keypress'));

No - it looks like there is an error there. Thanks for letting me know about that. Allan

Edit: example for multiple classes columns: [ ':not(.act,.act2):visible' ]

Maybe this will help someone... in the initComplete, and anytime the table is redrawn jQuery('#yourTableTable_filter').find("input").attr('size',6);

I would suggest you use SearchBuilder if you want to add complex filtering. Allan

it took me a long time, but somehow I managed it, it works as it should, thank you.

When you use draw() with server side processing an ajax request is sent to the server to get the rows to be displayed on the page. The server will respond with the rows to display and other information for Datatables to understand the number of records and display the proper paging buttons. See the Server Side Processing protocol docs for details. The additional parameters will be sent to the server script. You will need to update your Django script to retrieve the parameters to use them has part of the data query for the date range. The Django script will return the rows to display and additional information as described in the above link. Datatables will display the rows. There is nothing else to do on the client side. Kevin