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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009016
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 00. Application dictionaryminoralways2009-05-13 12:232022-02-01 08:08
ReporternataliaperuView Statuspublic 
Assigned ToTriage Platform Base 
PriorityurgentResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009016: 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
TagsModularity
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
has duplicate defect 0010024 closedrafaroda Error when new column in Core table references a new table of a new Module 
related to feature request 0013977 scheduledTriage Platform Base problem when adding a "DocumentNo" field in a table from an external module 

-  Notes
(0016496)
psarobe (manager)
2009-05-20 11:29

Update to urgent because people from second level says that the window does not work

- Issue History
Date Modified Username Field Change
2009-05-13 12:23 nataliaperu New Issue
2009-05-13 12:23 nataliaperu Assigned To => rafaroda
2009-05-13 13:05 networkb Issue Monitored: networkb
2009-05-19 16:52 psarobe Tag Attached: Modularity
2009-05-20 11:07 psarobe Status new => scheduled
2009-05-20 11:07 psarobe fix_in_branch => pi
2009-05-20 11:08 psarobe Assigned To rafaroda => alostale
2009-05-20 11:08 psarobe fix_in_branch pi =>
2009-05-20 11:29 psarobe Note Added: 0016496
2009-05-20 11:29 psarobe Priority normal => urgent
2009-07-23 17:00 alostale Steps to Reproduce Updated
2009-07-23 17:05 iperdomo Relationship added has duplicate 0010024
2009-10-06 12:27 alostale Type defect => feature request
2010-07-29 12:25 alostale Relationship added related to 0013977
2011-05-24 10:16 rafademiguel Issue Monitored: rafademiguel
2017-04-10 14:38 alostale Assigned To alostale => platform
2022-02-01 08:08 alostale Assigned To platform => Triage Platform Base


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker