You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by BJ Freeman <bj...@free-man.net> on 2006/07/19 14:37:49 UTC
Re: How can I execute complex SQL -Queries like joins involving multiple
tables using OfBiz delegator?
http://incubator.apache.org/ofbiz/docs/entity.html
look down the page for entity view.
rams sent the following on 4/19/2004 10:06 AM:
> Hi,
> I want to use OfBiz delegator to execute complex queries.
> It seems OfBiz entity framework is having some limitations when it comes to
> executing complex data base queries?
> Is there any way I can execute a stored procedure using OfBiz delegator?
> Pls let me know how to execute joins ?
> Thanks and Regards
> Ram
>
>
>
> This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient or received it in error, please contact the sender by reply e-mail and destroy all copies of the original message. Please do not copy it for any purpose or disclose its contents.
>
> Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights Reserved
Re: How can I execute complex SQL -Queries like joins involving multiple
tables using OfBiz delegator?
Posted by BJ Freeman <bj...@free-man.net>.
as far as stored procedure, not directly.
however a trick I use is when data is updated in the sQL Database, a
trigger activated the Stored procedure, to create a new table.
i then create a entity for the new table and a view of the new table.
BJ Freeman sent the following on 7/19/2006 5:37 AM:
> http://incubator.apache.org/ofbiz/docs/entity.html
> look down the page for entity view.
>
>
> rams sent the following on 4/19/2004 10:06 AM:
>> Hi,
>> I want to use OfBiz delegator to execute complex queries.
>> It seems OfBiz entity framework is having some limitations when it
>> comes to executing complex data base queries?
>> Is there any way I can execute a stored procedure using OfBiz delegator?
>> Pls let me know how to execute joins ?
>> Thanks and Regards
>> Ram
>>
>>
>>
>> This e-mail and any files transmitted with it are for the sole use of
>> the intended recipient(s) and may contain confidential and privileged
>> information. If you are not the intended recipient or received it in
>> error, please contact the sender by reply e-mail and destroy all
>> copies of the original message. Please do not copy it for any purpose
>> or disclose its contents.
>>
>> Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights
>> Reserved
>