Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0056354ModulesAdvanced Warehouse Operationspublic2024-09-04 03:522024-09-18 16:23
Reporteraxelmercado 
Assigned ToSandrahuguet 
PriorityhighSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Statusapproved
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket107258
OBNetwork customerGold
Regression introduced in release
Summary0056354: Problem with subquery in productSelector.java file when getting more than 1 record.
DescriptionIn the Maisadour client, which is in version 22Q4.2, we encountered a problem when 2 records are configured in the "Alternative UOM" tab and one is deactivated because there is an eventHandler that does not allow having 2 active records with the "Logistics" field with value "Primary".
The subquery that fails is the one shown in the attached screenshot.
As can be seen, it does not filter between assets, so having 2 records, even if one is deactivated, both are brought and the error occurs.
Steps To ReproduceN/A
Proposed SolutionFiltering between active records should solve the problem.
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng imagen.png (10,103) 2024-09-04 03:52
https://issues.openbravo.com/file_download.php?file_id=20127&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2024-09-04 03:52axelmercadoNew Issue
2024-09-04 03:52axelmercadoAssigned To => Triage Omni WMS
2024-09-04 03:52axelmercadoFile Added: imagen.png
2024-09-04 03:52axelmercadoSupport ticket => 107258
2024-09-04 03:52axelmercadoOBNetwork customer => Gold
2024-09-09 09:26mtaalAssigned ToTriage Omni WMS => Sandrahuguet
2024-09-11 11:19hgbotMerge Request Status => open
2024-09-11 11:19hgbotNote Added: 0169067
2024-09-11 12:49SandrahuguetNote Added: 0169076
2024-09-11 13:18SandrahuguetNote Edited: 0169076bug_revision_view_page.php?bugnote_id=0169076#r28434
2024-09-11 13:54SandrahuguetStatusnew => scheduled
2024-09-18 16:23hgbotMerge Request Statusopen => approved
2024-09-18 16:23hgbotResolutionopen => fixed
2024-09-18 16:23hgbotStatusscheduled => closed
2024-09-18 16:23hgbotNote Added: 0169322
2024-09-18 16:23hgbotNote Added: 0169323

Notes
(0169067)
hgbot   
2024-09-11 11:19   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/302 [^]
(0169076)
Sandrahuguet   
2024-09-11 12:49   
(edited on: 2024-09-11 13:18)
Test Plan

In backoffice using AWO-QA Admin client
Go to Product select AUMMultiplesTest001 and navigate to Alternate UOM tab
set box as inactive
and create new record-> UOM : Foot, conversion rate:15; sales: primary; purchase:primary; logistics: primary

Go to AWO
In the menu, select count and start count
add a product and search by AUMMultiplesTest001 notice that query now is not failing
 
In the nemu, select put away and search by AUMMultiplesTest001, notice that query now is not failing

In the menu, select Lookup and search by AUMMultiplesTest001, notice that query now is not failing

In the menu, select Status and search by AUMMultiplesTest001, notice that query now is not failing

In SSMS
go to requisition and create new and add item and search by AUMMultiplesTest001, notice that query now is not failing
(0169322)
hgbot   
2024-09-18 16:23   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations [^]
Changeset: 71cacb1003aae288bbb8c45df5a9d4e155f9b2a3
Author: Sandra Huguet <s.huguet@orisha.com>
Date: 18-09-2024 14:23:56
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/commit/71cacb1003aae288bbb8c45df5a9d4e155f9b2a3 [^]

Fixed ISSUE-56354: add filter is active in query to prevent failure

---
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/AlternativeStorageDetailsForSwapProperties.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/InventoryProperties.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/PIP_ProductSelector.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/ProductSelector.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/ProductSelectorWithTotalStock.java
M src/org/openbravo/warehouse/advancedwarehouseoperations/mobile/datasources/taskgenerationcandidates/TGC_StorageDetail_PA.java
---
(0169323)
hgbot   
2024-09-18 16:23   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/302 [^]