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 |
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 > |
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:: 9849852989 > > > -- G.Venkata Phanindra Mob:: 9849852989 |
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:: 9849852989 >> > >> > > > |
Actually, I don't believe this feature has made it
into the project yet (I would assume that entitymodel.xsd would require updating and there are no log entries related to this). Adam Heath claimed to had done something about a year ago but he either has not contributed it or has not updated it to reflect the current svn. http://lists.ofbiz.org/pipermail/dev/2005-August/008988.html --- BJ Freeman <[hidden email]> wrote: > 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:: 9849852989 > >> > > >> > > > > > > > |
Free forum by Nabble | Edit this page |