[wildfly] don't include in web.xml standard ui processes
authorAsier Lostalé <asier.lostale@openbravo.com>
Tue, 06 Sep 2016 13:31:54 +0200
changeset 30419 89f0eb718711
parent 30418 ee2cadcd63f1
child 30420 bc852d0e4d97
[wildfly] don't include in web.xml standard ui processes

The process class desn not implement Servlet.
src-wad/src/org/openbravo/wad/Wad_data.xsql
--- a/src-wad/src/org/openbravo/wad/Wad_data.xsql	Tue Sep 06 10:20:41 2016 +0200
+++ b/src-wad/src/org/openbravo/wad/Wad_data.xsql	Tue Sep 06 13:31:54 2016 +0200
@@ -12,7 +12,7 @@
  * 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-2012 Openbravo SLU 
+ * All portions are Copyright (C) 2001-2016 Openbravo SLU 
  * All Rights Reserved. 
  * Contributor(s):  ______________________________________.
  ************************************************************************
@@ -25,14 +25,15 @@
     <SqlMethodComment>Names of the columns of the fields of a tab</SqlMethodComment>
     <Sql>
       <![CDATA[
-      SELECT AD_MODEL_OBJECT_ID as ID, (COALESCE(ACTION, '') || AD_MODEL_OBJECT_ID) AS NAME, CLASSNAME, CLASSNAME AS DISPLAYNAME, 
+      SELECT AD_MODEL_OBJECT_ID as ID, (COALESCE(ACTION, '') || AD_MODEL_OBJECT_ID) AS NAME, o.CLASSNAME, o.CLASSNAME AS DISPLAYNAME, 
       LOADONSTARTUP, '' AS VALUE, '' AS LINE, '' AS AUTH, '' as buildxml, 
-	  '' as tabId, '' as windowName, '' as tabName, '' as windowPackage, '' as windowmodule, '' as tabPackage, '' as tabmodule,
-	  '' as key, '' as tablevel
-      FROM AD_MODEL_OBJECT o
-      WHERE ISACTIVE = 'Y'
+         '' as tabId, '' as windowName, '' as tabName, '' as windowPackage, '' as windowmodule, '' as tabPackage, '' as tabmodule,
+         '' as key, '' as tablevel
+      FROM AD_MODEL_OBJECT o left join ad_process p on o.ad_process_id = p.ad_process_id and p.isReport='N'
+      WHERE o.ISACTIVE = 'Y'
       AND OBJECT_TYPE = 'S'
       AND ACTION != 'W'
+      and coalesce(p.uiPattern,'M') = 'M'
       ORDER BY NAME
       ]]>
     </Sql>