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 :- +91-98267-54548
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.

Reply via email to