View-Entity

[Heidi Dehaes - Olagos]

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

[Jacques Le Roux]

You can use <entity-condition> in <view-entity
see ExampleStatusItem

Jacques

From: "Info Olagos" <[hidden email]>

> 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
>