How to have Left Join with server side activation?
How to have Left Join with server side activation?
User123456
Posts: 57Questions: 15Answers: 0
I have this example query:
SELECT t.PublicationTitle, p.ano, p.competencia, c.razaoSocial, e.nome, p.path, p.arquivo, p.status, p.id_Publication FROM tbl_publication AS p LEFT JOIN tbl_ptitle AS t ON p.fk_titulo = t.id_PublicationTitle LEFT JOIN tbl_company AS c ON p.fk_empresa = c.id_Company LEFT JOIN tbl_employee AS e ON p.fk_empregado = e.id_Employee
And with simple PHP I did this query for retrieving information from database. Howerever with server side activation. how can I implement the same query?
If somebody can provide me with a link that have examples instead of doing is appreciated too. My configuration is the same as github repo.
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Hi,
This thread also discusses this issue. There are a couple of modifications of the SSP class floating around that does what you are looking for.
The Editor libraries support left joined server-side processing out of the box.
Allan
Hello @allan, do I need to download anything else or everything (methods) from here are included originally in github main repo?
You need to download the trial version of the Editor.
Yes, if you use the Editor libraries, you'd need to download the Editor PHP package.
Allan