0021639: Product selector in purchase order takes a long time to load the data

Notes
(0052860) hgbot (developer) 2012-09-28 12:04	Repository: erp/devel/pi Changeset: 8d6028e7aba3801ec9dd283bb85cc59fbfa1d376 Author: David Miguelez <david.miguelez <at> openbravo.com> Date: Mon Sep 24 16:44:28 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/8d6028e7aba3801ec9dd283bb85cc59fbfa1d376 [^] Fixes issue 21639: Created new selector for managing large amounts of data. --- M src-db/database/sourcedata/AD_REFERENCE.xml M src-db/database/sourcedata/OBUISEL_SELECTOR.xml M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml A src/org/openbravo/erpCommon/info/PriceListVersionFilterExpressionName.java ---

(0052861) dmiguelez (developer) 2012-09-28 12:05	This Query can help to update quickly all the references to the previous selector to the new one: update ad_column set ad_reference_id='95E2A8B50A254B2AAE6774B8C2F28120', ad_reference_value_id='712D9821BE8246AC95E6C16D8BEEBE5E' where ad_column_id in (select c.ad_column_id from ad_column c join ad_table t using (ad_table_id) join ad_window w on (t.ad_window_id=w.ad_window_id) join ad_tab tab on (t.ad_table_id=tab.ad_table_id) join ad_field f on (f.ad_column_id=c.ad_column_id) where ad_reference_value_id='800060' and (f.isreadonly = 'N' or f.isreadonly is null) and (tab.isreadonly= 'N' or tab.isreadonly is null) group by c.ad_column_id);

(0052942) egoitz (developer) 2012-10-01 08:36	verified by RM

(0053039) hudsonbot (developer) 2012-10-04 18:18	A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c067ea513614 [^] Maturity status: Test

(0053212) hudsonbot (developer) 2012-10-10 16:35	A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b088fe9dfe19 [^] Maturity status: Test

Issue History
Date Modified	Username	Field	Change
2012-09-13 13:27	jonalegriaesarte	New Issue
2012-09-13 13:27	jonalegriaesarte	Assigned To	=> AugustoMauch
2012-09-13 13:27	jonalegriaesarte	Modules	=> Core
2012-09-13 13:27	jonalegriaesarte	Tag Attached: Performance
2012-09-13 18:26	AugustoMauch	Relationship added	has duplicate 0021643
2012-09-14 09:41	AugustoMauch	Assigned To	AugustoMauch => dmiguelez
2012-09-28 12:04	hgbot	Checkin
2012-09-28 12:04	hgbot	Note Added: 0052860
2012-09-28 12:04	hgbot	Status	new => resolved
2012-09-28 12:04	hgbot	Resolution	open => fixed
2012-09-28 12:04	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/8d6028e7aba3801ec9dd283bb85cc59fbfa1d376 [^]
2012-09-28 12:05	dmiguelez	Note Added: 0052861
2012-10-01 08:36	egoitz	Closed by	=> egoitz
2012-10-01 08:36	egoitz	Note Added: 0052942
2012-10-01 08:36	egoitz	Status	resolved => closed
2012-10-01 08:36	egoitz	Fixed in Version	=> 3.0MP16
2012-10-04 18:18	hudsonbot	Checkin
2012-10-04 18:18	hudsonbot	Note Added: 0053039
2012-10-10 16:35	hudsonbot	Checkin
2012-10-10 16:35	hudsonbot	Note Added: 0053212
2012-10-16 13:02	plujan	Relationship added	related to 0021952
2012-11-12 13:39	egoitz	Relationship added	related to 0022271