You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ofbiz.apache.org by Asit Patadia <As...@mindtree.com> on 2009/08/28 10:13:28 UTC

Creating DynamicViewEntity

Hi,

How to create the following query using DynamicViewEntity?

SELECT pcm.product_id, pp.price
FROM product_category_member pcm
INNER JOIN product_price pp ON (
pcm.product_id = pp.product_id AND price BETWEEN 15 AND 20)
WHERE pcm.product_category_id IN ('100', '101')

Thanx in advance for the help.

Regards,

Asit Patadia| Module Lead| MindTree Ltd. Maruthi Chambers, No. 17/9C, 17/4C, Rupena Agrahara, Hosur Road, Bangalore - 560 068, INDIA |
Voice +91 80 25738005 x 6088 / Fax +91 80 41100587 | email: asit_patadia@mindtree.com<ma...@mindtree.com> |www.mindtree.com<blocked::http://www.mindtree.com/> |


________________________________
http://www.mindtree.com/email/disclaimer.html