details: https://code.openbravo.com/erp/devel/pi/rev/2127be3203c0
changeset: 20458:2127be3203c0
user: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
date: Thu May 23 14:05:03 2013 +0530
summary: Fixes Issue 0023883 : At least one field should be visible in grid
view
Added trigger logic for ad_field to check if at least one field is visible in
grid.
If there are no fields visible in grid view, the view is stuck with loading
screen.
diffstat:
src-db/database/model/triggers/AD_FIELD_TRG.xml | 16 ++++++++++++++--
src-db/database/sourcedata/AD_MESSAGE.xml | 13 +++++++++++++
2 files changed, 27 insertions(+), 2 deletions(-)
diffs (61 lines):
diff -r 57b9468a475f -r 2127be3203c0
src-db/database/model/triggers/AD_FIELD_TRG.xml
--- a/src-db/database/model/triggers/AD_FIELD_TRG.xml Tue May 21 12:05:37
2013 +0200
+++ b/src-db/database/model/triggers/AD_FIELD_TRG.xml Thu May 23 14:05:03
2013 +0530
@@ -17,7 +17,7 @@
* parts created by ComPiere are Copyright (C) ComPiere, Inc.;
* All Rights Reserved.
* Contributor(s): Openbravo SLU
- * Contributions are Copyright (C) 2001-2008 Openbravo, S.L.U.
+ * Contributions are Copyright (C) 2001-2013 Openbravo, S.L.U.
*
* Specifically, this derivative work is based upon the following Compiere
* file and version.
@@ -25,12 +25,24 @@
* Insert AD_Field Trigger
* for Translation
*/
-
+ v_Count NUMBER;
BEGIN
IF AD_isTriggerEnabled()='N' THEN RETURN;
END IF;
+ IF INSERTING OR UPDATING THEN
+ SELECT
+ COUNT(AD_Field_ID)
+ INTO v_Count
+ FROM AD_Field
+ WHERE AD_Tab_ID=:NEW.AD_Tab_ID
+ AND showinrelation = 'Y';
+ IF v_Count = 0 THEN
+ RAISE_APPLICATION_ERROR(-20000,'@NOFIELDSINGRIDVIEW@');
+ END IF;
+ END IF;
+
IF INSERTING
THEN
INSERT
diff -r 57b9468a475f -r 2127be3203c0 src-db/database/sourcedata/AD_MESSAGE.xml
--- a/src-db/database/sourcedata/AD_MESSAGE.xml Tue May 21 12:05:37 2013 +0200
+++ b/src-db/database/sourcedata/AD_MESSAGE.xml Thu May 23 14:05:03 2013 +0530
@@ -18513,6 +18513,19 @@
<!--4C38766399D14E4C96A65E71A5D85F06-->
<ISINCLUDEINI18N><![CDATA[N]]></ISINCLUDEINI18N>
<!--4C38766399D14E4C96A65E71A5D85F06--></AD_MESSAGE>
+<!--4CC7E267B67E4D4A95D9D1F204ED3DAB--><AD_MESSAGE>
+<!--4CC7E267B67E4D4A95D9D1F204ED3DAB-->
<AD_MESSAGE_ID><![CDATA[4CC7E267B67E4D4A95D9D1F204ED3DAB]]></AD_MESSAGE_ID>
+<!--4CC7E267B67E4D4A95D9D1F204ED3DAB-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--4CC7E267B67E4D4A95D9D1F204ED3DAB--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--4CC7E267B67E4D4A95D9D1F204ED3DAB--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--4CC7E267B67E4D4A95D9D1F204ED3DAB-->
<VALUE><![CDATA[NOFIELDSINGRIDVIEW]]></VALUE>
+<!--4CC7E267B67E4D4A95D9D1F204ED3DAB--> <MSGTEXT><![CDATA[At least one field
should be visible in grid view]]></MSGTEXT>
+<!--4CC7E267B67E4D4A95D9D1F204ED3DAB--> <MSGTIP><![CDATA[At least one field
should be visible in grid view]]></MSGTIP>
+<!--4CC7E267B67E4D4A95D9D1F204ED3DAB--> <MSGTYPE><![CDATA[E]]></MSGTYPE>
+<!--4CC7E267B67E4D4A95D9D1F204ED3DAB-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--4CC7E267B67E4D4A95D9D1F204ED3DAB-->
<ISINCLUDEINI18N><![CDATA[N]]></ISINCLUDEINI18N>
+<!--4CC7E267B67E4D4A95D9D1F204ED3DAB--></AD_MESSAGE>
+
<!--4CF1C7DF273F433588F83262FC54A414--><AD_MESSAGE>
<!--4CF1C7DF273F433588F83262FC54A414-->
<AD_MESSAGE_ID><![CDATA[4CF1C7DF273F433588F83262FC54A414]]></AD_MESSAGE_ID>
<!--4CF1C7DF273F433588F83262FC54A414-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
