Search

I have done it this way, which changes the position of the controls as intended but then I lose the paging at the bottom of the report. How do I make sure my pages stays were it is (bottom) when I implement this code?

case, the multi-select option searches based on "contains" instead

Hi, Yes. That's correct, forgot to comment on this. Thanks. Regards.

Hi @FrazeColder , Not sure if you're aware, but there's the RowGroup extension that'll do pretty much what you want - here's an one of the examples of it. I modified your example here - the code is repetitive so could be refactored, but I think it does what you're after, Cheers, Colin

My suggestion would be to use client side processing unless you have thousands of records that cause performance issues. deferRender can help with page rendering speed but if the full set of data is slow with the ajax response then you will need Server Side Processing. This page discusses the parameters sent to the server and the expected responses when using Server Side Processing. Your Django scripts will need to handle searching and sorting. Kevin

Thanks @colin, I've figure it out, thanks.

The documentation I linked to describes the API that DataTables uses for server-side processing. Basically you have to have the server expect that set of data, and then respond with the JSON parameters that DataTables expects. If it isn't possible to do that with your API you would need a proxy somewhere to translate between them. Allan

Not really a DataTables problem. Your browser inspector will show you this border: 1px solid #ddd; in bootstrap.min.css. Unticking the box makes the problem go away; but I don't know what other effects this may have.

thanks @colin :#

Thanks Allan for responding.. I already found away and yeap thus includes the comments you've suggested too.. Cheers, ZyrowCool