Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0048620 | Openbravo ERP | I. Performance | public | 2022-02-17 16:42 | 2022-03-02 15:30 |
|
| Reporter | sofidossant | |
| Assigned To | AugustoMauch | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | |
| Platform | | OS | 5 | OS Version | |
| Product Version | pi | |
| Target Version | | Fixed in Version | | |
| 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 | 0048620: Computed column are loaded even if they are inactive in tables and columns |
| Description | The computed columns are executed when the window loads even if you have them inactive in tables and columns
Just having one computed active and displayed in relation to the window launches all
|
| Steps To Reproduce | We have put the log in sql debug and having it inactive we see those computed in the window query.
Attached captures of tables and columns with only one active and the resulting query.
You will be able to see that there is the query of the antiquity column that is inactive and so on with all those that are inactive
STEPS:
1 - Open Openbravo with the "System" role.
2 - Open the table called "C_ORDER" and filter the column with SQLLOGIC.
3 - See that the column is active (leave only one active).
4 - Then filter the fields in the windows called "Sales Order, which are computed column. (search with the name).
5- Check that there is only one column computed in the fields that is active, and it is the one that remains active in point 3.
6 - Activate the log in debug in the Log Management window: org.openbravo.hibernate
7 - Open the window called SALES ORDER with the Admin role, and check the active log 6.
It will verify that you can see the XX computed columns and not just the activated ones. |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  images.tar.xz (859,144) 2022-02-17 16:42
https://issues.openbravo.com/file_download.php?file_id=16640&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2022-02-17 16:42 | sofidossant | New Issue | |
| 2022-02-17 16:42 | sofidossant | Assigned To | => AugustoMauch |
| 2022-02-17 16:42 | sofidossant | File Added: images.tar.xz | |
| 2022-02-17 16:42 | sofidossant | Modules | => Core |
| 2022-02-17 16:42 | sofidossant | Triggers an Emergency Pack | => No |
| 2022-02-17 16:45 | Practics | Issue Monitored: Practics | |
| 2022-02-17 17:57 | sofidossant | Note Added: 0135086 | |
| 2022-02-17 18:12 | sofidossant | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=23684#r23684 |
| 2022-03-02 15:29 | AugustoMauch | Note Added: 0135394 | |
| 2022-03-02 15:29 | AugustoMauch | Type | defect => design defect |