Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0004902Openbravo ERPA. Platformpublic2008-09-09 17:262009-11-24 12:36
gorkaion 
shuehner 
normalminoralways
closedout of date 
20Gentoo
2.40 
 
Core
No
0004902: Autogenerate Search Key values
In old versions of Openbravo (checked that is working in OB 2.22) you could left null the Search Key (for example in Product window) and the application when the new entry is saved generates a new value.

Looking in the sources and in database everything is prepared, but as the field is mandatory it is not possible to left blank the search key. If we set the field as not mandatory and recompile the sources changes and doesn't generate anything.
Go to Product window and try to enter a new product with null Search Key. You can't because the field is mandatory.

Modify in the Application Dictionary the column Value of the M_Product table and compile the Product window.

Now you can save with a null Search Key but you get a database error because the Value column is mandatory in database.
I see 2 possible solutions:

1) enable the possibility of inserting null Search Keys, changing wad to include the code that calls the getDocumentNo method always when it is a Value column, or inserting a rule to set in the html the field as not mandatory so you can left the Search Key null.

2) modify the Search Key fields to be like the DocumentNo fields. So when it is inserted a new record the application suggest a new number ('<000000001>'). I prefer this solution.
platform1_sprint1
blocks feature request 0004416 scheduled iciordia Autogenerate Search Key values 
Issue History
2008-09-09 17:26anonymousNew Issue
2008-09-09 17:26anonymousAssigned To => alostale
2008-09-09 17:26anonymousStatusnew => scheduled
2008-09-09 17:26anonymousfix_in_branch => 2.40
2008-12-12 12:13alostaleTag Attached: platform1_sprint1
2009-01-09 12:07psarobeAssigned Toalostale => iperdomo
2009-01-09 12:07psarobeSteps to Reproduce Updated
2009-01-19 13:06psarobeversion => 2.40
2009-02-03 17:45iperdomoAssigned Toiperdomo => anthony_wolski
2009-04-16 13:23iperdomoAssigned Toanthony_wolski => iperdomo
2009-11-24 11:43iperdomoAssigned Toiperdomo => shuehner
2009-11-24 12:36shuehnerNote Added: 0022135
2009-11-24 12:36shuehnerStatusscheduled => closed
2009-11-24 12:36shuehnerResolutionopen => out of date

Notes
(0022135)
shuehner   
2009-11-24 12:36   
Will not be backported to 2.40