Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047945Openbravo ERP00. Application dictionarypublic2021-10-28 09:382021-10-29 10:20
Reportercberner 
Assigned Tocberner 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0047945: API Change: Changed C_POC_EMAIL* body column types from varchar to CLOB
DescriptionAs part of the related issue 43392, columns in C_POC_EMAIL and C_POC_EMAILDEFINITION tables will be changed from type VARCHAR to type CLOB, resulting in an API change.

Extract from try run:
 [checkAPI] 11960 [main] WARN org.openbravo.ddlutils.task.CheckAPIDistribution - Column type change from VARCHAR to CLOB: column:C_POC_EMAIL.BODY
 [checkAPI] 11960 [main] WARN org.openbravo.ddlutils.task.CheckAPIDistribution - Column type change from VARCHAR to CLOB: column:C_POC_EMAILDEFINITION.BODY
Steps To Reproduce-
Proposed Solution
Additional Information
TagsApproved
Relationships
caused by feature request 0043392 closed cberner Change column type of body column for table C_POC_EMAILDEFINITION to CLOB 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2021-10-28 09:38cbernerNew Issue
2021-10-28 09:38cbernerAssigned To => alostale
2021-10-28 09:38cbernerModules => Core
2021-10-28 09:38cbernerTriggers an Emergency Pack => No
2021-10-28 09:38cbernerRelationship addedcaused by 0043392
2021-10-28 09:38cbernerDescription Updatedbug_revision_view_page.php?rev_id=23248#r23248
2021-10-28 11:42alostaleTag Attached: Approved
2021-10-28 18:20hgbotNote Added: 0132722
2021-10-29 09:22hgbotResolutionopen => fixed
2021-10-29 09:22hgbotStatusnew => closed
2021-10-29 09:22hgbotNote Added: 0132733
2021-10-29 09:22hgbotNote Added: 0132734
2021-10-29 09:25cbernerAssigned Toalostale => cberner
2021-10-29 10:20hgbotNote Added: 0132753

Notes
(0132722)
hgbot   
2021-10-28 18:20   
Merge Request created: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/16 [^]
(0132733)
hgbot   
2021-10-29 09:22   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/ci/backoffice-api [^]
Changeset: ec83d8d2466239c9b66a3373675ac82ba61b7e17
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 2021-10-28T18:16:01+02:00
URL: https://gitlab.com/openbravo/ci/backoffice-api/-/commit/ec83d8d2466239c9b66a3373675ac82ba61b7e17 [^]

Fixes ISSUE-47945: Changed C_POC_EMAIL* body column types from varchar to CLOB

Columns in C_POC_EMAIL and C_POC_EMAILDEFINITION tables changed from type VARCHAR to type CLOB.

---
M model/src-db/database/model/tables/C_POC_EMAIL.xml
M model/src-db/database/model/tables/C_POC_EMAILDEFINITION.xml
M model/src-db/database/sourcedata/AD_COLUMN.xml
---
(0132734)
hgbot   
2021-10-29 09:22   
Merge request merged: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/16 [^]
(0132753)
hgbot   
2021-10-29 10:20   
Repository: https://gitlab.com/openbravo/ci/backoffice-api [^]
Changeset: d534224129f083eccf470d64f5bb16a7a0ae1882
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 2021-10-29T10:18:48+02:00
URL: https://gitlab.com/openbravo/ci/backoffice-api/-/commit/d534224129f083eccf470d64f5bb16a7a0ae1882 [^]

Related to ISSUE-47945: Change order to be correct in C_POC_EMAIL* body columns

Order has been wrongly changed in the last commit, to be in sync with
core, we update the order to be the correct one for the columns in
tables C_POC_EMAIL and C_POC_EMAILDEFINITION

---
M model/src-db/database/model/tables/C_POC_EMAIL.xml
M model/src-db/database/model/tables/C_POC_EMAILDEFINITION.xml
---