[pi-code-cleaning] The ad_shortname function has been deleted.
authorNaroa Iriarte <naroa.iriarte@openbravo.com>
Tue, 26 Apr 2016 10:02:19 +0200
changeset 29512 3c47e21dd299
parent 29511 d2d6ca1c7132
child 29513 b29f33019549
[pi-code-cleaning] The ad_shortname function has been deleted.

The ad_shortname function was not working properly, so it has been deleted.
src-db/database/model/functions/AD_SHORTNAME.xml
src-wad/src/org/openbravo/wad/Tabs_data.xsql
src/org/openbravo/erpCommon/businessUtility/AuditTrailPopup_data.xsql
--- a/src-db/database/model/functions/AD_SHORTNAME.xml	Mon Apr 25 17:54:17 2016 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,42 +0,0 @@
-<?xml version="1.0"?>
-  <database name="FUNCTION AD_SHORTNAME">
-    <function name="AD_SHORTNAME" type="NVARCHAR">
-      <parameter name="p_name" type="NVARCHAR" mode="in">
-        <default/>
-      </parameter>
-      <body><![CDATA[/*************************************************************************
-* The contents of this file are subject to the Openbravo  Public  License
-* Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
-* Version 1.1  with a permitted attribution clause; you may not  use this
-* file except in compliance with the License. You  may  obtain  a copy of
-* the License at http://www.openbravo.com/legal/license.html
-* Software distributed under the License  is  distributed  on  an "AS IS"
-* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
-* License for the specific  language  governing  rights  and  limitations
-* under the License.
-* The Original Code is Openbravo ERP.
-* The Initial Developer of the Original Code is Openbravo SLU
-* All portions are Copyright (C) 2001-2006 Openbravo SLU
-* All Rights Reserved.
-* Contributor(s):  ______________________________________.
-************************************************************************/
-/*************************************************************************
-* Title: AD_ShortName
-************************************************************************/
-  v_RetValue NVARCHAR2(2000) ;
-  v_pos NUMBER:=1;
-BEGIN
-  v_RetValue:=SUBSTR(p_Name, 1, 1) ;
-  WHILE(INSTR(REPLACE(p_Name, '.', ' '), ' ', v_pos+1) > 0)
-  LOOP
-    v_pos:=INSTR(REPLACE(p_Name, '.', ' '), ' ', v_pos+1) ;
-    v_RetValue:=v_RetValue || SUBSTR(p_Name, v_pos+1, 1) ;
-  END LOOP;
-  RETURN v_RetValue;
-EXCEPTION
-WHEN OTHERS THEN
-  RETURN TO_CHAR(v_pos) ;
-END AD_SHORTNAME
-]]></body>
-    </function>
-  </database>
--- a/src-wad/src/org/openbravo/wad/Tabs_data.xsql	Mon Apr 25 17:54:17 2016 +0200
+++ b/src-wad/src/org/openbravo/wad/Tabs_data.xsql	Tue Apr 26 10:02:19 2016 +0200
@@ -295,7 +295,7 @@
         WHERE AD_TABLE.ad_table_id = AD_COLUMN.ad_table_id 
         AND iskey='Y' 
         AND AD_TABLE.ad_table_id = a2.ad_table_id) AS KEY, '' AS href, '' AS Td_Height, 
-        COALESCE(a1.ad_tab_id,'-1') AS Parent_Key, a2.isInfoTab, a2.isTranslationTab, AD_ShortName(a2.Name) as NameTab, 
+        COALESCE(a1.ad_tab_id,'-1') AS Parent_Key, a2.isInfoTab, a2.isTranslationTab, 
         a2.EDITREFERENCE, a2.AD_MODULE_ID as tabmodule
         FROM AD_TAB a1, AD_TAB a2
         WHERE a1.ad_tab_id = ?
--- a/src/org/openbravo/erpCommon/businessUtility/AuditTrailPopup_data.xsql	Mon Apr 25 17:54:17 2016 +0200
+++ b/src/org/openbravo/erpCommon/businessUtility/AuditTrailPopup_data.xsql	Tue Apr 26 10:02:19 2016 +0200
@@ -127,7 +127,7 @@
         WHERE AD_TABLE.ad_table_id = AD_COLUMN.ad_table_id 
         AND iskey='Y' 
         AND AD_TABLE.ad_table_id = a2.ad_table_id) AS KEY, '' AS href, '' AS Td_Height, 
-        COALESCE(a1.ad_tab_id,'-1') AS Parent_Key, a2.isInfoTab, a2.isTranslationTab, AD_ShortName(a2.Name) as NameTab, 
+        COALESCE(a1.ad_tab_id,'-1') AS Parent_Key, a2.isInfoTab, a2.isTranslationTab,
         a2.EDITREFERENCE, a2.AD_MODULE_ID as tabmodule
         FROM AD_TAB a1, AD_TAB a2
         WHERE a1.ad_tab_id = ?