details: https://code.openbravo.com/erp/devel/pi/rev/bd09a9d5ffa8
changeset: 32265:bd09a9d5ffa8
user: Armaignac <collazoandy4 <at> gmail.com>
date: Wed May 31 23:40:24 2017 -0400
summary: Fixes issue 36008: Not production products in work efforts
In the Work Efforts and Production Run windows the product selector wasn't
filtering by production products.
Now a filter expression of Product Complete selector include the Work Effort
and Production Run windows for filtering by production products.
diffstat:
src-db/database/sourcedata/OBUISEL_SELECTOR.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r 864ef8d7eee8 -r bd09a9d5ffa8
src-db/database/sourcedata/OBUISEL_SELECTOR.xml
--- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Mon Jun 05 13:38:50
2017 +0200
+++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Wed May 31 23:40:24
2017 -0400
@@ -351,7 +351,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()+"\' in
(\'800092\') and e.product.purchase = true) or (\'"+OB.getWindowId()+"\' in
(\'169\') and (e.warehouse.id is null or e.warehouse.id in (select
ow.warehouse.id from OrganizationWarehouse ow where ow.organization.id = \'"+
OB.getParameters().get("inpadOrgId")+"\'))) or \'"+OB.getWindowId()+"\' not in
(\'800051\', \'800052\',
\'800096\',\'170\',\'800092\',\'169\'))"]]></FILTER_EXPRESSION>
+<!--4C8BC3E8E56441F4B8C98C684A0C9212--> <FILTER_EXPRESSION><![CDATA["(
(\'"+OB.getWindowId()+"\' in (\'800051\', \'800052\', \'800053\',
\'FF808181323E504701323E57E08D0017\', \'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()+"\' in (\'169\') and
(e.warehouse.id is null or e.warehouse.id in (select ow.warehouse.id from
OrganizationWarehouse ow where ow.organization.id = \'"+
OB.getParameters().get("inpadOrgId")+"\'))) or \'"+OB.getWindowId()+"\' not in
(\'800051\', \'800052\', \'800053\', \'FF808181323E504701323E57E08D0017\',
\'800096\',\'170\',\'800092\',\'169\'))"]]></FILTER_EXPRESSION>
<!--4C8BC3E8E56441F4B8C98C684A0C9212-->
<OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
<!--4C8BC3E8E56441F4B8C98C684A0C9212--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--4C8BC3E8E56441F4B8C98C684A0C9212-->
<VALUEFIELD_ID><![CDATA[D5CD42F686A14DFA949052B99900D679]]></VALUEFIELD_ID>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
