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 <[EMAIL PROTECTED]> 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
>
