Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009016Openbravo ERP00. Application dictionarypublic2009-05-13 12:232022-02-01 08:08
Reporternataliaperu 
Assigned ToTriage Platform Base 
PriorityurgentSeverityminorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version2.50 
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
Summary0009016: When a column is added in a table in different module (EM_Module_Column) its reference is TableDir by default
DescriptionA new column is added in a table from core.
When "Create columns from DB" process is launched, by default, column reference is set to TableDir.

It must be Table because TableDir can not be used for this kind of columns.
Steps To ReproduceCreate a new column in the database, for example, in C_Invoice

ALTER TABLE C_INVOICE ADD COLUMN EM_HOTEL_GUEST_ID character varying(32);


ALTER TABLE C_INVOICE ADD CONSTRAINT hotelguest_corder FOREIGN KEY (EM_HOTEL_GUEST_ID)
      REFERENCES hotel_guest (hotel_guest_id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION;

Go to Application Dictionary, Tables and Column and search C_Invoice.
Click on "Create Columns from DB".
New column will be added and its reference will be TableDir instead of Table.
Proposed SolutionAdd support for EM_* columns to allow TableDir reference
Additional Information
TagsModularity
Relationships
has duplicate defect 0010024 closed rafaroda Error when new column in Core table references a new table of a new Module 
related to feature request 0013977 scheduled Triage Platform Base problem when adding a "DocumentNo" field in a table from an external module 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-05-13 12:23nataliaperuNew Issue
2009-05-13 12:23nataliaperuAssigned To => rafaroda
2009-05-13 13:05networkbIssue Monitored: networkb
2009-05-19 16:52psarobeTag Attached: Modularity
2009-05-20 11:07psarobeStatusnew => scheduled
2009-05-20 11:07psarobefix_in_branch => pi
2009-05-20 11:08psarobeAssigned Torafaroda => alostale
2009-05-20 11:08psarobefix_in_branchpi =>
2009-05-20 11:29psarobeNote Added: 0016496
2009-05-20 11:29psarobePrioritynormal => urgent
2009-07-23 17:00alostaleSteps to Reproduce Updated
2009-07-23 17:05iperdomoRelationship addedhas duplicate 0010024
2009-10-06 12:27alostaleTypedefect => feature request
2010-07-29 12:25alostaleRelationship addedrelated to 0013977
2011-05-24 10:16rafademiguelIssue Monitored: rafademiguel
2017-04-10 14:38alostaleAssigned Toalostale => platform
2022-02-01 08:08alostaleAssigned Toplatform => Triage Platform Base

Notes
(0016496)
psarobe   
2009-05-20 11:29   
Update to urgent because people from second level says that the window does not work