Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0052076Openbravo ERPA. Platformpublic2023-04-05 18:122023-05-11 09:11
Reporterjlopez 
Assigned Tojlopez 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR23Q3 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0052076: Sort By Field In Selectors
DescriptionThe main functional requirement is to provide the ability to display the values shown in the drop down of a selector sorted by a property in particular.
Currently it is not possible to define the order by field of selector references (OBUISEL_Selector). By default the records shown in this kind of selectors are sorted by the field marked as “display field”. And in case the display field is not defined for a given selector, its records are sorted using the record identifier.

https://openbravo.atlassian.net/browse/RM-4584 [^]

Steps To Reproduce*
Proposed SolutionThe main idea is to provide a new optional field named “Sort By Field” in the Defined Selector subtab. This will be a combo that will allow us to select one of the fields defined in the “Selector Field” subtab, in the same way the “Display Field” does. When defined, that field will be used by the data sources to sort the fetched records.
This configuration will be limited to selector’s drop down only: it will not be taken into account in the selector’s grid view. So, the new field may be named accordingly.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0050971 closed adrianromero POS2 In the Dev Backoffice, Values of combos have to be sorted in ascending numbers by sequence number 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-04-05 18:12jlopezNew Issue
2023-04-05 18:12jlopezAssigned To => jlopez
2023-04-05 18:12jlopezModules => Core
2023-04-05 18:12jlopezTriggers an Emergency Pack => No
2023-04-05 18:32hgbotNote Added: 0148319
2023-04-11 20:17jlopezRelationship addedrelated to 0050971
2023-05-11 09:11hgbotResolutionopen => fixed
2023-05-11 09:11hgbotStatusnew => closed
2023-05-11 09:11hgbotFixed in Version => PR23Q3
2023-05-11 09:11hgbotNote Added: 0149595
2023-05-11 09:11hgbotNote Added: 0149596

Notes
(0148319)
hgbot   
2023-04-05 18:32   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/852 [^]
(0149595)
hgbot   
2023-05-11 09:11   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 1c15f086c7e3f11e7f2ee86351d5913b24481ea1
Author: Javier López <javier.lopez@precognis.com>
Date: 11-05-2023 07:11:13
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/1c15f086c7e3f11e7f2ee86351d5913b24481ea1 [^]

fixes FR-52076: Sort By Field in Selectors

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/ApplicationDictionaryCachedStructures.java
M modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR.xml
M modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_COLUMN.xml
M modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_ELEMENT.xml
M modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/AD_FIELD.xml
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/SelectorComponent.java
M modules/org.openbravo.userinterface.selector/src/org/openbravo/userinterface/selector/templates/selector.ftl
M modules/org.openbravo.userinterface.selector/web/org.openbravo.userinterface.selector/js/ob-selector-item.js
---
(0149596)
hgbot   
2023-05-11 09:11   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/852 [^]