ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Le Roux" <jacques.le.r...@les7arts.com>
Subject Re: View-Entity
Date Fri, 08 Apr 2011 04:12:28 GMT
You can use <entity-condition> in <view-entity
see ExampleStatusItem 

Jacques

From: "Info Olagos" <info.olagos@gmail.com>
> Hello,
> 
> I created a view , partially.
> I used these commands for creating a view definition in entitymodel.xml for
> a new specific component:
> - view-entity
> - alias
> - complex-alias
> - view-link
> My view needs to have a condition in it with fields equal to a value.
> 
> How can i add these conditions in the view definition.
> 
> For example as here under in the WHERE clause:
> 
> SELECT
> 
> p.product_id,
> pr.internal_name,
> pr.brand_name,
> pr.description,
> pcm.product_Category_Id,
> round((p.price + (p.price * tax_percentage / 100)),2) price,
> pr.sales_discontinuation_date,
> round((sum(i.available_to_promise_total)),0) aantal,
> i.facility_id
> 
> 
> 
> FROM
> 
> product pr,
> product_price p,
> Product_Category_Member pcm,
> tax_authority_rate_product tarp,
> inventory_item i
> 
> where
> 
> p.product_id = i.product_id and
> sales_discontinuation_date is null and
> pr.product_id = p.product_id and
> p.product_id = pcm.product_id and
> pcm.product_category_id = tarp.product_category_id and
> tarp.product_store_id = '9000' and
> tax_Auth_Geo_Id = 'BEL' and
> product_price_type_id = 'DEFAULT_PRICE'
> 
> group by i.product_id, pr.internal_name, pr.brand_name, pr.description,
> pcm.product_Category_Id,round((p.price + (p.price * tax_percentage /
> 100)),2), pr.sales_discontinuation_date, i.facility_id
> 
> order by brand_name, internal_name;
> Regards,
> Heidi
> Olagos bvba
> http://www.olagos.eu <http://www.olagos.eu/>
> http://www.olagos.com
> http://www.olagos.be
> http://www.olagos.nl
> Olagos team
> Heesterbos 5
> 2570 Duffel
> Belgium
>


Mime
View raw message