you can create view into ofbiz using <view-entity></view-entity>. you can write it into entity-model.xml file of your application. view will be get generated at runtime, there is no existance of it into database. in ofbiz view you can create using inner query, so, therefore change you query using only joins, that will work out for you.
If you are not able create, let me know the structure of table , i will give the view need to be created. -- View this message in context: http://ofbiz.135035.n4.nabble.com/view-entity-tp4169000p4194206.html Sent from the OFBiz - User mailing list archive at Nabble.com.
