Re: Adding a New View Entity

Posted by BJ Freeman on Aug 08, 2006; 7:01pm
URL: http://ofbiz.116.s1.nabble.com/Adding-a-New-View-Entity-tp141270p141271.html

there is an good example in the
application/content/entitydef/entitymodel.xml
look for  ContentAndRole

G.Venkata Phanindra sent the following on 8/8/2006 10:38 AM:

> Hi,
>     I want to create a new View Entity with the Two table Content and
> ContentAssoc,My SQL Query is as below
>     How can i specify a value like DATA_RESOURCE_ID="TEMPLATE_TEXT_ONLY" in
> viewentity Defination.
>     select * from CONTENT,CONTENT_ASSOC where
> DATA_RESOURCE_ID="TEMPLATE_TEXT_ONLY"  AND
> CONTENT.CONTENT_ID=CONTENT_ASSOC.CONTENT_ID AND CONTENT_TYPE_ID="DOCUMENT"
> AND CONTENT_ASSOC.CONTENT_ID_TO!="feedbackforum"  ORDER BY
> CONTENT.CONTENT_ID desc;
>
> Thanks and regards
> G.Venkata Phanindra
> Mob:: [phone]
>