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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0018680

Openbravo ERP

01. General setup

public

2011-10-04 09:26

2011-10-25 16:51

Reporter

jecharri

Assigned To

egoitz

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

3.0MP5

Fixed in Version

3.0MP5

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Google Chrome

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0018680: 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

Additional Information