ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scott Gray <scott.g...@hotwaxmedia.com>
Subject Re: Question regarding Catalog management in Ofbiz
Date Sun, 02 May 2010 22:36:04 GMT
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_ofbiz@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" <duce74@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_ofbiz@ittconsult.com>
> 
>> TECDOC


Mime
View raw message