details: /erp/devel/pi/rev/8fc76d38ccd3 changeset: 8557:8fc76d38ccd3 user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com> date: Mon Oct 18 08:16:25 2010 +0200 summary: Fixed bug 14284: Period Control tab perfomance issues in Oracle
Removed order by clause from the Organization || Period Control tab as a workaround for properly loading this tab on Oracle. Added a filter to show by default the opened periods, which also improves the performance. Improved application dictionary definition related to this view. diffstat: src-db/database/sourcedata/AD_COLUMN.xml | 22 +++++++++++----------- src-db/database/sourcedata/AD_TAB.xml | 2 +- src-db/database/sourcedata/AD_TABLE.xml | 3 ++- 3 files changed, 14 insertions(+), 13 deletions(-) diffs (126 lines): diff -r 145b78161715 -r 8fc76d38ccd3 src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Mon Oct 18 12:59:43 2010 +0530 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Mon Oct 18 08:16:25 2010 +0200 @@ -281283,7 +281283,7 @@ <!--60FCCD631EA3EDF8E040007F01013AD4--> <HELP><![CDATA[A Client is a company or a legal entity. You cannot share data between Clients.]]></HELP> <!--60FCCD631EA3EDF8E040007F01013AD4--> <COLUMNNAME><![CDATA[AD_Client_ID]]></COLUMNNAME> <!--60FCCD631EA3EDF8E040007F01013AD4--> <AD_TABLE_ID><![CDATA[CB391C8A13D74B688A34017B5B5D1F5D]]></AD_TABLE_ID> -<!--60FCCD631EA3EDF8E040007F01013AD4--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> +<!--60FCCD631EA3EDF8E040007F01013AD4--> <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID> <!--60FCCD631EA3EDF8E040007F01013AD4--> <AD_VAL_RULE_ID><![CDATA[103]]></AD_VAL_RULE_ID> <!--60FCCD631EA3EDF8E040007F01013AD4--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> <!--60FCCD631EA3EDF8E040007F01013AD4--> <DEFAULTVALUE><![cda...@ad_client_id@]]></DEFAULTVALUE> @@ -281318,7 +281318,7 @@ <!--60FCCD631EA4EDF8E040007F01013AD4--> <HELP><![CDATA[An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.]]></HELP> <!--60FCCD631EA4EDF8E040007F01013AD4--> <COLUMNNAME><![CDATA[AD_Org_ID]]></COLUMNNAME> <!--60FCCD631EA4EDF8E040007F01013AD4--> <AD_TABLE_ID><![CDATA[CB391C8A13D74B688A34017B5B5D1F5D]]></AD_TABLE_ID> -<!--60FCCD631EA4EDF8E040007F01013AD4--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> +<!--60FCCD631EA4EDF8E040007F01013AD4--> <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID> <!--60FCCD631EA4EDF8E040007F01013AD4--> <AD_VAL_RULE_ID><![CDATA[104]]></AD_VAL_RULE_ID> <!--60FCCD631EA4EDF8E040007F01013AD4--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> <!--60FCCD631EA4EDF8E040007F01013AD4--> <DEFAULTVALUE><![cda...@ad_org_id@]]></DEFAULTVALUE> @@ -281360,7 +281360,7 @@ <!--60FCCD631EA5EDF8E040007F01013AD4--> <ISKEY><![CDATA[N]]></ISKEY> <!--60FCCD631EA5EDF8E040007F01013AD4--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--60FCCD631EA5EDF8E040007F01013AD4--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> -<!--60FCCD631EA5EDF8E040007F01013AD4--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--60FCCD631EA5EDF8E040007F01013AD4--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> <!--60FCCD631EA5EDF8E040007F01013AD4--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> <!--60FCCD631EA5EDF8E040007F01013AD4--> <SEQNO><![CDATA[40]]></SEQNO> <!--60FCCD631EA5EDF8E040007F01013AD4--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> @@ -281520,10 +281520,10 @@ <!--60FCCD631EAAEDF8E040007F01013AD4--> <HELP><![CDATA[The Period indicates an exclusive range of dates for a calendar.]]></HELP> <!--60FCCD631EAAEDF8E040007F01013AD4--> <COLUMNNAME><![CDATA[C_Period_ID]]></COLUMNNAME> <!--60FCCD631EAAEDF8E040007F01013AD4--> <AD_TABLE_ID><![CDATA[CB391C8A13D74B688A34017B5B5D1F5D]]></AD_TABLE_ID> -<!--60FCCD631EAAEDF8E040007F01013AD4--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> +<!--60FCCD631EAAEDF8E040007F01013AD4--> <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID> <!--60FCCD631EAAEDF8E040007F01013AD4--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> <!--60FCCD631EAAEDF8E040007F01013AD4--> <ISKEY><![CDATA[N]]></ISKEY> -<!--60FCCD631EAAEDF8E040007F01013AD4--> <ISPARENT><![CDATA[Y]]></ISPARENT> +<!--60FCCD631EAAEDF8E040007F01013AD4--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--60FCCD631EAAEDF8E040007F01013AD4--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> <!--60FCCD631EAAEDF8E040007F01013AD4--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> <!--60FCCD631EAAEDF8E040007F01013AD4--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> @@ -281559,7 +281559,7 @@ <!--60FCCD631EABEDF8E040007F01013AD4--> <ISKEY><![CDATA[N]]></ISKEY> <!--60FCCD631EABEDF8E040007F01013AD4--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--60FCCD631EABEDF8E040007F01013AD4--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> -<!--60FCCD631EABEDF8E040007F01013AD4--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--60FCCD631EABEDF8E040007F01013AD4--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> <!--60FCCD631EABEDF8E040007F01013AD4--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> <!--60FCCD631EABEDF8E040007F01013AD4--> <SEQNO><![CDATA[110]]></SEQNO> <!--60FCCD631EABEDF8E040007F01013AD4--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> @@ -281593,7 +281593,7 @@ <!--60FCCD631EACEDF8E040007F01013AD4--> <ISKEY><![CDATA[N]]></ISKEY> <!--60FCCD631EACEDF8E040007F01013AD4--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--60FCCD631EACEDF8E040007F01013AD4--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> -<!--60FCCD631EACEDF8E040007F01013AD4--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--60FCCD631EACEDF8E040007F01013AD4--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> <!--60FCCD631EACEDF8E040007F01013AD4--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> <!--60FCCD631EACEDF8E040007F01013AD4--> <SEQNO><![CDATA[140]]></SEQNO> <!--60FCCD631EACEDF8E040007F01013AD4--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> @@ -281627,7 +281627,7 @@ <!--60FCCD631EADEDF8E040007F01013AD4--> <ISKEY><![CDATA[N]]></ISKEY> <!--60FCCD631EADEDF8E040007F01013AD4--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--60FCCD631EADEDF8E040007F01013AD4--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> -<!--60FCCD631EADEDF8E040007F01013AD4--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--60FCCD631EADEDF8E040007F01013AD4--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> <!--60FCCD631EADEDF8E040007F01013AD4--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> <!--60FCCD631EADEDF8E040007F01013AD4--> <SEQNO><![CDATA[120]]></SEQNO> <!--60FCCD631EADEDF8E040007F01013AD4--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> @@ -281760,7 +281760,7 @@ <!--60FCCD631EB1EDF8E040007F01013AD4--> <ISKEY><![CDATA[N]]></ISKEY> <!--60FCCD631EB1EDF8E040007F01013AD4--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--60FCCD631EB1EDF8E040007F01013AD4--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> -<!--60FCCD631EB1EDF8E040007F01013AD4--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--60FCCD631EB1EDF8E040007F01013AD4--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> <!--60FCCD631EB1EDF8E040007F01013AD4--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> <!--60FCCD631EB1EDF8E040007F01013AD4--> <SEQNO><![CDATA[160]]></SEQNO> <!--60FCCD631EB1EDF8E040007F01013AD4--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> @@ -281793,7 +281793,7 @@ <!--60FCCD631EB2EDF8E040007F01013AD4--> <ISKEY><![CDATA[N]]></ISKEY> <!--60FCCD631EB2EDF8E040007F01013AD4--> <ISPARENT><![CDATA[N]]></ISPARENT> <!--60FCCD631EB2EDF8E040007F01013AD4--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY> -<!--60FCCD631EB2EDF8E040007F01013AD4--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE> +<!--60FCCD631EB2EDF8E040007F01013AD4--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> <!--60FCCD631EB2EDF8E040007F01013AD4--> <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER> <!--60FCCD631EB2EDF8E040007F01013AD4--> <SEQNO><![CDATA[170]]></SEQNO> <!--60FCCD631EB2EDF8E040007F01013AD4--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> @@ -281821,7 +281821,7 @@ <!--60FCDCE9EE1EA8BEE040007F01013AC1--> <HELP><![CDATA[The Calendar uniquely identifies an accounting calendar. Multiple calendars can be used. For example you may need a standard calendar that runs from Jan 1 to Dec 31 and a fiscal calendar that runs from July 1 to June 30.]]></HELP> <!--60FCDCE9EE1EA8BEE040007F01013AC1--> <COLUMNNAME><![CDATA[C_Calendar_ID]]></COLUMNNAME> <!--60FCDCE9EE1EA8BEE040007F01013AC1--> <AD_TABLE_ID><![CDATA[CB391C8A13D74B688A34017B5B5D1F5D]]></AD_TABLE_ID> -<!--60FCDCE9EE1EA8BEE040007F01013AC1--> <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID> +<!--60FCDCE9EE1EA8BEE040007F01013AC1--> <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID> <!--60FCDCE9EE1EA8BEE040007F01013AC1--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH> <!--60FCDCE9EE1EA8BEE040007F01013AC1--> <ISKEY><![CDATA[N]]></ISKEY> <!--60FCDCE9EE1EA8BEE040007F01013AC1--> <ISPARENT><![CDATA[N]]></ISPARENT> diff -r 145b78161715 -r 8fc76d38ccd3 src-db/database/sourcedata/AD_TAB.xml --- a/src-db/database/sourcedata/AD_TAB.xml Mon Oct 18 12:59:43 2010 +0530 +++ b/src-db/database/sourcedata/AD_TAB.xml Mon Oct 18 08:16:25 2010 +0200 @@ -13112,10 +13112,10 @@ <!--6BC4F7D2CBE94AEE939CCB5990B55FEA--> <ISTRANSLATIONTAB><![CDATA[N]]></ISTRANSLATIONTAB> <!--6BC4F7D2CBE94AEE939CCB5990B55FEA--> <ISREADONLY><![CDATA[Y]]></ISREADONLY> <!--6BC4F7D2CBE94AEE939CCB5990B55FEA--> <HASTREE><![CDATA[N]]></HASTREE> -<!--6BC4F7D2CBE94AEE939CCB5990B55FEA--> <ORDERBYCLAUSE><![CDATA[Year DESC, Startdate ASC]]></ORDERBYCLAUSE> <!--6BC4F7D2CBE94AEE939CCB5990B55FEA--> <PROCESSING><![CDATA[N]]></PROCESSING> <!--6BC4F7D2CBE94AEE939CCB5990B55FEA--> <IMPORTFIELDS><![CDATA[N]]></IMPORTFIELDS> <!--6BC4F7D2CBE94AEE939CCB5990B55FEA--> <ISSORTTAB><![CDATA[N]]></ISSORTTAB> +<!--6BC4F7D2CBE94AEE939CCB5990B55FEA--> <FILTERCLAUSE><![CDATA[PeriodStatus='O']]></FILTERCLAUSE> <!--6BC4F7D2CBE94AEE939CCB5990B55FEA--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--6BC4F7D2CBE94AEE939CCB5990B55FEA--> <UIPATTERN><![CDATA[RO]]></UIPATTERN> <!--6BC4F7D2CBE94AEE939CCB5990B55FEA--></AD_TAB> diff -r 145b78161715 -r 8fc76d38ccd3 src-db/database/sourcedata/AD_TABLE.xml --- a/src-db/database/sourcedata/AD_TABLE.xml Mon Oct 18 12:59:43 2010 +0530 +++ b/src-db/database/sourcedata/AD_TABLE.xml Mon Oct 18 08:16:25 2010 +0200 @@ -11048,8 +11048,9 @@ <!--CB391C8A13D74B688A34017B5B5D1F5D--> <CLASSNAME><![CDATA[PeriodControlV]]></CLASSNAME> <!--CB391C8A13D74B688A34017B5B5D1F5D--> <ISVIEW><![CDATA[Y]]></ISVIEW> <!--CB391C8A13D74B688A34017B5B5D1F5D--> <ACCESSLEVEL><![CDATA[3]]></ACCESSLEVEL> +<!--CB391C8A13D74B688A34017B5B5D1F5D--> <AD_WINDOW_ID><![CDATA[110]]></AD_WINDOW_ID> <!--CB391C8A13D74B688A34017B5B5D1F5D--> <ISSECURITYENABLED><![CDATA[N]]></ISSECURITYENABLED> -<!--CB391C8A13D74B688A34017B5B5D1F5D--> <ISDELETEABLE><![CDATA[Y]]></ISDELETEABLE> +<!--CB391C8A13D74B688A34017B5B5D1F5D--> <ISDELETEABLE><![CDATA[N]]></ISDELETEABLE> <!--CB391C8A13D74B688A34017B5B5D1F5D--> <ISHIGHVOLUME><![CDATA[N]]></ISHIGHVOLUME> <!--CB391C8A13D74B688A34017B5B5D1F5D--> <IMPORTTABLE><![CDATA[N]]></IMPORTTABLE> <!--CB391C8A13D74B688A34017B5B5D1F5D--> <ISCHANGELOG><![CDATA[N]]></ISCHANGELOG> ------------------------------------------------------------------------------ Download new Adobe(R) Flash(R) Builder(TM) 4 The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly Flex(R) Builder(TM)) enable the development of rich applications that run across multiple browsers and platforms. Download your free trials today! http://p.sf.net/sfu/adobe-dev2dev _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
