Define view-entity with SQL statement.

[Chatree Srichart]

Is it possible if I need to define view-entity with SQL statement because I
need to use NESTED SELECT statement?

[hans_bakker]

View entities are not created in the database. They are used for the sql
queries generated by OFBiz using the OFBiz view definition.

Dynamic views could be an answer here. An example you can find in the
ProductSearch.java file and search for 'DynamicViewEntity'

Regards,
Hans

--
Antwebsystems.com: Quality OFBiz services for competitive rates

On Tue, 2010-03-09 at 09:43 +0700, Chatree Srichart wrote:
> Is it possible if I need to define view-entity with SQL statement because I
> need to use NESTED SELECT statement?

[hans_bakker]

Please do not post in both mailing lists. I have answered your question
in the user mailing list.

On Tue, 2010-03-09 at 09:43 +0700, Chatree Srichart wrote:
> Is it possible if I need to define view-entity with SQL statement because I
> need to use NESTED SELECT statement?
--
Antwebsystems.com: Quality OFBiz services for competitive rates

[Scott Gray-2]

It should be possible to construct the same view with a static view entity definition as it is with a DynamicViewEntity, the only difference between the two is the dynamic nature of the latter i.e. you can construct the view at runtime to only query the data you actually need.

Regards
Scott

On 8/03/2010, at 7:56 PM, Hans Bakker wrote:

> View entities are not created in the database. They are used for the sql
> queries generated by OFBiz using the OFBiz view definition.
>
> Dynamic views could be an answer here. An example you can find in the
> ProductSearch.java file and search for 'DynamicViewEntity'
>
> Regards,
> Hans
>
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>
> On Tue, 2010-03-09 at 09:43 +0700, Chatree Srichart wrote:
>> Is it possible if I need to define view-entity with SQL statement because I
>> need to use NESTED SELECT statement?
>
>