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.