Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018683Openbravo ERP01. General setuppublic2011-10-04 09:362011-10-18 09:49
Reporterjecharri 
Assigned Toegoitz 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP33.1 
Target Version2.50MP35Fixed in Version2.50MP35 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browserGoogle Chrome
ModulesCore
Support ticket12716
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018683: The trigger asociated to alert creation is not working properly
DescriptionIf you create an alert, automatically System Role is added to alert recipient.
And you can not delete it.
Steps To ReproduceCreate an alert and go to tab alert recipient.
Proposed SolutionChange the trigger AD_ALERTRULE_TRG.xml
Line:

--insert permissions
      FOR Cur_Role in (SELECT DISTINCT AD_Role_ID, AD_CLIENT_ID, AD_ORG_ID
      FROM AD_Role
      WHERE isManual='N') loop
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00186823.0MP5 closed egoitz The trigger asociated to alert creation is not working properly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-10-04 09:36jecharriTypedefect => backport
2011-10-04 09:36jecharrifix_in_branch => 2.50
2011-10-04 09:36jecharriWeb browserGoogle Chrome => Google Chrome
2011-10-04 09:36jecharriversionpi => 2.50MP33.1
2011-10-04 09:36jecharriTarget Version3.0MP5 => 2.50MP35
2011-10-04 10:44jonalegriaesarteAssigned Tojonalegriaesarte => ioritzCia
2011-10-13 12:37egoitzWeb browserGoogle Chrome => Google Chrome
2011-10-13 12:37egoitzAssigned ToioritzCia => egoitz
2011-10-13 13:22hgbotCheckin
2011-10-13 13:22hgbotNote Added: 0041797
2011-10-13 13:22hgbotStatusscheduled => resolved
2011-10-13 13:22hgbotResolutionopen => fixed
2011-10-13 13:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/ca6ddcd6f1e338af7523b393b4146c5afcdcb2cb [^]
2011-10-18 09:49jecharriNote Added: 0041874
2011-10-18 09:49jecharriStatusresolved => closed
2011-10-18 09:49jecharriFixed in Version => 2.50MP35

Notes
(0041797)
hgbot   
2011-10-13 13:22   
Repository: erp/stable/2.50
Changeset: ca6ddcd6f1e338af7523b393b4146c5afcdcb2cb
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Thu Oct 13 12:27:55 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/ca6ddcd6f1e338af7523b393b4146c5afcdcb2cb [^]

Fixed Issue 18683. The trigger on alertrule not working properly

---
M src-db/database/model/triggers/AD_ALERTRULE_TRG.xml
---
(0041874)
jecharri   
2011-10-18 09:49   
Verified