[OpenbravoERP-commits] devel/pi: Fixes issue 0018682: The trigger asociated to alert cr...

[hg]

details:   https://code.openbravo.com/erp/devel/pi/rev/3a6f19206961
changeset: 14034:3a6f19206961
user:      Jon Alegría <jon.alegria <at> openbravo.com>
date:      Thu Oct 20 11:40:23 2011 +0200
summary:   Fixes issue 0018682: The trigger asociated to alert creation is not 
working
properly

diffstat:

 src-db/database/model/triggers/AD_ALERTRULE_TRG.xml |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r 65a62d9914b0 -r 3a6f19206961 
src-db/database/model/triggers/AD_ALERTRULE_TRG.xml
--- a/src-db/database/model/triggers/AD_ALERTRULE_TRG.xml       Thu Oct 20 
11:27:56 2011 +0200
+++ b/src-db/database/model/triggers/AD_ALERTRULE_TRG.xml       Thu Oct 20 
11:40:23 2011 +0200
@@ -55,7 +55,7 @@
       --insert permissions
       FOR Cur_Role in (SELECT DISTINCT AD_Role_ID, AD_CLIENT_ID, AD_ORG_ID
                         FROM AD_Role
-                       WHERE isManual='N') loop
+                       WHERE isManual='N' and 
ad_role.ad_client_id=:new.AD_Client_ID) loop
         Ad_Sequence_Next('AD_AlertRecipient', Cur_Role.AD_Org_Id, 
recipient_id) ;
         INSERT INTO AD_AlertRecipient
             (AD_AlertRule_ID, AD_Role_ID, AD_Client_ID,

------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Ciosco Self-Assessment and learn 
about Cisco certifications, training, and career opportunities. 
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits