You can use <entity-condition> in <view-entity
see ExampleStatusItem
Jacques
From: "Info Olagos" <[email protected]>
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
