details: https://code.openbravo.com/erp/devel/pi/rev/c1e602ffd4dd changeset: 20090:c1e602ffd4dd user: Ioritz Cia <ioritz.cia <at> openbravo.com> date: Thu Apr 11 16:58:35 2013 +0200 summary: Fixes issue 22820: Inactive price list can be selected in product selector.
details: https://code.openbravo.com/erp/devel/pi/rev/a85c6b9c9d5a changeset: 20091:a85c6b9c9d5a user: Ioritz Cia <ioritz.cia <at> openbravo.com> date: Thu Apr 11 17:00:11 2013 +0200 summary: Fixes issue 23239: Work requirement window can not be filtered by status. diffstat: src-db/database/sourcedata/AD_COLUMN.xml | 33 +++++++++++++++++++++++++ src-db/database/sourcedata/AD_ELEMENT.xml | 12 +++++++++ src-db/database/sourcedata/AD_FIELD.xml | 27 ++++++++++++++++++++ src-db/database/sourcedata/OBUISEL_SELECTOR.xml | 2 +- 4 files changed, 73 insertions(+), 1 deletions(-) diffs (114 lines): diff -r 8f1178c8535a -r a85c6b9c9d5a src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Fri Apr 12 07:23:33 2013 +0530 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Thu Apr 11 17:00:11 2013 +0200 @@ -310548,6 +310548,39 @@ <!--D9DD2D28EC204CE7BC17C121276F7078--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> <!--D9DD2D28EC204CE7BC17C121276F7078--></AD_COLUMN> +<!--D9E16A76C40D4D8FBAE78707B15DF356--><AD_COLUMN> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <AD_COLUMN_ID><![CDATA[D9E16A76C40D4D8FBAE78707B15DF356]]></AD_COLUMN_ID> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <NAME><![CDATA[closedStat]]></NAME> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <COLUMNNAME><![CDATA[closedStat]]></COLUMNNAME> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <AD_TABLE_ID><![CDATA[800098]]></AD_TABLE_ID> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <FIELDLENGTH><![CDATA[20]]></FIELDLENGTH> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISKEY><![CDATA[N]]></ISKEY> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISPARENT><![CDATA[N]]></ISPARENT> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <SEQNO><![CDATA[270]]></SEQNO> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <AD_ELEMENT_ID><![CDATA[F01EC4089294476F984FFD0D825ED13F]]></AD_ELEMENT_ID> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> +<!--D9E16A76C40D4D8FBAE78707B15DF356--> <SQLLOGIC><![CDATA[select closed from dual]]></SQLLOGIC> +<!--D9E16A76C40D4D8FBAE78707B15DF356--></AD_COLUMN> + <!--D9EAA088B59111DD97A00016D4EE9DB3--><AD_COLUMN> <!--D9EAA088B59111DD97A00016D4EE9DB3--> <AD_COLUMN_ID><![CDATA[D9EAA088B59111DD97A00016D4EE9DB3]]></AD_COLUMN_ID> <!--D9EAA088B59111DD97A00016D4EE9DB3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r 8f1178c8535a -r a85c6b9c9d5a src-db/database/sourcedata/AD_ELEMENT.xml --- a/src-db/database/sourcedata/AD_ELEMENT.xml Fri Apr 12 07:23:33 2013 +0530 +++ b/src-db/database/sourcedata/AD_ELEMENT.xml Thu Apr 11 17:00:11 2013 +0200 @@ -31142,6 +31142,18 @@ <!--F00369E4DAE247D48CFAEB000C452F74--> <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY> <!--F00369E4DAE247D48CFAEB000C452F74--></AD_ELEMENT> +<!--F01EC4089294476F984FFD0D825ED13F--><AD_ELEMENT> +<!--F01EC4089294476F984FFD0D825ED13F--> <AD_ELEMENT_ID><![CDATA[F01EC4089294476F984FFD0D825ED13F]]></AD_ELEMENT_ID> +<!--F01EC4089294476F984FFD0D825ED13F--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--F01EC4089294476F984FFD0D825ED13F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--F01EC4089294476F984FFD0D825ED13F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--F01EC4089294476F984FFD0D825ED13F--> <COLUMNNAME><![CDATA[closedStat]]></COLUMNNAME> +<!--F01EC4089294476F984FFD0D825ED13F--> <NAME><![CDATA[Closed]]></NAME> +<!--F01EC4089294476F984FFD0D825ED13F--> <PRINTNAME><![CDATA[Closed]]></PRINTNAME> +<!--F01EC4089294476F984FFD0D825ED13F--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--F01EC4089294476F984FFD0D825ED13F--> <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY> +<!--F01EC4089294476F984FFD0D825ED13F--></AD_ELEMENT> + <!--F1852A15D8FD45F9B9A54962B40E1E43--><AD_ELEMENT> <!--F1852A15D8FD45F9B9A54962B40E1E43--> <AD_ELEMENT_ID><![CDATA[F1852A15D8FD45F9B9A54962B40E1E43]]></AD_ELEMENT_ID> <!--F1852A15D8FD45F9B9A54962B40E1E43--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r 8f1178c8535a -r a85c6b9c9d5a src-db/database/sourcedata/AD_FIELD.xml --- a/src-db/database/sourcedata/AD_FIELD.xml Fri Apr 12 07:23:33 2013 +0530 +++ b/src-db/database/sourcedata/AD_FIELD.xml Thu Apr 11 17:00:11 2013 +0200 @@ -230535,6 +230535,33 @@ <!--87D0C3600483413197BFC485D80B57B4--> <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> <!--87D0C3600483413197BFC485D80B57B4--></AD_FIELD> +<!--87D6084B54DB43C289E9127DF16586DD--><AD_FIELD> +<!--87D6084B54DB43C289E9127DF16586DD--> <AD_FIELD_ID><![CDATA[87D6084B54DB43C289E9127DF16586DD]]></AD_FIELD_ID> +<!--87D6084B54DB43C289E9127DF16586DD--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--87D6084B54DB43C289E9127DF16586DD--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--87D6084B54DB43C289E9127DF16586DD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--87D6084B54DB43C289E9127DF16586DD--> <NAME><![CDATA[Closed]]></NAME> +<!--87D6084B54DB43C289E9127DF16586DD--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--87D6084B54DB43C289E9127DF16586DD--> <AD_TAB_ID><![CDATA[800111]]></AD_TAB_ID> +<!--87D6084B54DB43C289E9127DF16586DD--> <AD_COLUMN_ID><![CDATA[D9E16A76C40D4D8FBAE78707B15DF356]]></AD_COLUMN_ID> +<!--87D6084B54DB43C289E9127DF16586DD--> <IGNOREINWAD><![CDATA[Y]]></IGNOREINWAD> +<!--87D6084B54DB43C289E9127DF16586DD--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED> +<!--87D6084B54DB43C289E9127DF16586DD--> <DISPLAYLENGTH><![CDATA[0]]></DISPLAYLENGTH> +<!--87D6084B54DB43C289E9127DF16586DD--> <ISREADONLY><![CDATA[N]]></ISREADONLY> +<!--87D6084B54DB43C289E9127DF16586DD--> <SEQNO><![CDATA[160]]></SEQNO> +<!--87D6084B54DB43C289E9127DF16586DD--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> +<!--87D6084B54DB43C289E9127DF16586DD--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> +<!--87D6084B54DB43C289E9127DF16586DD--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> +<!--87D6084B54DB43C289E9127DF16586DD--> <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION> +<!--87D6084B54DB43C289E9127DF16586DD--> <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD> +<!--87D6084B54DB43C289E9127DF16586DD--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--87D6084B54DB43C289E9127DF16586DD--> <GRID_SEQNO><![CDATA[120]]></GRID_SEQNO> +<!--87D6084B54DB43C289E9127DF16586DD--> <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN> +<!--87D6084B54DB43C289E9127DF16586DD--> <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE> +<!--87D6084B54DB43C289E9127DF16586DD--> <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR> +<!--87D6084B54DB43C289E9127DF16586DD--> <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> +<!--87D6084B54DB43C289E9127DF16586DD--></AD_FIELD> + <!--87D87F23F8F642C9A0A1670AE01D0262--><AD_FIELD> <!--87D87F23F8F642C9A0A1670AE01D0262--> <AD_FIELD_ID><![CDATA[87D87F23F8F642C9A0A1670AE01D0262]]></AD_FIELD_ID> <!--87D87F23F8F642C9A0A1670AE01D0262--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r 8f1178c8535a -r a85c6b9c9d5a src-db/database/sourcedata/OBUISEL_SELECTOR.xml --- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Fri Apr 12 07:23:33 2013 +0530 +++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Thu Apr 11 17:00:11 2013 +0200 @@ -74,7 +74,7 @@ <!--2E64F551C7C4470C80C29DBA24B34A5F--> <NAME><![CDATA[Product]]></NAME> <!--2E64F551C7C4470C80C29DBA24B34A5F--> <AD_REFERENCE_ID><![CDATA[800060]]></AD_REFERENCE_ID> <!--2E64F551C7C4470C80C29DBA24B34A5F--> <AD_TABLE_ID><![CDATA[FF8080812DFFA1CF012DFFB889F40016]]></AD_TABLE_ID> -<!--2E64F551C7C4470C80C29DBA24B34A5F--> <WHERECLAUSE><![CDATA[e.active='Y' and (AD_ISORGINCLUDED(e.warehouse.organization.id, @AD_Org_Id@, @AD_Client_Id@)<>-1 or (AD_ISORGINCLUDED( @AD_Org_Id@, e.warehouse.organization.id, @AD_Client_Id@)<>-1))]]></WHERECLAUSE> +<!--2E64F551C7C4470C80C29DBA24B34A5F--> <WHERECLAUSE><![CDATA[e.active='Y' and (AD_ISORGINCLUDED(e.warehouse.organization.id, @AD_Org_Id@, @AD_Client_Id@)<>-1 or (AD_ISORGINCLUDED( @AD_Org_Id@, e.warehouse.organization.id, @AD_Client_Id@)<>-1)) AND e.productPrice.priceListVersion.active='Y']]></WHERECLAUSE> <!--2E64F551C7C4470C80C29DBA24B34A5F--> <FILTER_EXPRESSION><![CDATA[if (OB.getParameters().get('inpcCurrencyId')){ " e.productPrice.priceListVersion.priceList.salesPriceList = " + OB.isSalesTransaction() + " AND e.productPrice.priceListVersion.priceList.currency.id = '" + OB.getParameters().get('inpcCurrencyId') + "'" }]]></FILTER_EXPRESSION> <!--2E64F551C7C4470C80C29DBA24B34A5F--> <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID> <!--2E64F551C7C4470C80C29DBA24B34A5F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits
