Hi Santosh , Create the view entity for all your tables and use delegator.findByCondition method.
With regards, S K Pradeep kumar, On Wed, Jan 13, 2010 at 6:05 PM, Santosh Malviya <santosh.of...@gmail.com>wrote: > Hi list, > > I have a sql query and I want to do the same with ofbiz entity model. > > The query is as follows: > select p.* from product_attribute pa1,product_attribute pa2, product p > where > pa1.attr_name = 'language' > and pa1.attr_value ='english' > and pa2.attr_name = 'genres' > and pa2.attr_value ='Romance' and > pa1.product_id = pa2.product_id > and pa1.product_id = p.product_id > > Please help if someone has any idea for doing so. Thanks in advance. > > > > > Thanks and Regards > Santosh Malviya >