Simple Querys with more then one left/right condition
1074
Views
1
Comments
Implemented
Aggregates & Queries
OutSystems 9
On Simple Querys it should possible to have more then one left condition.

Implement something like:
Left table t2 on (t1.field = t2.field and/or condition2)


2020-09-15 13-07-23
Kilian Hekhuis
mvp_badge
MVP

Agreed, I very often find myself having to write an advanced query just for these kind of cases. Alternatively allow NULL to be specified or implicitely test for it (so the second, non-joining condition can be added separately).