view-entity rel-field or-condition joins supported?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

view-entity rel-field or-condition joins supported?

Christian Carlow-OFBizzer
Anyone know if these types of view-entity joins are supported?  Excluding key-maps produces and error but when including them produces an AND join.  Need an OR join.

        <view-link entity-alias="WE" rel-entity-alias="WEA" rel-optional="true">
            <key-map field-name="workEffortId" rel-field-name="workEffortIdFrom"/>
            <key-map field-name="workEffortId" rel-field-name="workEffortIdTo"/>
            <entity-condition>
                    <condition-list combine="or">
                        <condition-expr entity-alias="WE" rel-entity-alias="WEA" field-name="workEffortId" operator="equals" rel-field-name="workEffortIdFrom" />
                        <condition-expr entity-alias="WE" rel-entity-alias="WEA" field-name="workEffortId" operator="equals" rel-field-name="workEffortIdTo" />
                    </condition-list>
            </entity-condition>
        </view-link>
Reply | Threaded
Open this post in threaded view
|

Re: view-entity rel-field or-condition joins supported?

Christian Carlow-OFBizzer
Figured out a workaround.  Got rid of entity-condition completely and joined WEA twice, one with a key-map for workEffortIdFrom and the other with workEffortIdTo.

Briefly looking at the code, seems like condition-list inside a view-link creates a WHERE clause rather than modifies the JOIN.