Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0036928Openbravo ERPA. Platformpublic2017-09-22 13:222018-01-03 12:38
ReporterJONHM 
Assigned Toinigosanchez 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR18Q1 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0036928: Emails sent by alerts contains information about other entities
DescriptionEmails sent by alerts contains information about other entities. For example when sending by Email an alert within the 'White Valley Group Admin', it also sends information about 'F&B Group Admin'
Steps To Reproduce1) Select 'White Valley Group Admin' role and open 'Client' window. Then select the 'White Valley Group Admin' record and switch to [Email Configuration] tab. Create a new record:
   smtp server: smtp.gmail.com
   smtp server account: your_account@openbravo.com
   smtp server address: your_account@openbravo.com
   password: your_password
   smtp authentication: Y
   smtp connection security: SSL
   smtp port: 465

2) Go to 'User' window and create a new user 'Test':
   On 'more information' set an Email
2.1) Give to the user access to 'The White Valley Group Admin' role

3) Open 'Alert' window and create a new alert the same as explained in the documentation for the client 'The White Valley Group':
http:/3.1) /wiki.openbravo.com/wiki/How_to_create_an_Alert
3.1) Ensures that query return data from the db
3.2) Switch to [Alert Recipient] tab and choose 'The White Valley Group Admin' role. Check on the 'Send Email' checkbox

4) Finally, open 'Process Request' window and create a new record:
   Process: Alert Process
   Timing: Run Immediately
4.1) Press button 'Schedule Process'

--> You will receive an Email with information about every Business Partners of every entities.
Proposed SolutionThe query should be filtered by default for the current client
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0037028 closed Triage Platform Base AlertProcess should be refactored 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-09-22 13:22JONHMNew Issue
2017-09-22 13:22JONHMAssigned To => platform
2017-09-22 13:22JONHMModules => Core
2017-09-22 13:22JONHMResolution time => 1507845600
2017-09-22 13:22JONHMTriggers an Emergency Pack => No
2017-09-22 13:25JONHMSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=15974#r15974
2017-09-22 13:26JONHMSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=15975#r15975
2017-09-26 17:12inigosanchezStatusnew => scheduled
2017-09-26 17:12inigosanchezAssigned Toplatform => inigosanchez
2017-09-27 10:19inigosanchezSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=15999#r15999
2017-09-27 11:01inigosanchezNote Added: 0099624
2017-10-02 15:41inigosanchezNote Added: 0099696
2017-10-02 15:41inigosanchezFile Added: issue36928_18q1.export
2017-10-04 11:33inigosanchezFile Deleted: issue36928_18q1.export
2017-10-04 11:35hgbotCheckin
2017-10-04 11:35hgbotNote Added: 0099760
2017-10-04 11:35hgbotStatusscheduled => resolved
2017-10-04 11:35hgbotResolutionopen => fixed
2017-10-04 11:35hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/968e6fa0746da351117fabfa7882bd42f936736e [^]
2017-10-04 11:37inigosanchezReview Assigned To => alostale
2017-10-06 14:31alostaleNote Added: 0099804
2017-10-06 14:31alostaleStatusresolved => closed
2017-10-06 14:31alostaleFixed in Version => 3.0PR18Q1
2017-10-09 09:19inigosanchezRelationship addedrelated to 0037028
2018-01-03 12:38hudsonbotCheckin
2018-01-03 12:38hudsonbotNote Added: 0101317

Notes
(0099624)
inigosanchez   
2017-09-27 11:01   
Configure Google Account: Allowing less secure apps to access your account -> Allow less secure apps: ON
(0099696)
inigosanchez   
2017-10-02 15:41   
Attached the patch (issue36928_18q1.export) with the fix to be applied for the next release.
(0099760)
hgbot   
2017-10-04 11:35   
Repository: erp/devel/pi
Changeset: 968e6fa0746da351117fabfa7882bd42f936736e
Author: Inigo Sanchez <inigo.sanchez <at> openbravo.com>
Date: Mon Oct 02 15:17:11 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/968e6fa0746da351117fabfa7882bd42f936736e [^]

Fixed bug 36928: Emails sent by alerts contains information about other clients

The problem was that emails sent by alerts contains information about other entities. For example, when sending
an alert by email within the 'White Valley Group Admin' client, it also sends information about 'F&B Group Admin'
client. The generation of the body of the email was filtering by organization but was not filtering by client too.

The problem has been resolved by take into account the client info properly. Now the data used in the generation
of the email is filtering properly.

---
M src/org/openbravo/erpCommon/ad_process/AlertProcess.java
---
(0099804)
alostale   
2017-10-06 14:31   
reviewed + tested
(0101317)
hudsonbot   
2018-01-03 12:38   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c81e0d3cbab5 [^]
Maturity status: Test