Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0018681

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

backport

[Openbravo ERP] 01. General setup

major

always

2011-10-04 09:26

2011-10-18 10:26

Reporter

jecharri

View Status

public

Assigned To

egoitz

Priority

urgent

Resolution

fixed

Fixed in Version

2.50MP35

Status

closed

Fix in branch

2.50

Fixed in SCM revision

Projection

none

ETA

none

Target Version

2.50MP35

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

2.50MP33.1

SCM revision

Review Assigned To

Web browser

Google Chrome

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

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

Description

Alert 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 Reproduce

Create 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 Solution

In file AlertProcess_data.xsql delete the line:

and ar.ad_client_id = u.ad_client_id

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

3.0MP5

closed

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

Notes
(0041798) hgbot (developer) 2011-10-13 13:22	Repository: erp/stable/2.50 Changeset: 0cf9c43e77d8a4c782b5312d78b66e3caf184f4f Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com> Date: Thu Oct 13 12:29:27 2011 +0200 URL: http://code.openbravo.com/erp/stable/2.50/rev/0cf9c43e77d8a4c782b5312d78b66e3caf184f4f [^] Fixed Issue 18681. Alerts by mail work different defining role or user --- M src/org/openbravo/erpCommon/ad_process/AlertProcess_data.xsql ---

(0041875) jecharri (developer) 2011-10-18 10:26	verified

Issue History
Date Modified	Username	Field	Change
2011-10-04 09:28	jecharri	Type	defect => backport
2011-10-04 09:28	jecharri	fix_in_branch	=> 2.50
2011-10-04 09:28	jecharri	Web browser	Google Chrome => Google Chrome
2011-10-04 09:28	jecharri	version	pi => 2.50MP33.1
2011-10-04 09:28	jecharri	Target Version	3.0MP5 => 2.50MP35
2011-10-04 10:43	jonalegriaesarte	Assigned To	jonalegriaesarte => ioritzCia
2011-10-13 12:38	egoitz	Web browser	Google Chrome => Google Chrome
2011-10-13 12:38	egoitz	Assigned To	ioritzCia => egoitz
2011-10-13 13:22	hgbot	Checkin
2011-10-13 13:22	hgbot	Note Added: 0041798
2011-10-13 13:22	hgbot	Status	scheduled => resolved
2011-10-13 13:22	hgbot	Resolution	open => fixed
2011-10-13 13:22	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.50/rev/0cf9c43e77d8a4c782b5312d78b66e3caf184f4f [^]
2011-10-18 10:26	jecharri	Note Added: 0041875
2011-10-18 10:26	jecharri	Status	resolved => closed
2011-10-18 10:26	jecharri	Fixed in Version	=> 2.50MP35

Copyright © 2000 - 2009 MantisBT Group