Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0006383Openbravo ERPA. Platformpublic2008-12-05 13:472012-04-20 14:27
mtaal 
naiaramartinez 
normalminoralways
closedout of date 
5
pi 
 
Core
No
0006383: C_Project.changeprojectstatus column definition (fieldlength) in AD_Column is not in sync with allowed values
The column C_Project.changeprojectstatus can only hold values NF, OC, OU, OP, OR (at least according to the reference definition). However in the big bazaar database the projects all have value N. In addition in AD_Column the definition of this column has fieldlength 1 which does not fit with the allowed values defined for this column (which all have length 2).

gr. Martin
MIR-Reviewed, OB3-Reviewed
Issue History
2008-12-05 13:47mtaalNew Issue
2008-12-05 13:47mtaalAssigned To => rafaroda
2008-12-05 13:47mtaalsf_bug_id0 => 2392567
2008-12-05 13:47mtaalRegression testing => No
2008-12-05 19:32mtaalNote Added: 0011008
2008-12-09 12:34pheenanAssigned Torafaroda => Hennadzi
2008-12-09 13:39DowidAssigned ToHennadzi => Dowid
2008-12-10 11:14rafarodaAssigned ToDowid => AinhoaPagola
2008-12-10 11:17mtaalNote Added: 0011135
2008-12-10 11:17mtaalAssigned ToAinhoaPagola => alostale
2008-12-12 12:09alostaleTag Attached: platform1_sprint1
2008-12-18 10:24rafarodaStatusnew => scheduled
2008-12-18 10:24rafarodafix_in_branch => trunk
2011-10-27 18:29psarobeAssigned Toalostale => iciordia
2011-10-27 18:29psarobefix_in_branchpi =>
2011-10-28 19:07iciordiaTag Attached: OB3-Reviewed
2011-10-28 19:07iciordiaTag Detached: platform1_sprint1
2011-10-28 19:07iciordiaAssigned Toiciordia => alostale
2011-11-17 15:58alostaleNote Added: 0042939
2011-11-17 15:58alostaleAssigned Toalostale => psarobe
2012-04-18 11:14psarobeAssigned Topsarobe => alostale
2012-04-18 11:17alostaleAssigned Toalostale => vmromanos
2012-04-19 18:44miruritaTag Attached: MIR-Reviewed
2012-04-20 14:21naiaramartinezAssigned Tovmromanos => naiaramartinez
2012-04-20 14:27naiaramartinezNote Added: 0047794
2012-04-20 14:27naiaramartinezStatusscheduled => closed
2012-04-20 14:27naiaramartinezResolutionopen => out of date

Notes
(0011008)
mtaal   
2008-12-05 19:32   
An additional remark: I mention that the field length is not inline with the values of the reference_list. But it can also be the case that this column is in fact a YesNo column. Then the reference_id value in the AD_Column needs to be changed to 20 and the reference_value_id should be set to null.

gr. Martin
(0011135)
mtaal   
2008-12-10 11:17   
After discussing with Ismael, it is better if Asier takes this. Ismael will provide him with additional information.

gr. Martin
(0042939)
alostale   
2011-11-17 15:58   
Column length is fixed, problem persists with actual data in sample data
(0047794)
naiaramartinez   
2012-04-20 14:27   
This issue has been closed because the definitions of the fields are correct.

On the one hand, the definition of the 'ChangeProjectStatus' column, which is a botton, in the application has fieldlength 1 and its value by default is 'N'.

On the other hand, the definition of the 'ProjectStatus' column is a drop down list and it is defined correctly.