Openbravo Issue Tracking System - POS2
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0058202POS2POSpublic2025-03-11 13:102025-03-17 08:40
Reportersofidossant 
Assigned ToBimla_vm 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerOBPS
Support ticket121591
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0058202: Sort search by alphabetical order
DescriptionWhen searching for customers in pos2, we can see that when searching for example: “SCHIAVON” this is ordered in a way it should not be, example of how it appears :

SCHIAVON Alicia
SCHIAVON Abdhal
SCHIAVONE Amadeo
SCHIAVON Juan
SCHIAVONE Zara

From our point of view the “SCHIAVONE” should be at the bottom, since we are looking for “SCHIAVON” and the order of the names should also be alphabetical, i.e. SCHIAVON Abdhal should be above SCHAVON Alicia.

Example of how it should be :

SCHIAVON Jason
SCHIAVON Joseph
SCHIAVON John
SCHIAVONE Amadeo
SCHIAVONE Jullie
Steps To ReproduceGo to pos2--> Search customers Example "SCHIAVON" --> it will appear in disorder alphabetic the names , and also you will see that its SHCIAVONE in the middle


Video attached : https://drive.google.com/file/d/17_rnyptanLe9medijWj8XHk5G16JdZC9/view?usp=sharing [^]
Proposed SolutionSort first by last name, then by first name
The video example would look like this:
Amadeo SCHIAVON
Ana SCHIAVON
Alah SCHIAVONE
Zara SCHIAVONE.
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng Schiavon.png (79,031) 2025-03-14 14:45
https://issues.openbravo.com/file_download.php?file_id=21049&type=bug
png

png SchiavonBO.png (119,927) 2025-03-14 14:45
https://issues.openbravo.com/file_download.php?file_id=21050&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2025-03-11 13:10sofidossantNew Issue
2025-03-11 13:10sofidossantAssigned To => Retail
2025-03-11 13:10sofidossantOBNetwork customer => OBPS
2025-03-11 13:10sofidossantSupport ticket => 121591
2025-03-11 13:10sofidossantTriggers an Emergency Pack => No
2025-03-11 18:29guilleaerAssigned ToRetail => guilleaer
2025-03-11 18:29guilleaerStatusnew => acknowledged
2025-03-12 05:40Bimla_vmAssigned Toguilleaer => Bimla_vm
2025-03-12 05:41Bimla_vmStatusacknowledged => scheduled
2025-03-13 05:35hgbotMerge Request Status => open
2025-03-13 05:35hgbotNote Added: 0176755
2025-03-13 08:34hgbotMerge Request Statusopen => approved
2025-03-13 08:34hgbotResolutionopen => fixed
2025-03-13 08:34hgbotStatusscheduled => closed
2025-03-13 08:34hgbotFixed in Version => RR25Q2
2025-03-13 08:34hgbotNote Added: 0176761
2025-03-13 08:34hgbotNote Added: 0176762
2025-03-14 14:40sofidossantStatusclosed => new
2025-03-14 14:40sofidossantFixed in VersionRR25Q2 =>
2025-03-14 14:44sofidossantNote Added: 0176857
2025-03-14 14:45sofidossantFile Added: Schiavon.png
2025-03-14 14:45sofidossantFile Added: SchiavonBO.png
2025-03-17 08:40guilleaerNote Added: 0176880
2025-03-17 08:40guilleaerStatusnew => closed
2025-03-17 08:40guilleaerNote Edited: 0176880bug_revision_view_page.php?bugnote_id=0176880#r29372

Notes
(0176755)
hgbot   
2025-03-13 05:35   
Merge Request created: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1971 [^]
(0176761)
hgbot   
2025-03-13 08:34   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: 75444e061a995a3479ef96a36e1024db389bd87c
Author: Bimla V Mayavan <b.mayavan@external.orisha.com>
Date: 12-03-2025 15:30:13
URL: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/75444e061a995a3479ef96a36e1024db389bd87c [^]

Fixed ISSUE-58202: Updated orderBy in hql based on orderByProperties

---
M src/org/openbravo/retail/posterminal/master/BusinessPartner.java
---
(0176762)
hgbot   
2025-03-13 08:34   
Merge request merged: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1971 [^]
(0176857)
sofidossant   
2025-03-14 14:44   
It has been solved but only in part.
I explain why, at the moment of creating the business partners we can visualize them in the following way in the POS2 . Example in images i attached.

We can see the order in POS2 and B.O its not right.

We need to order all the SCHIAVON together on one side and on the other side the ones that are SCHIAVONE , always in alphabetical order, we should not see a SCHIAVONE in between as we can see in the attached pictures.
(0176880)
guilleaer   
2025-03-17 08:40   
Closed because this issue was related to the sorting not to way to filter the data.

Currently filters works with "like" so it means that if you have

pedro
pedrito
pedrolas

and user search by "pedr" system will return all of them