Adding a New View Entity

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Adding a New View Entity

G.Venkata Phanindra
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:: 9849852989
Reply | Threaded
Open this post in threaded view
|

Re: Adding a New View Entity

BJ Freeman
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:: 9849852989
>
Reply | Threaded
Open this post in threaded view
|

Re: Adding a New View Entity

G.Venkata Phanindra
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:: 9849852989
> >
>



--
G.Venkata Phanindra
Mob:: 9849852989
Reply | Threaded
Open this post in threaded view
|

Re: Adding a New View Entity

BJ Freeman
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:: 9849852989
>> >
>>
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Adding a New View Entity

cjhowe
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:: 9849852989
> >> >
> >>
> >
> >
> >
>