Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0045412Openbravo ERPA. Platformpublic2020-11-10 18:192020-12-01 12:10
0045412: Filters in Backend do not work correctly
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"
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: [^]
No tags attached.
related to defect 0045177 closed cberner filter field hover is not escaped 
Issue History
2020-11-10 18:19LeyreNew Issue
2020-11-10 18:19LeyreAssigned To => platform
2020-11-10 18:19LeyreModules => Core
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:10hgbotNote Added: 0124635
2020-11-26 19:12AtulOpenbravoNote Added: 0124636
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

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.
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
2020-11-26 19:10   
Merge Request created: [^]
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.
2020-12-01 12:10   
Directly closing issue as related merge request is already approved.

Repository: [^]
Changeset: 5ff936c9a21f8c3b8e9542378aa2f9e891300d4b
Author: Atul Gaware <>
Date: 2020-11-26T23:29:18+05:30
URL: [^]

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
2020-12-01 12:10   
Merge request merged: [^]