Condition left join hack

Condition left join hack

belubelu Posts: 38Questions: 14Answers: 0

I am trying to perform a left join with conditions, using this hack:
https://datatables.net/forums/discussion/30273/leftouterjoin-complex

unfortunately it does not work :-(

Could you be so kind an help me? Thx in advance!

$editor->leftJoin( 'clients_contact_persons as contact', 'clients.client_id', '=', 'contact.client_id AND contact.archived != 1');

This question has an accepted answers - jump to answer

Answers

  • belubelu Posts: 38Questions: 14Answers: 0

    I have loaded up the Debug Information - the code is: emovof

  • colincolin Posts: 15,118Questions: 1Answers: 2,583

    Can you also post your server-side script too please, the debug stuff only shows the client-side information.

    Colin

  • allanallan Posts: 61,452Questions: 1Answers: 10,055 Site admin
    Answer ✓

    It could be that I've made a chance in the libraries somewhere that is causing that hack to no longer work.

    What you might need to do is use a VIEW to get the data if you need a complex join.

    Allan

This discussion has been closed.