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