Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0031719 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| design defect | [Openbravo ERP] A. Platform | major | have not tried | 2015-12-15 13:02 | 2022-02-01 08:09 | |||||||
| Reporter | egoitz | View Status | public | |||||||||
| Assigned To | Triage Platform Base | |||||||||||
| Priority | high | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0031719: Alerts should take into account the client and the org of the alert definition | |||||||||||
| Description | Right now the sql alert executed for the alerts does not include the client or organization whre the alert is defined. that means that the query can return elements of other organizations or clients. The process should add the client and org on the where clause of the query executed. | |||||||||||
| Steps To Reproduce | Check on the selectAlert method of the AlertProcess.java file that the query is executed on that way without adding filters for organzation or client: String strSql = "SELECT * FROM (" + alertRuleSQL + ") AAA where not exists (" + "select 1 from ad_alert a where a.ad_alertrule_id = ? " + "and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED')"; | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-12-15 13:02 | egoitz | New Issue | |
| 2015-12-15 13:02 | egoitz | Assigned To | => platform |
| 2015-12-15 13:02 | egoitz | Modules | => Core |
| 2015-12-15 13:02 | egoitz | Triggers an Emergency Pack | => No |
| 2022-02-01 08:09 | alostale | Assigned To | platform => Triage Platform Base |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |