It appears that view-link supports the notion of entity-condition where you
can do something like this:

<view-link entity-alias="A" rel-entity-alias="B" rel-optional="true">
    <key-map field-name="fk" />
    <entity-condition>
        <condition-expr entity-alias="A" field-name="fld" operator="equals"
value="FLD_TYPE" />
    </entity-condition>
</view-link>

I would imagine it yields something like this:

SELECT A.*, B.* FROM TABLE_A A LEFT OUTER JOIN TABLE_B B ON A.fk = B.fk AND
A.fld = 'FLD_TYPE";

Is this correct? If not, is there any way to achieve this? Thanks in
advance.

Reply via email to