Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012481Openbravo ERP00. Application dictionarypublic2010-02-26 09:172010-03-12 22:40
Reporteralostale 
Assigned Toalostale 
PriorityurgentSeverityminorReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.50MP14 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012481: Sortable drop down list
DescriptionCurrently there are 3 main core base references that are rendered as a drop down list in edition view UI: Table, TableDir and List.

-Table reference has an Order By field which allows to define the order of the records in the drop down list.
-TableDir reference doesn't allow to define any ordering criteria, records are ordered alphabetically. But in case the drop down list is needed to be shown in certain order, it is possible to create a Table reference for this purpose and use it instead of the TableDir one.
-List reference is always ordered alphabetically, it does not allow to change the order of records. If the records are wanted to be shown in certain order, there is no other workarround than naming them alphabetically (or include a number at the beginning of the name).
Steps To Reproduce
Proposed SolutionAdd a new seqNo field in the AD_Ref_List table which will be taken into account when rendering the list.

-If the value of this field is null for all the elements in the list, the list will be sorted alphabetically. In this way it will behave as it does currently.
-If all the elements have this value set, they will be ordered taken into account it.
-If some of the elements have it and some not, the ones having it will appear at the beginning of the list sorted by seqno, the rest of them will be shown at the end ordered alphabetically.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-26 09:17alostaleNew Issue
2010-02-26 09:17alostaleAssigned To => alostale
2010-02-26 09:17alostaleOBNetwork customer => No
2010-02-26 10:01hgbotCheckin
2010-02-26 10:01hgbotNote Added: 0024850
2010-02-26 10:01hgbotStatusnew => resolved
2010-02-26 10:01hgbotResolutionopen => fixed
2010-02-26 10:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fa2d62c2d918ccd34b2b84b949bbfc2a7afcfbd3 [^]
2010-02-26 10:46marvintmNote Added: 0024853
2010-02-26 10:46marvintmStatusresolved => closed
2010-02-26 10:46marvintmFixed in Version => 2.50MP13
2010-03-08 16:04jpabloaeFixed in Version2.50MP13 => 2.50MP14
2010-03-10 17:25anonymoussf_bug_id0 =>
2010-03-10 18:30anonymoussf_bug_id => 2968110
2010-03-12 22:40hudsonbotCheckin
2010-03-12 22:40hudsonbotNote Added: 0025339

Notes
(0024850)
hgbot   
2010-02-26 10:01   
Repository: erp/devel/pi
Changeset: fa2d62c2d918ccd34b2b84b949bbfc2a7afcfbd3
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Feb 26 10:00:14 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/fa2d62c2d918ccd34b2b84b949bbfc2a7afcfbd3 [^]

fixed issue 12481: Sortable drop down list

---
M src-db/database/model/tables/AD_REF_LIST.xml
M src-db/database/model/triggers/AD_REF_LIST_MOD_TRG.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/erpCommon/utility/ComboTableData.java
---
(0024853)
marvintm   
2010-02-26 10:46   
Tested that it works:
- When no seqno is defined, the values are shown alphabetically ordered.
- When some of them have seqno, the values which have seqno are shown (ordered by seqno), and the rest of them are shown alphabetically after them.
- When all of them have seqno, they are shown ordered by seqno.
(0025339)
hudsonbot   
2010-03-12 22:40   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/fa2d62c2d918 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]