You are better off using a static view-entity definition, DynamicViewEntities are for when you want to be able to alter the view definition on the fly. To create an outer join just use the rel-optional attribute on the view-link element.
Regards Scott HotWax Media http://www.hotwaxmedia.com On 3/05/2010, at 10:09 AM, deyan_of...@ittconsult.com wrote: > DynamicViewEntity does the joins. Search through the code for examples,i'll > be able to send you one tomorrow as it is night here :) > > > > ----- Reply message ----- > From: "Michal Cukierman" <duc...@gmail.com> > Date: Mon, May 3, 2010 00:32 > Subject: Question regarding Catalog management in Ofbiz > To: <user@ofbiz.apache.org> > > Thank you for your advices. I will save days of wark thanks to you. > > @TECDOC: > Is a great software, just what I wanted to have. The pricelist is good as > well. Exposed web serwise or standalone DVD catalogue is all I need. I will > investigate this solution in a days. What is very important for my at the > moment is USA market support (I have seen some supliers so far). The another > thing to investigate is the licence. Is it legal to use it in exposed web > applications? > > @Regarding top categories: > I have implemented SQL function for doing the magic, it's quite simple join > (as expected to be). The performance on my huge database is excelent (just > in time, after first run results are cached). > SELECT D.PRODUCT_CATEGORY_ID FROM PRODUCT_CATEGORY_ROLLUP P > RIGHT JOIN > PRODUCT_CATEGORY D ON P.PRODUCT_CATEGORY_ID and > D.PRODUCT_CATEGORY_ID > WHERE PARENT_PRODUCT_CATEGORY_ID is null; > > I am now learning the OFbiz database API to implement the solution above. I > have not found an API to create RIGHT/LEFT joins so far. > EntityListIterator is a good solution but implementation of SQL statement > above would be even better in my opinion. Anyway in case of problem I have > a backup in your idea. > > Regarads and many thanks, > MichaĆ > > > > > 2010/5/2 Deyan Tsvetanov <deyan_of...@ittconsult.com> > >> TECDOC
smime.p7s
Description: S/MIME cryptographic signature