Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0054882 | Openbravo ERP | 00. Application dictionary | public | 2024-03-07 16:26 | 2024-04-15 09:19 |
|
| Reporter | vmromanos | |
| Assigned To | AugustoMauch | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | PR24Q3 | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0054882: Fields related to sqllogic columns are force to be read only |
| Description | When a column is defined with a SQL Logic, the associated field is always force to be read only.
However, for P&E windows, it might be needed to allow editing this field, as it might be sent as input parameter to the handler in the server. |
| Steps To Reproduce | To be able to reproduce the issue, apply the attached 54882_reproducer.diff or:
As System Admin:
Create a dummy column "M_Warehouse_ID" (Tabledir) in M_Storage_Detail table with sql logic = select max(l.m_warehouse_id) from m_locator l
Go to Window, Tabs and fields and find the "Box Handling Unit P&E".
Go to tab, then fields
Add a new field for the new column. Make sure it's shown in grid and is not set as read only.
Then:
Run ant smartbuild
Go to Handling unit window, create a new record and press the Box button.
In the grid see the field is displayed, but it can't be edited. This is wrong, the user should be able to change the value if the field is not readonly |
| Proposed Solution | Attached a patch that works for me. Please check other scenarios. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | blocks | feature request | 0054667 | | scheduled | vmromanos | Support nested handling units |
|
| Attached Files |  54882-proposed-solution.diff (1,248) 2024-03-07 16:30
https://issues.openbravo.com/file_download.php?file_id=19530&type=bug
54882_reproducer.diff (8,217) 2024-04-08 12:02
https://issues.openbravo.com/file_download.php?file_id=19625&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2024-03-07 16:26 | vmromanos | New Issue | |
| 2024-03-07 16:26 | vmromanos | Assigned To | => Triage Platform Base |
| 2024-03-07 16:26 | vmromanos | Modules | => Core |
| 2024-03-07 16:26 | vmromanos | Triggers an Emergency Pack | => No |
| 2024-03-07 16:30 | vmromanos | File Added: 54882-proposed-solution.diff | |
| 2024-03-12 17:38 | vmromanos | Relationship added | blocks 0054667 |
| 2024-03-21 23:19 | AugustoMauch | Status | new => acknowledged |
| 2024-04-08 08:44 | AugustoMauch | Assigned To | Triage Platform Base => AugustoMauch |
| 2024-04-08 12:02 | AugustoMauch | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=27776#r27776 |
| 2024-04-08 12:02 | AugustoMauch | File Added: 54882_reproducer.diff | |
| 2024-04-08 12:04 | AugustoMauch | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=27777#r27777 |
| 2024-04-08 12:07 | hgbot | Note Added: 0162917 | |
| 2024-04-08 12:09 | AugustoMauch | Status | acknowledged => scheduled |
| 2024-04-08 12:10 | AugustoMauch | Status | scheduled => resolved |
| 2024-04-08 12:10 | AugustoMauch | Fixed in SCM revision | => https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1184/diffs?commit_id=9407d8a3ec4ea7990125573a44980816e1a487ed [^] |
| 2024-04-08 12:10 | AugustoMauch | Resolution | open => fixed |
| 2024-04-15 09:19 | hgbot | Status | resolved => closed |
| 2024-04-15 09:19 | hgbot | Fixed in Version | => PR24Q3 |
| 2024-04-15 09:19 | hgbot | Note Added: 0163174 | |
| 2024-04-15 09:19 | hgbot | Note Added: 0163175 | |