Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006492Openbravo ERP01. General setuppublic2008-12-11 16:462009-04-21 11:05
Reporterccasuso 
Assigned Toanthony_wolski 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006492: Send alerts by e-mail
DescriptionIn an alert, in tab 'Alert Recipient' selecting a role and an user, Openbravo sends an email to all users with this role.
Steps To Reproduce1.- Selecting an alert
2.- In tab 'Alert Recipient' selecting a role and an user and marking 'Send Email'
3.- Openbravo sends an email to all users with the selected role (It must sends only an email to the selected user)
Proposed SolutionAt file 'PeriodicAlert_data.xsql', at method 'prepareMails', the clause SQL must be:
           SELECT C.SMTPHOST,
                       REQUESTUSER,
                       REQUESTUSERPW,
                       C.REQUESTEMAIL AS MAILFROM,
                       U.EMAIL AS MAILTO,
                       C.AD_LANGUAGE
                  FROM AD_ALERTRECIPIENT R,
                       AD_USER U,
                       AD_CLIENT C
                 WHERE AD_ALERTRULE_ID = TO_NUMBER(?)
                   AND SENDEMAIL = 'Y'
                   AND R.AD_USER_ID = U.AD_USER_ID
                   AND C.AD_CLIENT_ID = U.AD_CLIENT_ID

instead:

          SELECT C.SMTPHOST,
                 REQUESTUSER,
                 REQUESTUSERPW,
                 C.REQUESTEMAIL AS MAILFROM,
                 U.EMAIL AS MAILTO,
                 C.AD_LANGUAGE
            FROM AD_ALERTRECIPIENT R,
                 AD_USER U,
                 AD_CLIENT C
           WHERE AD_ALERTRULE_ID = TO_NUMBER(?)
             AND SENDEMAIL = 'Y'
             AND R.AD_USER_ID = U.AD_USER_ID
             AND C.AD_CLIENT_ID = U.AD_CLIENT_ID
          union
          SELECT C.SMTPHOST,
                 REQUESTUSER,
                 REQUESTUSERPW,
                 C.REQUESTEMAIL AS MAILFROM,
                 U.EMAIL AS MAILTO,
                 C.AD_LANGUAGE
            FROM AD_ALERTRECIPIENT R,
                 AD_CLIENT C,
                 AD_USER U
           WHERE AD_ALERTRULE_ID = TO_NUMBER(?)
             AND SENDEMAIL = 'Y'
             AND C.AD_CLIENT_ID = U.AD_CLIENT_ID
             and u.ad_user_id in (select ad_user_id
                                    from ad_user_roles ur
                                   where ur.ad_role_id = r.ad_role_id)
  
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0006824 closed anthony_wolski Send alerts by e-mail 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-11 16:46ccasusoNew Issue
2008-12-11 16:46ccasusoAssigned To => rafaroda
2008-12-11 16:46ccasusosf_bug_id0 => 2417462
2008-12-11 16:49mmarquezIssue Monitored: mmarquez
2008-12-11 16:49ccasusoIssue Monitored: ccasuso
2009-01-09 17:31psarobeStatusnew => scheduled
2009-01-09 17:31psarobefix_in_branch => trunk
2009-01-10 18:07rafarodaAssigned Torafaroda => anthony_wolski
2009-01-22 15:43svnbotCheckin
2009-01-22 15:43svnbotNote Added: 0012529
2009-01-22 15:43svnbotStatusscheduled => resolved
2009-01-22 15:43svnbotResolutionopen => fixed
2009-01-22 15:43svnbotsvn_revision => 12160
2009-04-21 11:05psarobeStatusresolved => closed

Notes
(0012529)
svnbot   
2009-01-22 15:43   
Repository: openbravo
Revision: 12160
Author: anthony.wolski
Date: 2009-01-22 15:43:10 +0100 (Thu, 22 Jan 2009)

Fixes issue 0006492. Only select selected users.

---
U trunk/src/org/openbravo/erpCommon/ad_process/AlertProcess_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=12160&sc=1 [^]