External Filters?
External Filters?
1kgcoffee
Posts: 6Questions: 3Answers: 0
This may be outside the scope of what is possible with datatables, but figured I'd ask.
I want to raw dump all of the data into a table, then have a series of filters, that sit as a form outside the table itself and feed into the serverside script the same way column ordering does.
For example, instead of just sorting by asc and dsc depending on order direction, I'd like to have a form element outside the table that selects >,<,= selected values. There could be multiple such elements adding a bit of sql to the serverside script.
Bit of an amateur here and not sure how to go forward with this.
Answers
It would be worth looking at SearchBuilder - this is an example here with server-side processing on the back-end. That allows those comparative searches you listed, so might be a quick strategy to get the majority of the functionality you're after.
Colin
This is exactly what I'm looking for thankyou!