Creating DynamicViewEntity

Posted by asitpatadia on Aug 28, 2009; 8:13am
URL: http://ofbiz.116.s1.nabble.com/Creating-DynamicViewEntity-tp163814.html

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 [phone] x 6088 / Fax [phone] | email: [hidden email]<mailto:[hidden email]> |www.mindtree.com<blocked::http://www.mindtree.com/> |


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