Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0018680
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupmajoralways2011-10-04 09:262011-10-25 16:51
ReporterjecharriView Statuspublic 
Assigned Toegoitz 
PriorityurgentResolutionfixedFixed in Version3.0MP5
StatusclosedFix in branchpiFixed in SCM revision65a62d9914b0
ProjectionnoneETAnoneTarget Version3.0MP5
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018680: Alert recipient work different when you put only the role or user

DescriptionAlert recipient work different when you put only the role or user.
When you put the role with the same client to the alert, all the user with this role receive an email (with the check of Send Email checked obiusly), it doesn't matter if the users are from different client.
But if you put an user and this user is from different client to the alert definition, this user doesn't receive any mail.
Steps To ReproduceCreate an alert:
-SQL:select c_invoice_id as referencekey_id,
       '0' as ad_role_id,
       null as ad_user_id,
       'esto es una prueba' as description,
       'Y' as isActive,
        ad_org_id,
        ad_client_id,
        now() as created,
        '0' as createdBy,
        now() as updated,
        '0' as updatedBy,
        ad_column_identifier('C_invoice', C_invoice_id, 'es_ES') AS RECORD_ID, posted
   FROM C_invoice
GROUP BY C_invoice_id, posted, ad_client_id, ad_org_id
order by c_invoice_id desc limit 2

Go to tab alert recipient and select Openbravo Admin.
Check the checkbox Send Email.
Execute the alert background porcess
See that all user of this role receive an email.
Now put Openbravo user like end user.
Run alert Process
You will not receive any mail.
Proposed SolutionIn file AlertProcess_data.xsql delete the line:

and ar.ad_client_id = u.ad_client_id
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 00186812.50MP35 closedegoitz Alert recipient work different when you put only the role or user 

-  Notes
(0041948)
hgbot (developer)
2011-10-20 11:30

 Repository: erp/devel/pi
Changeset: 65a62d9914b03ddbaccfae493edd2de7750a628d
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Thu Oct 20 11:27:56 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/65a62d9914b03ddbaccfae493edd2de7750a628d [^]

Fixes issue 0018680: Alert recipient work different when you put only the role
or user

---
M src/org/openbravo/erpCommon/ad_process/AlertProcess_data.xsql
---
(0042026)
hudsonbot (developer)
2011-10-23 13:42

 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/35bf0a7aa166 [^]

Maturity status: Test
(0042096)
jecharri (developer)
2011-10-25 16:51

 Verified

- Issue History
Date Modified Username Field Change
2011-10-04 09:26 jecharri New Issue
2011-10-04 09:26 jecharri Assigned To => jonalegriaesarte
2011-10-04 09:26 jecharri Web browser => Google Chrome
2011-10-04 09:26 jecharri Modules => Core
2011-10-04 09:26 jecharri Resolution time => 1320447600
2011-10-04 09:28 jecharri Web browser Google Chrome => Google Chrome
2011-10-04 09:28 jecharri Description Updated View Revisions
2011-10-04 09:28 jecharri Steps to Reproduce Updated View Revisions
2011-10-04 09:28 jecharri Status new => scheduled
2011-10-04 09:28 jecharri fix_in_branch => pi
2011-10-19 09:13 jonalegriaesarte Assigned To jonalegriaesarte => egoitz
2011-10-20 11:30 hgbot Checkin
2011-10-20 11:30 hgbot Note Added: 0041948
2011-10-20 11:30 hgbot Status scheduled => resolved
2011-10-20 11:30 hgbot Resolution open => fixed
2011-10-20 11:30 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/65a62d9914b03ddbaccfae493edd2de7750a628d [^]
2011-10-23 13:42 hudsonbot Checkin
2011-10-23 13:42 hudsonbot Note Added: 0042026
2011-10-25 16:51 jecharri Note Added: 0042096
2011-10-25 16:51 jecharri Status resolved => closed
2011-10-25 16:51 jecharri Fixed in Version => 3.0MP5

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker