You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Chandresh Turakhia <ch...@bhartitelesoft.com> on 2006/11/30 08:02:58 UTC
Views Ofbiz.
Hi ,
Should view-entity create views in the database.
I do not see any views in the database ( oracle ).
Chand
Re: Views Ofbiz.
Posted by Chandresh Turakhia <ch...@bhartitelesoft.com>.
Dear all,
Quikie question : Where can more info on this ?
Keen on pointers for "Oracle Theta" . More interested in generating SQL for
Oracle Specific stuff " For Update of " , "Connect by".
Went thru code , may be I am missing something : I could not find switch
based on database type. Where the does the generator check for the database
type
Chand
"To represent an outer join you can specify in a
>> view-link element
>> that the related entity is optional using the
>> rel-optional attribute,
>> which can be either "true" or "false", and of course
>> defaults to
>> "false". The Entity Engine will generate ANSI,
>> Oracle Theta, or MS
>> SQL Server Theta style join code depending on the
>> setting in the
>> entityengine.xml file. See the Entity Engine Configuration Guide for
>> more information."
----- Original Message -----
From: "Chris Howe" <cj...@yahoo.com>
To: <of...@incubator.apache.org>
Sent: Thursday, November 30, 2006 10:28 AM
Subject: Re: Views Ofbiz.
> Yes, but the question was...
> Should view-entity create views in the database?
>
>
>
> --- David E Jones <jo...@undersunconsulting.com>
> wrote:
>
>>
>> On Nov 30, 2006, at 8:03 AM, Chris Howe wrote:
>>
>> > David,
>> >
>> > No matter how many times you link to that
>> excellent
>> > write-up, it does not answer that question.
>>
>> Joins are mentioned various times in that write-up.
>> If you read the
>> whole section I'm not sure how you could miss it.
>> Here is one example
>> copied from that section of that document:
>>
>> "To represent an outer join you can specify in a
>> view-link element
>> that the related entity is optional using the
>> rel-optional attribute,
>> which can be either "true" or "false", and of course
>> defaults to
>> "false". The Entity Engine will generate ANSI,
>> Oracle Theta, or MS
>> SQL Server Theta style join code depending on the
>> setting in the
>> entityengine.xml file. See the Entity Engine
>> Configuration Guide for
>> more information."
>>
>> -David
>>
>>
>
>
Re: Views Ofbiz.
Posted by Chris Howe <cj...@yahoo.com>.
Yes, but the question was...
Should view-entity create views in the database?
--- David E Jones <jo...@undersunconsulting.com>
wrote:
>
> On Nov 30, 2006, at 8:03 AM, Chris Howe wrote:
>
> > David,
> >
> > No matter how many times you link to that
> excellent
> > write-up, it does not answer that question.
>
> Joins are mentioned various times in that write-up.
> If you read the
> whole section I'm not sure how you could miss it.
> Here is one example
> copied from that section of that document:
>
> "To represent an outer join you can specify in a
> view-link element
> that the related entity is optional using the
> rel-optional attribute,
> which can be either "true" or "false", and of course
> defaults to
> "false". The Entity Engine will generate ANSI,
> Oracle Theta, or MS
> SQL Server Theta style join code depending on the
> setting in the
> entityengine.xml file. See the Entity Engine
> Configuration Guide for
> more information."
>
> -David
>
>
Re: Views Ofbiz.
Posted by David E Jones <jo...@undersunconsulting.com>.
On Nov 30, 2006, at 8:03 AM, Chris Howe wrote:
> David,
>
> No matter how many times you link to that excellent
> write-up, it does not answer that question.
Joins are mentioned various times in that write-up. If you read the
whole section I'm not sure how you could miss it. Here is one example
copied from that section of that document:
"To represent an outer join you can specify in a view-link element
that the related entity is optional using the rel-optional attribute,
which can be either "true" or "false", and of course defaults to
"false". The Entity Engine will generate ANSI, Oracle Theta, or MS
SQL Server Theta style join code depending on the setting in the
entityengine.xml file. See the Entity Engine Configuration Guide for
more information."
-David
Re: Views Ofbiz.
Posted by Chris Howe <cj...@yahoo.com>.
Chand,
What are you trying to accomplish, perhaps we can
describe a work around for you.
David,
No matter how many times you link to that excellent
write-up, it does not answer that question.
--- David E Jones <jo...@undersunconsulting.com>
wrote:
>
>
http://incubator.apache.org/ofbiz/docs/entity.html#View_Entity_Modeling
>
>
> On Nov 30, 2006, at 12:29 AM, Jacques Le Roux wrote:
>
> > No it don't, it's on the fly
> >
> > Jacques
> >
> > From: "Chandresh Turakhia"
> <ch...@bhartitelesoft.com>
> >> Hi ,
> >>
> >> Should view-entity create views in the database.
> >>
> >> I do not see any views in the database ( oracle
> ).
> >>
> >> Chand
>
>
Re: Views Ofbiz.
Posted by David E Jones <jo...@undersunconsulting.com>.
http://incubator.apache.org/ofbiz/docs/entity.html#View_Entity_Modeling
On Nov 30, 2006, at 12:29 AM, Jacques Le Roux wrote:
> No it don't, it's on the fly
>
> Jacques
>
> From: "Chandresh Turakhia" <ch...@bhartitelesoft.com>
>> Hi ,
>>
>> Should view-entity create views in the database.
>>
>> I do not see any views in the database ( oracle ).
>>
>> Chand
Re: Views Ofbiz.
Posted by Ashish Vijaywargiya <to...@yahoo.com>.
Chandresh,
If you want to see the view-entities you can take a
look into Webtools --> Entity Data Maintenance page.
Regards
Ashish Vijaywargiya
--- Jacques Le Roux <ja...@les7arts.com>
wrote:
> No it don't, it's on the fly
>
> Jacques
>
> From: "Chandresh Turakhia"
> <ch...@bhartitelesoft.com>
> > Hi ,
> >
> > Should view-entity create views in the database.
> >
> > I do not see any views in the database ( oracle ).
> >
> > Chand
>
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com
Re: Views Ofbiz.
Posted by Jacques Le Roux <ja...@les7arts.com>.
No it don't, it's on the fly
Jacques
From: "Chandresh Turakhia" <ch...@bhartitelesoft.com>
> Hi ,
>
> Should view-entity create views in the database.
>
> I do not see any views in the database ( oracle ).
>
> Chand