0043186: AWO Front End Menu Lookup filter also by barcode of storage bin

Description

Add the possibility to filter in the lookup for a given barcode of a Storage Bin. Customer that does this request also attaches a diff (see it attached here) with the necessary changes (it's only adding a line for improving the query)

Steps To Reproduce

*Go to Openbravo livebuilds click on firt AWO link
*Enter with AWOQAAdmin / openbravo
* go to Menu click on lookup, when you enter a word here it won't filter by the barcode of a storage bin

Proposed Solution

See the diff attached

Tags

No tags attached.

Attached Files

filtroBarcode.diff [^] (645 bytes) 2020-02-11 13:29 [Show Content] [Hide Content]

diff -ru OLD/Inventory.java NEW/Inventory.java
--- a/src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/Inventory.java	2020-02-04 10:51:37.485037000 +0100
+++ b/src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/Inventory.java	2020-02-11 12:44:52.632979000 +0100
@@ -109,6 +109,7 @@
       hql += "upper(pr.uPCEAN) like :filterParam OR ";
       hql += "upper(pr.name) like :filterParam OR ";
       hql += "upper(sb.searchKey) like :filterParam OR ";
+      hql += "upper(sb.barcode) like :filterParam OR ";
       // Attribute
       hql += "upper(att.description) like :filterParam ) ";
     }

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2020-02-11 13:29	santi_lozano	New Issue
2020-02-11 13:29	santi_lozano	Assigned To	=> Triage Finance
2020-02-11 13:29	santi_lozano	File Added: filtroBarcode.diff
2020-02-11 13:32	santi_lozano	Description Updated	View Revisions
2020-02-11 13:32	santi_lozano	Description Updated	View Revisions
2020-02-11 13:47	Practics	Issue Monitored: Practics
2022-09-06 17:18	caristu	Category	Advance Warehouse Operations => Advanced Warehouse Operations