Is this a way to get the db view or the query behind ModelViewEntity

[Justin Robinson]

*Thanks to those who helped me with my last question*

I've had a look at the code of ModelViewEntity briefly, that together with
the following abstract:

"A few things about view-entities View-entities are very powerful and allow
you to create join-like queries, even when your database doesn't support
joins." - ofbiz entity cookbook.

Seems to suggest that view entity xml model info is used to piece the view
entity together.

Still I need to write a script to create views on a mysql database that
correspond to all ofbiz 10.04 view entities on a very large system.

Please can I have some advice about how best to go about such a task.

*Looking at the content of this mailing list and the warning to post to be
right list, I wonder if I shouldn't be asking this on users - still I'm not
a user - pls let me know if I should use the other list.*

[Jacques Le Roux]

Le 19/01/2015 23:22, Justin Robinson a écrit :

> *Thanks to those who helped me with my last question*
>
> I've had a look at the code of ModelViewEntity briefly, that together with
> the following abstract:
>
> "A few things about view-entities View-entities are very powerful and allow
> you to create join-like queries, even when your database doesn't support
> joins." - ofbiz entity cookbook.
>
> Seems to suggest that view entity xml model info is used to piece the view
> entity together.
>
> Still I need to write a script to create views on a mysql database that
> correspond to all ofbiz 10.04 view entities on a very large system.
>
> Please can I have some advice about how best to go about such a task.
>
> *Looking at the content of this mailing list and the warning to post to be
> right list, I wonder if I shouldn't be asking this on users - still I'm not
> a user - pls let me know if I should use the other list.*

Yes you should the user list, you are an OFBiz user :)
This is clearly(?) explained at http://ofbiz.apache.org/mailing-lists.html

Jacques