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
