Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0031719 | Openbravo ERP | A. Platform | public | 2015-12-15 13:02 | 2022-02-01 08:09 |
| Reporter | egoitz | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | high | Severity | major | Reproducibility | have not tried |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| 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')"; | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| 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 | ||
| There are no notes attached to this issue. |