[
https://issues.apache.org/jira/browse/EMPIREDB-402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rainer Döbele resolved EMPIREDB-402.
------------------------------------
Resolution: Fixed
> Allow Join definition using on(...) syntax
> ------------------------------------------
>
> Key: EMPIREDB-402
> URL: https://issues.apache.org/jira/browse/EMPIREDB-402
> Project: Empire-DB
> Issue Type: Improvement
> Components: Core
> Reporter: Rainer Döbele
> Assignee: Rainer Döbele
> Priority: Major
>
> The definition of joins so far requires the provision of a comma separated
> list of columns or compare expressions which is unintuitive especially for
> complex join expressions with multiple conditions.
> Hence, as an alternative, the sql "on" keyword should be offered to define a
> join.
> e.g. the current expression:
> {{.joinLeft(MODEL.ID, SALES.MODEL_ID, SALES.YEAR.is(2021))}}
> can alternatively be written as:
> {{.joinLeft(MODEL.ID.on(SALES.MODEL_ID).and(SALES.YEAR.is(2021)))}}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
