Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041977Openbravo ERPA. Platformpublic2019-10-10 09:552019-12-12 23:01
Reporteraferraz 
Assigned Tocberner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR20Q1 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0041977: Allow subqueries in Log Clean Up Configuration hql where clause
DescriptionAllow subqueries in Log Clean Up Configuration hql where clause
Steps To ReproduceAs 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 SolutionAttached proposed fix
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff 41977.diff (1,144) 2019-10-10 09:58
https://issues.openbravo.com/file_download.php?file_id=13367&type=bug
Issue History
Date ModifiedUsernameFieldChange
2019-10-10 09:55aferrazNew Issue
2019-10-10 09:55aferrazAssigned To => platform
2019-10-10 09:55aferrazOBNetwork customer => No
2019-10-10 09:55aferrazModules => Core
2019-10-10 09:55aferrazTriggers an Emergency Pack => No
2019-10-10 09:57aferrazSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=19458#r19458
2019-10-10 09:58aferrazFile Added: 41977.diff
2019-11-21 09:39cbernerAssigned Toplatform => cberner
2019-11-21 09:39cbernerStatusnew => scheduled
2019-11-21 09:39cbernerReview Assigned To => AugustoMauch
2019-11-28 16:28hgbotCheckin
2019-11-28 16:28hgbotNote Added: 0115953
2019-11-28 16:28hgbotStatusscheduled => resolved
2019-11-28 16:28hgbotResolutionopen => fixed
2019-11-28 16:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f20c0d75e5e400cfca64e9674b23025deb68910d [^]
2019-11-28 19:25AugustoMauchNote Added: 0115964
2019-11-28 19:25AugustoMauchStatusresolved => closed
2019-11-28 19:26AugustoMauchFixed in Version => 3.0PR20Q1
2019-12-12 23:01hudsonbotCheckin
2019-12-12 23:01hudsonbotNote Added: 0116292

Notes
(0115953)
hgbot   
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   
2019-11-28 19:25   
Code reviewed and verified
(0116292)
hudsonbot   
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