Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0041977 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| feature request | [Openbravo ERP] A. Platform | major | have not tried | 2019-10-10 09:55 | 2019-12-12 23:01 | |||
| Reporter | aferraz | View Status | public | |||||
| Assigned To | cberner | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0PR20Q1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | f20c0d75e5e4 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | AugustoMauch | |||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0041977: Allow subqueries in Log Clean Up Configuration hql where clause | |||||||
| Description | Allow subqueries in Log Clean Up Configuration hql where clause | |||||||
| Steps To Reproduce | As System Admin, create a record in Log Clean Up Configuration window. Add a subquery in the where clause pointing to a column of the log table: exists (select 1 from entity where entity.property.id = e.id) Run Log Clean Up Process process in Process Request window. Realize an error is thrown because "e" alias is not added to log table. | |||||||
| Proposed Solution | Attached proposed fix | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  41977.diff [^] (1,144 bytes) 2019-10-10 09:58 [Show Content]
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0115953) hgbot (developer) 2019-11-28 16:28 |
Repository: erp/devel/pi Changeset: f20c0d75e5e400cfca64e9674b23025deb68910d Author: Cristian Berner <cristian.berner <at> openbravo.com> Date: Wed Nov 20 17:29:27 2019 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/f20c0d75e5e400cfca64e9674b23025deb68910d [^] Fixes issue 41977: Allows subqueries in Log Clean Up Configuration hql clause A new column and field has been added to OBULOG_CONFIG and Log Clean Up Configuration respectively. This "Entity Alias" column and field sets the alias that will be used to reference the main table in the hql where clause. By default it is empty. --- M modules/org.openbravo.utility.cleanup.log/src-db/database/model/tables/OBULOG_CONFIG.xml M modules/org.openbravo.utility.cleanup.log/src-db/database/sourcedata/AD_COLUMN.xml M modules/org.openbravo.utility.cleanup.log/src-db/database/sourcedata/AD_ELEMENT.xml M modules/org.openbravo.utility.cleanup.log/src-db/database/sourcedata/AD_FIELD.xml M modules/org.openbravo.utility.cleanup.log/src/org/openbravo/utility/cleanup/log/CleanEntity.java --- |
|
(0115964) AugustoMauch (administrator) 2019-11-28 19:25 |
Code reviewed and verified |
|
(0116292) hudsonbot (viewer) 2019-12-12 23:01 |
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/954d2b7a66fb [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2019-10-10 09:55 | aferraz | New Issue | |
| 2019-10-10 09:55 | aferraz | Assigned To | => platform |
| 2019-10-10 09:55 | aferraz | OBNetwork customer | => No |
| 2019-10-10 09:55 | aferraz | Modules | => Core |
| 2019-10-10 09:55 | aferraz | Triggers an Emergency Pack | => No |
| 2019-10-10 09:57 | aferraz | Steps to Reproduce Updated | View Revisions |
| 2019-10-10 09:58 | aferraz | File Added: 41977.diff | |
| 2019-11-21 09:39 | cberner | Assigned To | platform => cberner |
| 2019-11-21 09:39 | cberner | Status | new => scheduled |
| 2019-11-21 09:39 | cberner | Review Assigned To | => AugustoMauch |
| 2019-11-28 16:28 | hgbot | Checkin | |
| 2019-11-28 16:28 | hgbot | Note Added: 0115953 | |
| 2019-11-28 16:28 | hgbot | Status | scheduled => resolved |
| 2019-11-28 16:28 | hgbot | Resolution | open => fixed |
| 2019-11-28 16:28 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/f20c0d75e5e400cfca64e9674b23025deb68910d [^] |
| 2019-11-28 19:25 | AugustoMauch | Note Added: 0115964 | |
| 2019-11-28 19:25 | AugustoMauch | Status | resolved => closed |
| 2019-11-28 19:26 | AugustoMauch | Fixed in Version | => 3.0PR20Q1 |
| 2019-12-12 23:01 | hudsonbot | Checkin | |
| 2019-12-12 23:01 | hudsonbot | Note Added: 0116292 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |