Re: Adding a New View Entity

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

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