Use the view-entity. Check the entity engine docs.
Si
On Aug 16, 2006, at 3:42 PM, Nick Olson wrote:
> I have been trying to modify the makeCategoryFeatureLists function in
> org.ofbiz.product.feature.ParametricSearch to only return the features
> that actually are used in the Category specified, but I'm not sure
> what
> the best way to go about it is.
>
> Is there a way to get the Entity delegator to return a list of all the
> features that are returned by this SQL query?
>
> select DISTINCT pf.product_feature_id
> FROM product_feature AS pf
> LEFT JOIN product_feature_appl AS pfa ON pfa.product_feature_id =
> pf.product_feature_id
> LEFT JOIN product_category_member AS pcm ON pcm.product_id =
> pfa.product_id
> WHERE pcm.product_category_id = 'Category'
>
> Thanks,
> -Nick
Locked
