Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0045412
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2020-11-10 18:192020-12-01 12:10
ReporterLeyreView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0045412: 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 [^]
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0045177 closedcberner filter field hover is not escaped 

-  Notes
(0124359)
cberner (viewer)
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 (viewer)
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 (developer)
2020-11-26 19:10

 Merge Request created: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder/-/merge_requests/2 [^]
(0124636)
AtulOpenbravo (viewer)
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 (developer)
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 (developer)
2020-12-01 12:10

 Merge request merged: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder/-/merge_requests/2 [^]

- Issue History
Date Modified Username Field Change
2020-11-10 18:19 Leyre New Issue
2020-11-10 18:19 Leyre Assigned To => platform
2020-11-10 18:19 Leyre OBNetwork customer => Gold
2020-11-10 18:19 Leyre Modules => Core
2020-11-10 18:19 Leyre Support ticket => 19606
2020-11-10 18:19 Leyre Resolution time => 1606777200
2020-11-10 18:19 Leyre Triggers an Emergency Pack => No
2020-11-10 18:19 Leyre Relationship added related to 0045177
2020-11-12 10:33 Leyre Description Updated View Revisions
2020-11-13 13:04 cberner Note Added: 0124359
2020-11-16 09:19 cberner Assigned To platform => Triage Finance
2020-11-20 13:56 dmiguelez Assigned To Triage Finance => AtulOpenbravo
2020-11-24 04:06 AtulOpenbravo Status new => scheduled
2020-11-25 06:36 AtulOpenbravo Note Added: 0124604
2020-11-26 19:10 hgbot Merge Request Status => open
2020-11-26 19:10 hgbot Note Added: 0124635
2020-11-26 19:12 AtulOpenbravo Note Added: 0124636
2020-12-01 12:09 hgbot Merge Request Status open => approved
2020-12-01 12:10 hgbot Resolution open => fixed
2020-12-01 12:10 hgbot Status scheduled => closed
2020-12-01 12:10 hgbot Note Added: 0124676
2020-12-01 12:10 hgbot Note Added: 0124677

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker