Fixed issue 11165.Added seqno column to order extencion point procedures by seqno and procedure name.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Mon, 01 Aug 2011 10:48:28 +0200
changeset 13352 6c17f2c86473
parent 13351 ed0b8ba5a684
child 13353 2e0d9e89d2af
Fixed issue 11165.Added seqno column to order extencion point procedures by seqno and procedure name.
src-db/database/model/functions/AD_EXTENSION_POINT_HANDLER.xml
src-db/database/model/tables/AD_EP_PROCEDURES.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/model/functions/AD_EXTENSION_POINT_HANDLER.xml	Fri Jul 29 16:51:04 2011 +0200
+++ b/src-db/database/model/functions/AD_EXTENSION_POINT_HANDLER.xml	Mon Aug 01 10:48:28 2011 +0200
@@ -32,7 +32,8 @@
     SELECT lower(PROCEDURENAME) AS procedurename
     FROM ad_ep_procedures
     WHERE ad_extension_points_id = p_extension_point_id
-      AND isactive = 'Y') LOOP
+      AND isactive = 'Y'
+    ORDER BY coalesce(seqno, 9999), procedurename) LOOP
     IF (AD_GET_RDBMS() = 'ORACLE') THEN
       v_Sql := 'CALL ' || Cur_Procedures.procedurename || '('''||p_ep_instance_id||''')';
     ELSE
--- a/src-db/database/model/tables/AD_EP_PROCEDURES.xml	Fri Jul 29 16:51:04 2011 +0200
+++ b/src-db/database/model/tables/AD_EP_PROCEDURES.xml	Mon Aug 01 10:48:28 2011 +0200
@@ -45,6 +45,10 @@
         <default/>
         <onCreateDefault/>
       </column>
+      <column name="SEQNO" primaryKey="false" required="false" type="DECIMAL" size="10,0" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_CLIENT" name="AD_CLIENT_ADEPPROCEDURES">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Fri Jul 29 16:51:04 2011 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Mon Aug 01 10:48:28 2011 +0200
@@ -258399,6 +258399,39 @@
 <!--A908EA6CF218F9C9E040007F01011582-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--A908EA6CF218F9C9E040007F01011582--></AD_COLUMN>
 
+<!--A922616DBC269336E040007F010007F3--><AD_COLUMN>
+<!--A922616DBC269336E040007F010007F3-->  <AD_COLUMN_ID><![CDATA[A922616DBC269336E040007F010007F3]]></AD_COLUMN_ID>
+<!--A922616DBC269336E040007F010007F3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A922616DBC269336E040007F010007F3-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A922616DBC269336E040007F010007F3-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A922616DBC269336E040007F010007F3-->  <NAME><![CDATA[Sequence Number]]></NAME>
+<!--A922616DBC269336E040007F010007F3-->  <DESCRIPTION><![CDATA[The order of records in a specified document.]]></DESCRIPTION>
+<!--A922616DBC269336E040007F010007F3-->  <HELP><![CDATA[The Sequence indicates the order of records]]></HELP>
+<!--A922616DBC269336E040007F010007F3-->  <COLUMNNAME><![CDATA[SeqNo]]></COLUMNNAME>
+<!--A922616DBC269336E040007F010007F3-->  <AD_TABLE_ID><![CDATA[D82A7D094F51425BB4475C223A572B2A]]></AD_TABLE_ID>
+<!--A922616DBC269336E040007F010007F3-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
+<!--A922616DBC269336E040007F010007F3-->  <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
+<!--A922616DBC269336E040007F010007F3-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--A922616DBC269336E040007F010007F3-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--A922616DBC269336E040007F010007F3-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--A922616DBC269336E040007F010007F3-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--A922616DBC269336E040007F010007F3-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--A922616DBC269336E040007F010007F3-->  <SEQNO><![CDATA[120]]></SEQNO>
+<!--A922616DBC269336E040007F010007F3-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--A922616DBC269336E040007F010007F3-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--A922616DBC269336E040007F010007F3-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--A922616DBC269336E040007F010007F3-->  <AD_ELEMENT_ID><![CDATA[566]]></AD_ELEMENT_ID>
+<!--A922616DBC269336E040007F010007F3-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--A922616DBC269336E040007F010007F3-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--A922616DBC269336E040007F010007F3-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--A922616DBC269336E040007F010007F3-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--A922616DBC269336E040007F010007F3-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--A922616DBC269336E040007F010007F3-->  <POSITION><![CDATA[12]]></POSITION>
+<!--A922616DBC269336E040007F010007F3-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--A922616DBC269336E040007F010007F3-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--A922616DBC269336E040007F010007F3-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--A922616DBC269336E040007F010007F3--></AD_COLUMN>
+
 <!--A9AD9098307E46ECBB9CC712DA6E0302--><AD_COLUMN>
 <!--A9AD9098307E46ECBB9CC712DA6E0302-->  <AD_COLUMN_ID><![CDATA[A9AD9098307E46ECBB9CC712DA6E0302]]></AD_COLUMN_ID>
 <!--A9AD9098307E46ECBB9CC712DA6E0302-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Fri Jul 29 16:51:04 2011 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Mon Aug 01 10:48:28 2011 +0200
@@ -177151,6 +177151,7 @@
 <!--6F387D3737F03635E040007F01002312-->  <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
 <!--6F387D3737F03635E040007F01002312-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--6F387D3737F03635E040007F01002312-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--6F387D3737F03635E040007F01002312-->  <SORTNO><![CDATA[2]]></SORTNO>
 <!--6F387D3737F03635E040007F01002312-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--6F387D3737F03635E040007F01002312-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--6F387D3737F03635E040007F01002312-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -189488,6 +189489,33 @@
 <!--A908E57D081C6863E040007F01011588-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--A908E57D081C6863E040007F01011588--></AD_FIELD>
 
+<!--A922616DBC299336E040007F010007F3--><AD_FIELD>
+<!--A922616DBC299336E040007F010007F3-->  <AD_FIELD_ID><![CDATA[A922616DBC299336E040007F010007F3]]></AD_FIELD_ID>
+<!--A922616DBC299336E040007F010007F3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A922616DBC299336E040007F010007F3-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A922616DBC299336E040007F010007F3-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A922616DBC299336E040007F010007F3-->  <NAME><![CDATA[Sequence Number]]></NAME>
+<!--A922616DBC299336E040007F010007F3-->  <DESCRIPTION><![CDATA[The order of records in a specified document.]]></DESCRIPTION>
+<!--A922616DBC299336E040007F010007F3-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--A922616DBC299336E040007F010007F3-->  <AD_TAB_ID><![CDATA[D88DE0446AFD4A55BF850C5B75CD7974]]></AD_TAB_ID>
+<!--A922616DBC299336E040007F010007F3-->  <AD_COLUMN_ID><![CDATA[A922616DBC269336E040007F010007F3]]></AD_COLUMN_ID>
+<!--A922616DBC299336E040007F010007F3-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--A922616DBC299336E040007F010007F3-->  <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
+<!--A922616DBC299336E040007F010007F3-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--A922616DBC299336E040007F010007F3-->  <SEQNO><![CDATA[25]]></SEQNO>
+<!--A922616DBC299336E040007F010007F3-->  <SORTNO><![CDATA[1]]></SORTNO>
+<!--A922616DBC299336E040007F010007F3-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--A922616DBC299336E040007F010007F3-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--A922616DBC299336E040007F010007F3-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--A922616DBC299336E040007F010007F3-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--A922616DBC299336E040007F010007F3-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--A922616DBC299336E040007F010007F3-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--A922616DBC299336E040007F010007F3-->  <GRID_SEQNO><![CDATA[25]]></GRID_SEQNO>
+<!--A922616DBC299336E040007F010007F3-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--A922616DBC299336E040007F010007F3-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--A922616DBC299336E040007F010007F3-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--A922616DBC299336E040007F010007F3--></AD_FIELD>
+
 <!--AA66A55E4B9340D9A67FA5E47560B758--><AD_FIELD>
 <!--AA66A55E4B9340D9A67FA5E47560B758-->  <AD_FIELD_ID><![CDATA[AA66A55E4B9340D9A67FA5E47560B758]]></AD_FIELD_ID>
 <!--AA66A55E4B9340D9A67FA5E47560B758-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>