Condition left join hack

belu

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');

belu

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

colin

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

Colin

allan

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