Does SearchBuilder support server-side processing?
Does SearchBuilder support server-side processing?
mcoder
Posts: 19Questions: 9Answers: 0
Link to test case: live.datatables.net/dufanoko/1/edit
Description of problem:
I want to pass the values from the SearchBuilder to the database query. I have found old posts that said that it was not implemented, but those posts were from about 2 years ago. Is this still the case?
This question has accepted answers - jump to:
This discussion has been closed.
Answers
Yep, that's supported now - see example here. You'll need to use the Editor server-side files, but you can do that without an Editor license. This blog post goes into some detail on how to do that,
Colin
Thank you for this. I had also seen posts that Editor only supports LEFT joins. Is this still the case? As I need to use INNER joins in my queries.
That is correct. If your query can be reproduced with a left join and a
wherecondition, then that would work okay. But an explicit inner join would require the use of a VIEW at the moment.Allan