View Link Entity Conditions

[Ancheta, Fred]

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.

[Deepak Dixit-2]

Hello Ancheta,

You can achieve this using entity-condition tag, that is available at parallel of view-link tag.

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

I have faced the similar problem earlier, but I was too busy to dig into this.
Code support is available for entity-condition under view-link, but it get entity-condition null while fetching the childNodes of view link.
Once the above problem will fix you will able to get desired result by your expression as well.

Thanks & Regards
--
Deepak Dixit
HotWax Media Pvt. Ltd.
www.hotwaxmedia.com
Contact :- [phone]
Skype  :- deepakdixit

On Dec 21, 2011, at 1:35 AM, Ancheta, Fred wrote:

> 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.