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 via email to