Adding a New View Entity

Posted by G.Venkata Phanindra on Aug 08, 2006; 6:38pm
URL: http://ofbiz.116.s1.nabble.com/Adding-a-New-View-Entity-tp141270.html

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]