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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012481
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 00. Application dictionaryminorN/A2010-02-26 09:172010-03-12 22:40
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PriorityurgentResolutionfixedFixed in Version2.50MP14
StatusclosedFix in branchFixed in SCM revisionfa2d62c2d918
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012481: 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).
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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0024850)
hgbot (developer)
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 (developer)
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 (developer)
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 [^]

- Issue History
Date Modified Username Field Change
2010-02-26 09:17 alostale New Issue
2010-02-26 09:17 alostale Assigned To => alostale
2010-02-26 10:01 hgbot Checkin
2010-02-26 10:01 hgbot Note Added: 0024850
2010-02-26 10:01 hgbot Status new => resolved
2010-02-26 10:01 hgbot Resolution open => fixed
2010-02-26 10:01 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fa2d62c2d918ccd34b2b84b949bbfc2a7afcfbd3 [^]
2010-02-26 10:46 marvintm Note Added: 0024853
2010-02-26 10:46 marvintm Status resolved => closed
2010-02-26 10:46 marvintm Fixed in Version => 2.50MP13
2010-03-08 16:04 jpabloae Fixed in Version 2.50MP13 => 2.50MP14
2010-03-10 17:25 anonymous sf_bug_id 0 =>
2010-03-10 18:30 anonymous sf_bug_id => 2968110
2010-03-12 22:40 hudsonbot Checkin
2010-03-12 22:40 hudsonbot Note Added: 0025339


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker