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
