View entity in ofbiz does not represent database view; It is an entity created at runtime based on the configuration in <view-entity></view-entity>; Consider these as join queries if you will; Look for the view-entity configurations in entitymodel_view.xml in the relevant application
- Sakthi On 12/7/11, sreejithpallikkara <[email protected]> wrote: > Hi > I am a fresher to Ofbiz, I want to create view entity for the following SQL > Query, > > create view newView as (SELECT pr_id FROM span_purchase_request where pr_id > not in(SELECT distinct pr_id FROM span_request_for_quotation))\ > > > I have tried it in Ofbiz, but not able to get the propper output. > > Plaese help me on this... > > > Thanks & Regards > Sreejith P > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/view-entity-tp4169000p4169000.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > -- Sent from my mobile device
