Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0004513Openbravo ERP00. Application dictionarypublic2008-07-26 12:422009-05-22 19:26
rafaroda 
iciordia 
normalminoralways
closedduplicate 
20Ubuntu 7.10
pi 
 
Core
No
0004513: Fields relations within Application Dictionary
It would be useful to be able to define conditions/relations between fields in order to avoid wrong data insertion.

For instance, in a Project, if the Ending Date is lower than the Starting Date a message should display (as it is displaying for wrong dates) and one should not be able to save this record.

The same could be implemented for:
* Quantities that have to be one bigger or equal to another.
* Quantities that are a function of others (Field 3 = Field 1 * Field 2)

At the end, it would allow to implement simple callout-like/trigger-like logics without having to code.
1) Go to Project & Service Management || Transactions || Multiphase Project || Project >> Project Phase
2) Set a Starting Date
3) Set an Ending Date lower than Starting Date

No check is done.
In Application Dictionary, at a field level, add a tab that permits to register relationship checks/calculations between fields.

Fields related could be in the same tab or in different tabs.
No tags attached.
duplicate of feature request 0000391 acknowledged rgoris Additional date widget for WAD windows: date range + date format validation 
Issue History
2008-07-26 12:42rafarodaNew Issue
2008-07-26 12:42rafarodaAssigned To => cromero
2008-07-26 12:42rafarodasf_bug_id0 => 2028635
2008-07-26 13:15rafarodaSummaryFields relations check within Application Dictionary => Fields relations within Application Dictionary
2008-07-26 13:15rafarodaDescription Updated
2008-07-26 13:15rafarodaSteps to Reproduce Updated
2008-07-26 14:16rafarodaRelationship addedblocks 0004514
2008-11-10 13:10cromeroAssigned Tocromero => pjuvara
2008-11-16 18:08pjuvaraRegression testing => No
2008-11-16 18:08pjuvaraRelationship addedduplicate of 0000391
2008-11-16 18:08pjuvaraStatusnew => closed
2008-11-16 18:08pjuvaraNote Added: 0010313
2008-11-16 18:08pjuvaraDuplicate ID0 => 391
2008-11-16 18:08pjuvaraResolutionopen => duplicate
2008-11-16 18:09pjuvaraRelationship deletedblocks 0004514
2009-05-22 19:26pjuvaraAssigned Topjuvara => iciordia

Notes
(0010313)
pjuvara   
2008-11-16 18:08   
Part of this request is duplicate of 391. For others, I am not sure that they are essential.