Login  Register

Inspect SQL for View Entity

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

Inspect SQL for View Entity

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

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

Re: Inspect SQL for View Entity

Scott Gray-2
2218 posts
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
| More
Print post
Permalink

Re: Inspect SQL for View Entity

James McGill-5
126 posts
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
| More
Print post
Permalink

Re: Inspect SQL for View Entity

Scott Gray-2
2218 posts
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