Re: Adding a New View Entity

Posted by cjhowe on Aug 08, 2006; 8:49pm
URL: http://ofbiz.116.s1.nabble.com/Adding-a-New-View-Entity-tp141270p141274.html

Actually, I don't believe this feature has made it
into the project yet (I would assume that
entitymodel.xsd would require updating and there are
no log entries related to this).  Adam Heath claimed
to had done something about a year ago but he either
has not contributed it or has not updated it to
reflect the current svn.

http://lists.ofbiz.org/pipermail/dev/2005-August/008988.html

--- BJ Freeman <[hidden email]> wrote:

> there are a few more complicated views in the same
> file.
>
>
> G.Venkata Phanindra sent the following on 8/8/2006
> 11:24 AM:
> > 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]
> >> >
> >>
> >
> >
> >
>