RSS Feed/News How to use the finder when joining tables?

Status
Not open for further replies.

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
24,664
Points
823

Reputation:

How should I use the XF finder with an sql query left joining 3 tables (I can join only 2 of them if it's simpler...)?

I'm working on adding API endpoints to an existing add-on (I've already succeeded in doing it for another add-on)
but have had a problem:

I have 3 tables. one has events and the other has event categories the 3rd links between the categories and the events.
I'm trying to combine them into a XF finder.
How should I do it?
This is the query that gets the results I need...

Read more

Continue reading...
 
Status
Not open for further replies.
Top