details: https://code.openbravo.com/erp/devel/pi/rev/3e42b5ba12da changeset: 19421:3e42b5ba12da user: Javier Etxarri <javier.echarri <at> openbravo.com> date: Thu Jan 24 10:44:35 2013 +0100 summary: Fixes issue 22795: G/L Journal lines window takes long time to load due to two combo boxes with a huge amount of data
diffstat: src-db/database/sourcedata/AD_COLUMN.xml | 3 +- src-db/database/sourcedata/AD_REFERENCE.xml | 14 ++++++ src-db/database/sourcedata/OBUISEL_SELECTOR.xml | 19 ++++++++ src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml | 41 +++++++++++++++++++ 4 files changed, 76 insertions(+), 1 deletions(-) diffs (123 lines): diff -r 7b90716e2170 -r 3e42b5ba12da src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Thu Jan 24 11:44:21 2013 +0530 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Thu Jan 24 10:44:35 2013 +0100 @@ -287878,7 +287878,8 @@ <!--A7F1531510444244E040007F010064A6--> <HELP><![CDATA[Identifies an item which is either purchased or sold in this organization.]]></HELP> <!--A7F1531510444244E040007F010064A6--> <COLUMNNAME><![CDATA[M_Product_ID]]></COLUMNNAME> <!--A7F1531510444244E040007F010064A6--> <AD_TABLE_ID><![CDATA[226]]></AD_TABLE_ID> -<!--A7F1531510444244E040007F010064A6--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> +<!--A7F1531510444244E040007F010064A6--> <AD_REFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></AD_REFERENCE_ID> +<!--A7F1531510444244E040007F010064A6--> <AD_REFERENCE_VALUE_ID><![CDATA[84BD487714B04B838A8D562A30E8792C]]></AD_REFERENCE_VALUE_ID> <!--A7F1531510444244E040007F010064A6--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> <!--A7F1531510444244E040007F010064A6--> <ISKEY><![CDATA[N]]></ISKEY> <!--A7F1531510444244E040007F010064A6--> <ISPARENT><![CDATA[N]]></ISPARENT> diff -r 7b90716e2170 -r 3e42b5ba12da src-db/database/sourcedata/AD_REFERENCE.xml --- a/src-db/database/sourcedata/AD_REFERENCE.xml Thu Jan 24 11:44:21 2013 +0530 +++ b/src-db/database/sourcedata/AD_REFERENCE.xml Thu Jan 24 10:44:35 2013 +0100 @@ -5041,6 +5041,20 @@ <!--83AD04A0C49E4801BF276B690265A3D1--> <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED> <!--83AD04A0C49E4801BF276B690265A3D1--></AD_REFERENCE> +<!--84BD487714B04B838A8D562A30E8792C--><AD_REFERENCE> +<!--84BD487714B04B838A8D562A30E8792C--> <AD_REFERENCE_ID><![CDATA[84BD487714B04B838A8D562A30E8792C]]></AD_REFERENCE_ID> +<!--84BD487714B04B838A8D562A30E8792C--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--84BD487714B04B838A8D562A30E8792C--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--84BD487714B04B838A8D562A30E8792C--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--84BD487714B04B838A8D562A30E8792C--> <NAME><![CDATA[Products]]></NAME> +<!--84BD487714B04B838A8D562A30E8792C--> <DESCRIPTION><![CDATA[Generic Product Selector]]></DESCRIPTION> +<!--84BD487714B04B838A8D562A30E8792C--> <HELP><![CDATA[This selector shows all the available products]]></HELP> +<!--84BD487714B04B838A8D562A30E8792C--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--84BD487714B04B838A8D562A30E8792C--> <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE> +<!--84BD487714B04B838A8D562A30E8792C--> <PARENTREFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></PARENTREFERENCE_ID> +<!--84BD487714B04B838A8D562A30E8792C--> <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED> +<!--84BD487714B04B838A8D562A30E8792C--></AD_REFERENCE> + <!--86086D70DDBC42B09E2BEB51D25C159F--><AD_REFERENCE> <!--86086D70DDBC42B09E2BEB51D25C159F--> <AD_REFERENCE_ID><![CDATA[86086D70DDBC42B09E2BEB51D25C159F]]></AD_REFERENCE_ID> <!--86086D70DDBC42B09E2BEB51D25C159F--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r 7b90716e2170 -r 3e42b5ba12da src-db/database/sourcedata/OBUISEL_SELECTOR.xml --- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Thu Jan 24 11:44:21 2013 +0530 +++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml Thu Jan 24 10:44:35 2013 +0100 @@ -1,5 +1,24 @@ <?xml version='1.0' encoding='UTF-8'?> <data> +<!--00A9109E64DD404CA95719D20A9BBBF0--><OBUISEL_SELECTOR> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <OBUISEL_SELECTOR_ID><![CDATA[00A9109E64DD404CA95719D20A9BBBF0]]></OBUISEL_SELECTOR_ID> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <NAME><![CDATA[Products]]></NAME> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <DESCRIPTION><![CDATA[This selector shows all the available products]]></DESCRIPTION> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <HELP><![CDATA[This selector shows all the available products]]></HELP> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <AD_REFERENCE_ID><![CDATA[84BD487714B04B838A8D562A30E8792C]]></AD_REFERENCE_ID> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <AD_TABLE_ID><![CDATA[208]]></AD_TABLE_ID> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <AD_COLUMN_ID><![CDATA[1402]]></AD_COLUMN_ID> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <VALUEFIELD_ID><![CDATA[8283EB51255943B3B92B421AE14E8661]]></VALUEFIELD_ID> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <POPUPTEXTMATCHSTYLE><![CDATA[substring]]></POPUPTEXTMATCHSTYLE> +<!--00A9109E64DD404CA95719D20A9BBBF0--> <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY> +<!--00A9109E64DD404CA95719D20A9BBBF0--></OBUISEL_SELECTOR> + <!--0E1E9236E2FE471FB946F8DA2803C537--><OBUISEL_SELECTOR> <!--0E1E9236E2FE471FB946F8DA2803C537--> <OBUISEL_SELECTOR_ID><![CDATA[0E1E9236E2FE471FB946F8DA2803C537]]></OBUISEL_SELECTOR_ID> <!--0E1E9236E2FE471FB946F8DA2803C537--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r 7b90716e2170 -r 3e42b5ba12da src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml --- a/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml Thu Jan 24 11:44:21 2013 +0530 +++ b/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml Thu Jan 24 10:44:35 2013 +0100 @@ -88,6 +88,28 @@ <!--0EE172E722774F0398B83152B48DAB8D--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> <!--0EE172E722774F0398B83152B48DAB8D--></OBUISEL_SELECTOR_FIELD> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--><OBUISEL_SELECTOR_FIELD> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[0F4AEA7AAB7D4D2AA913B5B5976BA0E9]]></OBUISEL_SELECTOR_FIELD_ID> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <OBUISEL_SELECTOR_ID><![CDATA[00A9109E64DD404CA95719D20A9BBBF0]]></OBUISEL_SELECTOR_ID> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <AD_COLUMN_ID><![CDATA[1410]]></AD_COLUMN_ID> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <NAME><![CDATA[Name]]></NAME> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <DESCRIPTION><![CDATA[A non-unique identifier for a record/document often used as a search tool.]]></DESCRIPTION> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <HELP><![CDATA[A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.]]></HELP> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <PROPERTY><![CDATA[name]]></PROPERTY> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <SORT><![CDATA[Y]]></SORT> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <FILTER><![CDATA[Y]]></FILTER> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <SEARCHINSUGGESTIONBOX><![CDATA[Y]]></SEARCHINSUGGESTIONBOX> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <SORTNO><![CDATA[0]]></SORTNO> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> +<!--0F4AEA7AAB7D4D2AA913B5B5976BA0E9--></OBUISEL_SELECTOR_FIELD> + <!--190E45B61635477BBC0799229F889FD6--><OBUISEL_SELECTOR_FIELD> <!--190E45B61635477BBC0799229F889FD6--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[190E45B61635477BBC0799229F889FD6]]></OBUISEL_SELECTOR_FIELD_ID> <!--190E45B61635477BBC0799229F889FD6--> <OBUISEL_SELECTOR_ID><![CDATA[B748F356A65641D4974E5C349A16FB27]]></OBUISEL_SELECTOR_ID> @@ -1076,6 +1098,25 @@ <!--7F415E2D50A041CB83BF79EA460DB884--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> <!--7F415E2D50A041CB83BF79EA460DB884--></OBUISEL_SELECTOR_FIELD> +<!--8283EB51255943B3B92B421AE14E8661--><OBUISEL_SELECTOR_FIELD> +<!--8283EB51255943B3B92B421AE14E8661--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[8283EB51255943B3B92B421AE14E8661]]></OBUISEL_SELECTOR_FIELD_ID> +<!--8283EB51255943B3B92B421AE14E8661--> <OBUISEL_SELECTOR_ID><![CDATA[00A9109E64DD404CA95719D20A9BBBF0]]></OBUISEL_SELECTOR_ID> +<!--8283EB51255943B3B92B421AE14E8661--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--8283EB51255943B3B92B421AE14E8661--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--8283EB51255943B3B92B421AE14E8661--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--8283EB51255943B3B92B421AE14E8661--> <NAME><![CDATA[ProductID]]></NAME> +<!--8283EB51255943B3B92B421AE14E8661--> <PROPERTY><![CDATA[id]]></PROPERTY> +<!--8283EB51255943B3B92B421AE14E8661--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> +<!--8283EB51255943B3B92B421AE14E8661--> <SORT><![CDATA[Y]]></SORT> +<!--8283EB51255943B3B92B421AE14E8661--> <FILTER><![CDATA[Y]]></FILTER> +<!--8283EB51255943B3B92B421AE14E8661--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX> +<!--8283EB51255943B3B92B421AE14E8661--> <SHOWINGRID><![CDATA[N]]></SHOWINGRID> +<!--8283EB51255943B3B92B421AE14E8661--> <SORTNO><![CDATA[0]]></SORTNO> +<!--8283EB51255943B3B92B421AE14E8661--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--8283EB51255943B3B92B421AE14E8661--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD> +<!--8283EB51255943B3B92B421AE14E8661--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST> +<!--8283EB51255943B3B92B421AE14E8661--></OBUISEL_SELECTOR_FIELD> + <!--8296CA3FDAB04B698B1EDD4BC76F1512--><OBUISEL_SELECTOR_FIELD> <!--8296CA3FDAB04B698B1EDD4BC76F1512--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[8296CA3FDAB04B698B1EDD4BC76F1512]]></OBUISEL_SELECTOR_FIELD_ID> <!--8296CA3FDAB04B698B1EDD4BC76F1512--> <OBUISEL_SELECTOR_ID><![CDATA[4C8BC3E8E56441F4B8C98C684A0C9212]]></OBUISEL_SELECTOR_ID> ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
