I'm trying to convert this into a subpath

SELECT * FROM Plans INNER JOIN PlanOptions ON Plans.PlanID = PlanOptions.PlanID INNER JOIN Funds ON PlanOptions.FundID = Funds.FundID INNER JOIN CorpFunds ON Funds.FundID = CorpFunds.FundID AND Plans.CorpID = CorpFunds.CorpID WHERE Plans.PlanID = n

I'm getting stuck on this part:

"...INNER JOIN CorpFunds ON Funds.FundID = CorpFunds.FundID AND Plans.CorpID = CorpFunds.CorpID..."

I've scanned the docs and looked into a multitude of posts but haven't found anything.

Thanks.

Hi,

when adding relations to your bucket (I guess that you went to that point), assign a Custom Filter to that specific relation (with your two predicates) and toggle the "CustomFilterReplacesOnClause"

Cheers

Thanks. Is there anyway to do it with subpaths or I'm I missing the point on that?

-Luke

Jessynoo wrote:

Hi,

when adding relations to your bucket (I guess that you went to that point), assign a Custom Filter to that specific relation (with your two predicates) and toggle the "CustomFilterReplacesOnClause"

Cheers

Ok. I think I got it. Thanks again. Now onto adding a sort. Yes... I'm a newbie at this.

-Luke

LukeO wrote:

Thanks. Is there anyway to do it with subpaths or I'm I missing the point on that?

-Luke

Jessynoo wrote:

Hi,

when adding relations to your bucket (I guess that you went to that point), assign a Custom Filter to that specific relation (with your two predicates) and toggle the "CustomFilterReplacesOnClause"

Cheers

Subpath is something quite different, it relates to the way you want to fetch related entities together in one go (thanks to prefetch paths), not the way you use relations to build your main filter.