Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045412Openbravo ERPA. Platformpublic2020-11-10 18:192020-12-01 12:10
ReporterLeyre 
Assigned ToAtulOpenbravo 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerGold
Web browser
ModulesCore
Support ticket19606
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0045412: Filters in Backend do not work correctly
DescriptionFilters in Backend do not work correctly

"The problem is that when we want to filter this table, the java class is not invoked, so the result is null.
I thought it was due to some configuration problem, but I investigated several tables that are created in HQL Query, and I could identify that most of these tables are used in "Pick and Execute" windows"
Steps To Reproduce1. Open Backend:
https://livebuilds.openbravo.com/retail_modules_pgsql_pi/ [^]

2. Select the Role = AWO-QA Admin

3. Open "Distribution Order Issue" window.

4. Select record: "Document No" = 1000123.

5. Select first line in "Lines" tab.

6. Open "Reserved Stock" tab and click on "Reservation Stock" -> Use as filter.

Result: No records appear, filter does not work:
https://drive.google.com/file/d/1iC6P1NfmHS_vV8FYcylE4A4nMm3dkKXB/view?usp=sharing [^]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0045177 closed cberner filter field hover is not escaped 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-11-10 18:19LeyreNew Issue
2020-11-10 18:19LeyreAssigned To => platform
2020-11-10 18:19LeyreOBNetwork customer => Gold
2020-11-10 18:19LeyreModules => Core
2020-11-10 18:19LeyreSupport ticket => 19606
2020-11-10 18:19LeyreResolution time => 1606777200
2020-11-10 18:19LeyreTriggers an Emergency Pack => No
2020-11-10 18:19LeyreRelationship addedrelated to 0045177
2020-11-12 10:33LeyreDescription Updatedbug_revision_view_page.php?rev_id=21882#r21882
2020-11-13 13:04cbernerNote Added: 0124359
2020-11-16 09:19cbernerAssigned Toplatform => Triage Finance
2020-11-20 13:56dmiguelezAssigned ToTriage Finance => AtulOpenbravo
2020-11-24 04:06AtulOpenbravoStatusnew => scheduled
2020-11-25 06:36AtulOpenbravoNote Added: 0124604
2020-11-26 19:10hgbotMerge Request Status => open
2020-11-26 19:10hgbotNote Added: 0124635
2020-11-26 19:12AtulOpenbravoNote Added: 0124636
2020-12-01 12:09hgbotMerge Request Statusopen => approved
2020-12-01 12:10hgbotResolutionopen => fixed
2020-12-01 12:10hgbotStatusscheduled => closed
2020-12-01 12:10hgbotNote Added: 0124676
2020-12-01 12:10hgbotNote Added: 0124677

Notes
(0124359)
cberner   
2020-11-13 13:04   
This is mainly happening in Distribution Order Issue -> Lines -> Reservation Stock, because this last tab has an wrong HQL query, it can be checked by clicking trying to select one of the elements in Reservation Stock first column and "Open in tab", it will fail.

The filter fails to work properly on the column "Reservation Stock" as a cause of this.
(0124604)
AtulOpenbravo   
2020-11-25 06:36   
Test Plan

- Login with Role = AWO-QA Admin
- Navigate to "Distribution Order Issue" window.
- Select record: "Document No" = 1000123.
- Select first line in "Lines" tab.
- Open "Reserved Stock" tab and click on "Reservation Stock" -> Use as filter.
- Realize that filter is successfully applied and particular records is shown in the grid in this case record with Identifier Apple - 10 - 10 - true
(0124635)
hgbot   
2020-11-26 19:10   
Merge Request created: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder/-/merge_requests/2 [^]
(0124636)
AtulOpenbravo   
2020-11-26 19:12   
Reservation Stock field is disable for sort/filter. Product field is added with sort/filter along with Quantity and Allocated in the grid view as per the identifier of Reservation Stock field.
(0124676)
hgbot   
2020-12-01 12:10   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder [^]
Changeset: 5ff936c9a21f8c3b8e9542378aa2f9e891300d4b
Author: Atul Gaware <atul.gaware@openbravo.com>
Date: 2020-11-26T23:29:18+05:30
URL: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder/-/commit/5ff936c9a21f8c3b8e9542378aa2f9e891300d4b [^]

Fixes BUG-0045412: Filters in Backend do not work correctly

**Add alias for column Distribution Order Line object to fix
the value in Reservation Stock field.
**Disable sorting/filtering of field Reservation Stock field
**Add allowing sort/filter Product field in Distribution Order
Issue window, Reserved Stock tab

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_TABLE.xml
---
(0124677)
hgbot   
2020-12-01 12:10   
Merge request merged: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder/-/merge_requests/2 [^]