Inspect SQL for View Entity

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Inspect SQL for View Entity

James McGill-5
How do you inspect the SQL for a View Entity?

--
James McGill
Phoenix AZ
Reply | Threaded
Open this post in threaded view
|

Re: Inspect SQL for View Entity

Scott Gray-2
You could temporarily change your debugging level to verbose and the  
SQLProcessor will log the statements.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 8/10/2009, at 5:36 PM, James McGill wrote:

> How do you inspect the SQL for a View Entity?
>
> --
> James McGill
> Phoenix AZ


smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Inspect SQL for View Entity

James McGill-5
Thanks (framework/base/config/debug.properties).

One more question:  I'm trying to understand if there's another way to do
joins, besides using view-entity.
I'm finding view-entity to be tricky, even though I know what I want in
terms of a simple join.

--
James McGill
Phoenix AZ
Reply | Threaded
Open this post in threaded view
|

Re: Inspect SQL for View Entity

Scott Gray-2
You should also be able to adjust them at runtime via webtools.

View-entities are mostly it aside from dynamic view entities (harder)  
but they only really make sense when the query is dynamic.  There's  
also directly using the SQLProcessor but that should be an absolute  
last resort.  The view-entities aren't that bad once you get used to  
them and there are tons of examples in OFBiz.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 8/10/2009, at 6:35 PM, James McGill wrote:

> Thanks (framework/base/config/debug.properties).
>
> One more question:  I'm trying to understand if there's another way  
> to do
> joins, besides using view-entity.
> I'm finding view-entity to be tricky, even though I know what I want  
> in
> terms of a simple join.
>
> --
> James McGill
> Phoenix AZ


smime.p7s (3K) Download Attachment