Inspect SQL for View Entity

[James McGill <ja...@ableengineering.com>]

How do you inspect the SQL for a View Entity?

-- 
James McGill
Phoenix AZ

Re: Inspect SQL for View Entity

[Scott Gray <sc...@hotwaxmedia.com>]

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

Re: Inspect SQL for View Entity

[James McGill <ja...@ableengineering.com>]

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

Re: Inspect SQL for View Entity

[Scott Gray <sc...@hotwaxmedia.com>]

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