Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0045412 | ||||||||
| 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 | |||
| Reporter | Leyre | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| 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 | |||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 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: 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 [^] | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0124359) cberner (developer) 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 (developer) 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 (developer) 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 [^] |
|
Notes |
|
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 | Modules | => Core |
| 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 | 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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |