details: https://code.openbravo.com/erp/devel/pi/rev/4f2d5a272565 changeset: 31964:4f2d5a272565 user: Mark <markmm82 <at> gmail.com> date: Wed Apr 12 13:18:21 2017 +0200 summary: Fixes issue 35662: Improve performance of BP selector in FA window
Improve performance of Business Partner selector in Financial Account window. "Business Partner selector without default expressions" will be used instead of "Business Partner not filtered by default by customer/vendor" as Business Partner selector in Financial Account window in Account and Bank Statement Lines tabs. Thus, we take advantage of c_bpartner_name_id index. diffstat: src-db/database/sourcedata/AD_COLUMN.xml | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diffs (21 lines): diff -r dcd984fd5b2f -r 4f2d5a272565 src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Wed Apr 12 12:33:01 2017 +0200 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Wed Apr 12 13:18:21 2017 +0200 @@ -313416,7 +313416,7 @@ <!--8189F49FFEC36E56E040007F01003E83--> <COLUMNNAME><![CDATA[C_Bpartner_ID]]></COLUMNNAME> <!--8189F49FFEC36E56E040007F01003E83--> <AD_TABLE_ID><![CDATA[84203CBEBDA349C38319C0E549751546]]></AD_TABLE_ID> <!--8189F49FFEC36E56E040007F01003E83--> <AD_REFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></AD_REFERENCE_ID> -<!--8189F49FFEC36E56E040007F01003E83--> <AD_REFERENCE_VALUE_ID><![CDATA[4028E61131FB4B1B0131FB5226C90008]]></AD_REFERENCE_VALUE_ID> +<!--8189F49FFEC36E56E040007F01003E83--> <AD_REFERENCE_VALUE_ID><![CDATA[488E4BF765294DD8A7A943BDED4BA6E6]]></AD_REFERENCE_VALUE_ID> <!--8189F49FFEC36E56E040007F01003E83--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> <!--8189F49FFEC36E56E040007F01003E83--> <ISKEY><![CDATA[N]]></ISKEY> <!--8189F49FFEC36E56E040007F01003E83--> <ISPARENT><![CDATA[N]]></ISPARENT> @@ -317279,7 +317279,7 @@ <!--828EE0AE80475FA1E040007F010067C7--> <COLUMNNAME><![CDATA[C_Bpartner_ID]]></COLUMNNAME> <!--828EE0AE80475FA1E040007F010067C7--> <AD_TABLE_ID><![CDATA[B129E53BC0E747879F7BA17F0AECEC32]]></AD_TABLE_ID> <!--828EE0AE80475FA1E040007F010067C7--> <AD_REFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></AD_REFERENCE_ID> -<!--828EE0AE80475FA1E040007F010067C7--> <AD_REFERENCE_VALUE_ID><![CDATA[4028E61131FB4B1B0131FB5226C90008]]></AD_REFERENCE_VALUE_ID> +<!--828EE0AE80475FA1E040007F010067C7--> <AD_REFERENCE_VALUE_ID><![CDATA[488E4BF765294DD8A7A943BDED4BA6E6]]></AD_REFERENCE_VALUE_ID> <!--828EE0AE80475FA1E040007F010067C7--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> <!--828EE0AE80475FA1E040007F010067C7--> <ISKEY><![CDATA[N]]></ISKEY> <!--828EE0AE80475FA1E040007F010067C7--> <ISPARENT><![CDATA[N]]></ISPARENT> ------------------------------------------------------------------------------ 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