Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0050951
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] Y. DBSourceManagermajoralways2022-11-18 13:062022-11-29 08:13
ReportermigueldejuanaView Statuspublic 
Assigned Tocaristu 
PrioritynormalResolutionfixedFixed in VersionPR23Q1
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0050951: onCreateDefault not working for non mandatory columns referencing same table

DescriptiononCreateDefault works properly when we define a new mandatory column referencing another column of the same table, but it is not working if the new column is not mandatory. It would be nice to also support this case.

For example, this new column in AD_ORG is not working because it is not mandatory:

<column name="EM_OBDO_AD_ORG_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
         <default/>
         <onCreateDefault><![CDATA[AD_LEGALENTITY_ORG_ID]]></onCreateDefault>
       </column>

We should update the documentation:
http://wiki.openbravo.com/wiki/How_to_define_an_on_Create_Default [^]
Steps To Reproducen/a
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0049897PR22Q4 closedalostale Add missing support for referencing other columns in onCreateDefault during importsampledata 

-  Notes
(0144134)
hgbot (developer)
2022-11-25 09:36

Merge Request created: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/40 [^]
(0144135)
hgbot (developer)
2022-11-25 10:09

Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/775 [^]
(0144216)
hgbot (developer)
2022-11-29 08:09

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/dbsm [^]
Changeset: 46d2ef154b5a2d92d7c22fe38e8e046f4ba09ce2
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 29-11-2022 07:09:50
URL: https://gitlab.com/openbravo/product/dbsm/-/commit/46d2ef154b5a2d92d7c22fe38e8e046f4ba09ce2 [^]

fixes BUG-50951: non literal OCD doesn't work in non mandatory columns

  On create default of a non mandatory column that references to a
column of the same table was not working.

---
A src-test/model/createDefault/M6.xml
A src-test/model/createDefault/M7.xml
A src-test/model/createDefault/NM5.xml
A src-test/model/createDefault/NM6.xml
M src-test/src/org/openbravo/dbsm/test/model/data/OtherDefaults.java
M src/org/apache/ddlutils/platform/SqlBuilder.java
---
(0144217)
hgbot (developer)
2022-11-29 08:09

Merge request merged: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/40 [^]
(0144218)
hgbot (developer)
2022-11-29 08:13

Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/775 [^]
(0144219)
hgbot (developer)
2022-11-29 08:13

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 07b6f9579dcb74a38f3b75dfd60a60300a5e5326
Author: Carlos Aristu <carlos.aristu@openbravo.com>
Date: 29-11-2022 08:11:21
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/07b6f9579dcb74a38f3b75dfd60a60300a5e5326 [^]

fixes BUG-50951: non literal OCD doesn't work in non mandatory columns

  Non literal OCD referencing to a column of the same table was not
being applied in non mandatory columns

---
M src-db/database/lib/dbsourcemanager.jar
---

- Issue History
Date Modified Username Field Change
2022-11-18 13:06 migueldejuana New Issue
2022-11-18 13:06 migueldejuana Assigned To => Triage Platform Base
2022-11-18 13:06 migueldejuana Modules => Core
2022-11-18 13:06 migueldejuana Triggers an Emergency Pack => No
2022-11-18 13:07 migueldejuana Description Updated View Revisions
2022-11-18 13:41 caristu Relationship added related to 0049897
2022-11-18 13:41 caristu Assigned To Triage Platform Base => caristu
2022-11-25 09:36 hgbot Note Added: 0144134
2022-11-25 10:09 hgbot Note Added: 0144135
2022-11-29 08:09 hgbot Resolution open => fixed
2022-11-29 08:09 hgbot Status new => closed
2022-11-29 08:09 hgbot Note Added: 0144216
2022-11-29 08:09 hgbot Note Added: 0144217
2022-11-29 08:13 hgbot Note Added: 0144218
2022-11-29 08:13 hgbot Fixed in Version => PR23Q1
2022-11-29 08:13 hgbot Note Added: 0144219


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker