Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0056354 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] Advanced Warehouse Operations | major | sometimes | 2024-09-04 03:52 | 2024-09-18 16:23 | |||
| Reporter | axelmercado | View Status | public | |||||
| Assigned To | Sandrahuguet | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | ||||||||
| Regression introduced in release | ||||||||
| Summary | 0056354: Problem with subquery in productSelector.java file when getting more than 1 record. | |||||||
| Description | In 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 Reproduce | N/A | |||||||
| Proposed Solution | Filtering between active records should solve the problem. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  imagen.png [^] (10,103 bytes) 2024-09-04 03:52
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0169067) hgbot (developer) 2024-09-11 11:19 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/302 [^] |
|
(0169076) Sandrahuguet (developer) 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 (developer) 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 (developer) 2024-09-18 16:23 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.warehouse.advancedwarehouseoperations/-/merge_requests/302 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2024-09-04 03:52 | axelmercado | New Issue | |
| 2024-09-04 03:52 | axelmercado | Assigned To | => Triage Omni WMS |
| 2024-09-04 03:52 | axelmercado | File Added: imagen.png | |
| 2024-09-09 09:26 | mtaal | Assigned To | Triage Omni WMS => Sandrahuguet |
| 2024-09-11 11:19 | hgbot | Note Added: 0169067 | |
| 2024-09-11 12:49 | Sandrahuguet | Note Added: 0169076 | |
| 2024-09-11 13:18 | Sandrahuguet | Note Edited: 0169076 | View Revisions |
| 2024-09-11 13:54 | Sandrahuguet | Status | new => scheduled |
| 2024-09-18 16:23 | hgbot | Resolution | open => fixed |
| 2024-09-18 16:23 | hgbot | Status | scheduled => closed |
| 2024-09-18 16:23 | hgbot | Note Added: 0169322 | |
| 2024-09-18 16:23 | hgbot | Note Added: 0169323 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |