Re: Adding a New View Entity

Posted by G.Venkata Phanindra on Aug 08, 2006; 7:24pm
URL: http://ofbiz.116.s1.nabble.com/Adding-a-New-View-Entity-tp141270p141272.html

Hi,
       Thanks for ur reply.........but i want to create a view with field
name=value like
      DATA_RESOURCE_ID="TEMPLATE_TEXT_ONLY".  in xml.




On 8/8/06, BJ Freeman <[hidden email]> wrote:

>
> 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]
> >
>

--
G.Venkata Phanindra
Mob:: [phone]