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?