Does SearchBuilder support server-side processing?

Does SearchBuilder support server-side processing?

mcodermcoder 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:

Answers

  • colincolin Posts: 15,240Questions: 1Answers: 2,599
    Answer ✓

    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

  • mcodermcoder Posts: 19Questions: 9Answers: 0

    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.

  • allanallan Posts: 63,489Questions: 1Answers: 10,470 Site admin
    Answer ✓

    That is correct. If your query can be reproduced with a left join and a where condition, then that would work okay. But an explicit inner join would require the use of a VIEW at the moment.

    Allan

Sign In or Register to comment.