Fixes Issue 29802:Product selector in requisition line filter's by purchase
authorAtul Gaware <atul.gaware@openbravo.com>
Tue, 02 Jun 2015 13:25:52 +0530
changeset 26868 5ca1fcef07ed
parent 26867 6a8a7601ff96
child 26869 bb6958d2bb8d
Fixes Issue 29802:Product selector in requisition line filter's by purchase
products in price lists

If case of window is for Requisition, then Product Complete selector filters
product by purchase flag.
src-db/database/sourcedata/OBUISEL_SELECTOR.xml
--- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml	Wed Jun 03 11:08:45 2015 +0200
+++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml	Tue Jun 02 13:25:52 2015 +0530
@@ -303,7 +303,7 @@
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <AD_REFERENCE_ID><![CDATA[800011]]></AD_REFERENCE_ID>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <AD_TABLE_ID><![CDATA[FF8080812E381D1E012E3898C5DD0010]]></AD_TABLE_ID>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <WHERECLAUSE><![CDATA[e.active='Y']]></WHERECLAUSE>
-<!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <FILTER_EXPRESSION><![CDATA["( (\'"+OB.getWindowId()+"\' in (\'800051\', \'800052\', \'800096\') and e.product.production = true and e.stocked = false) or (\'"+OB.getWindowId()+"\' in (\'170\') and e.product.stocked = true) or \'"+OB.getWindowId()+"\' not in (\'800051\', \'800052\', \'800096\',\'170\'))"]]></FILTER_EXPRESSION>
+<!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <FILTER_EXPRESSION><![CDATA["( (\'"+OB.getWindowId()+"\' in (\'800051\', \'800052\', \'800096\') and e.product.production = true and e.stocked = false) or (\'"+OB.getWindowId()+"\' in (\'170\') and e.product.stocked = true) or (\'"+OB.getWindowId()+"\' in (\'800092\') and e.product.purchase = true) or \'"+OB.getWindowId()+"\' not in (\'800051\', \'800052\', \'800096\',\'170\',\'800092\'))"]]></FILTER_EXPRESSION>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <VALUEFIELD_ID><![CDATA[D5CD42F686A14DFA949052B99900D679]]></VALUEFIELD_ID>