Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0048620 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| design defect | [Openbravo ERP] I. Performance | major | always | 2022-02-17 16:42 | 2022-03-02 15:30 | |||||||
| Reporter | sofidossant | View Status | public | |||||||||
| Assigned To | AugustoMauch | |||||||||||
| Priority | high | Resolution | open | Fixed in Version | ||||||||
| Status | new | 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 | pi | 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 | 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. | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files |  images.tar.xz [^] (859,144 bytes) 2022-02-17 16:42 | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0135086) sofidossant (developer) 2022-02-17 17:57 |
Add video with steps https://www.youtube.com/watch?v=orQ31h5szEw&ab_channel=CristianAdrian%7CPracticsBS [^] |
|
(0135394) AugustoMauch (administrator) 2022-03-02 15:29 |
Moved to design defect because of the way computed columns currently work. If any computed column is displayed on a grid, all of them will be computed. If one is disabled but any other remains, all of them are executed |
|
Notes |
|
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 | View Revisions |
| 2022-03-02 15:29 | AugustoMauch | Note Added: 0135394 | |
| 2022-03-02 15:29 | AugustoMauch | Type | defect => design defect |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |