|View Issue Details|
|Type||Category||Severity||Reproducibility||Date Submitted||Last Update|
|defect||[Openbravo ERP] A. Platform||major||always||2020-11-10 18:19||2020-12-01 12:10|
|Priority||high||Resolution||fixed||Fixed in Version|
|Status||closed||Fix in branch||Fixed in SCM revision|
|OS Version||Database version||Ant version|
|Product Version||SCM revision|
|Review Assigned To|
|Regression introduced in release|
|Regression introduced by commit|
|Triggers an Emergency Pack||No|
0045412: Filters in Backend do not work correctly
|Description||Filters 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 Reproduce||1. Open Backend:|
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:
|Tags||No tags attached.|
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.
- 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
Merge Request created: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder/-/merge_requests/2 [^]
|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.|
Directly closing issue as related merge request is already approved.
Repository: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder [^]
Author: Atul Gaware <email@example.com>
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
Merge request merged: https://gitlab.com/openbravo/product/mods/org.openbravo.distributionorder/-/merge_requests/2 [^]
|2020-11-10 18:19||Leyre||New Issue|
|2020-11-10 18:19||Leyre||Assigned To||=> platform|
|2020-11-10 18:19||Leyre||Modules||=> Core|
|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||Note Added: 0124635|
|2020-11-26 19:12||AtulOpenbravo||Note Added: 0124636|
|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|