Hi,
Even after adding the condition to the view entity, it seems that the condition
is not being taken into consideration.
When we query the view, we get all the records irrespective of the condition
added in the view definition.
Here is the view definition:
<view-entity entity-name="pjMerchandizeCardsAndInventoryItem"
package-name="com.pj.wallet">
<member-entity entity-alias="invitem"
entity-name="InventoryItem"/>
<member-entity entity-alias="merchandize"
entity-name="pjMerchandizeCards" />
<alias-all entity-alias="invitem">
<exclude field="lastUpdatedStamp"/>
</alias-all>
<alias-all entity-alias="merchandize">
<exclude field="productId"/>
</alias-all>
<alias name="lastUpdatedStamp" entity-alias="merchandize"
field="lastUpdatedStamp"></alias>
<view-link entity-alias="invitem"
rel-entity-alias="merchandize">
<key-map field-name="productId"/>
</view-link>
<entity-condition>
<condition-expr entity-alias="merchandize"
field-name="displayOnWeb" operator="equals" value="Y"/>
</entity-condition>
</view-entity>
I also tried adding the condition in the <view-link> tag. Please note that only
one table has the column "displayOnWeb".
Any comments ?
Regards,
Prashant
________________________________
http://www.mindtree.com/email/disclaimer.html
