Fixes Issue 29992. Fixes HQL Where Clause in OBUISEL_Selector definition.
authorDavid Miguelez <david.miguelez@openbravo.com>
Mon, 01 Jun 2015 13:08:42 +0200
changeset 26845 a9518a8e931b
parent 26844 e46899b00411
child 26846 8721a7b97a6b
Fixes Issue 29992. Fixes HQL Where Clause in OBUISEL_Selector definition.
It now filters by Products that are Stocked based on the Product definition
rather than the Stocked flag in the Storage Detail.
src-db/database/sourcedata/AD_REFERENCE.xml
src-db/database/sourcedata/OBUISEL_SELECTOR.xml
src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
--- a/src-db/database/sourcedata/AD_REFERENCE.xml	Sun May 31 15:43:59 2015 +0200
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml	Mon Jun 01 13:08:42 2015 +0200
@@ -6682,7 +6682,8 @@
 <!--F784938E74564BCABF9517EB80DB15F5-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--F784938E74564BCABF9517EB80DB15F5-->  <NAME><![CDATA[Product Complete (Stocked only)]]></NAME>
 <!--F784938E74564BCABF9517EB80DB15F5-->  <DESCRIPTION><![CDATA[Based on Product Complete selector, but only for Stocked products]]></DESCRIPTION>
-<!--F784938E74564BCABF9517EB80DB15F5-->  <HELP><![CDATA[Based on Product Complete selector, but only for Stocked products]]></HELP>
+<!--F784938E74564BCABF9517EB80DB15F5-->  <HELP><![CDATA[Based on Product Complete selector, but only for Stocked products.
+It only shows products set as stocked = Y with or without stock.]]></HELP>
 <!--F784938E74564BCABF9517EB80DB15F5-->  <VALIDATIONTYPE><![CDATA[S]]></VALIDATIONTYPE>
 <!--F784938E74564BCABF9517EB80DB15F5-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--F784938E74564BCABF9517EB80DB15F5-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
--- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml	Sun May 31 15:43:59 2015 +0200
+++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml	Mon Jun 01 13:08:42 2015 +0200
@@ -320,7 +320,7 @@
 <!--4D3AD61E57AF460EAB4D36A4E1476667-->  <NAME><![CDATA[Product Complete]]></NAME>
 <!--4D3AD61E57AF460EAB4D36A4E1476667-->  <AD_REFERENCE_ID><![CDATA[F784938E74564BCABF9517EB80DB15F5]]></AD_REFERENCE_ID>
 <!--4D3AD61E57AF460EAB4D36A4E1476667-->  <AD_TABLE_ID><![CDATA[FF8080812E381D1E012E3898C5DD0010]]></AD_TABLE_ID>
-<!--4D3AD61E57AF460EAB4D36A4E1476667-->  <WHERECLAUSE><![CDATA[e.active='Y' and e.stocked='Y']]></WHERECLAUSE>
+<!--4D3AD61E57AF460EAB4D36A4E1476667-->  <WHERECLAUSE><![CDATA[e.active='Y' and e.product.stocked='Y']]></WHERECLAUSE>
 <!--4D3AD61E57AF460EAB4D36A4E1476667-->  <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--4D3AD61E57AF460EAB4D36A4E1476667-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--4D3AD61E57AF460EAB4D36A4E1476667-->  <VALUEFIELD_ID><![CDATA[A29D60CD276243789FCACA4D044318FE]]></VALUEFIELD_ID>
--- a/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml	Sun May 31 15:43:59 2015 +0200
+++ b/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml	Mon Jun 01 13:08:42 2015 +0200
@@ -1286,7 +1286,7 @@
 <!--4B5C3C443DE744349DD370B8C85A4C28-->  <PROPERTY><![CDATA[stocked]]></PROPERTY>
 <!--4B5C3C443DE744349DD370B8C85A4C28-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--4B5C3C443DE744349DD370B8C85A4C28-->  <SORT><![CDATA[N]]></SORT>
-<!--4B5C3C443DE744349DD370B8C85A4C28-->  <FILTER><![CDATA[N]]></FILTER>
+<!--4B5C3C443DE744349DD370B8C85A4C28-->  <FILTER><![CDATA[Y]]></FILTER>
 <!--4B5C3C443DE744349DD370B8C85A4C28-->  <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX>
 <!--4B5C3C443DE744349DD370B8C85A4C28-->  <SHOWINGRID><![CDATA[Y]]></SHOWINGRID>
 <!--4B5C3C443DE744349DD370B8C85A4C28-->  <SORTNO><![CDATA[110]]></SORTNO>