Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0032121 | Openbravo ERP | I. Performance | public | 2016-02-04 11:29 | 2016-02-04 11:29 |
| Reporter | aferraz | ||||
| Assigned To | Triage Finance | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | new | Resolution | open | ||
| Platform | OS | 30 | OS Version | Professional Appliance | |
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | No | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0032121: Some computed columns should not be computed | ||||
| Description | Some computed columns should be reviewed and updated in case they could be a normal column instead of a computed one: - processed_logic column in S_TimeExpense table: select processed from S_TimeExpense TE where TE.S_TimeExpense_id=S_TimeExpense_id - closedStat column in MA_WorkRequirement table: select closed from dual - date_end column in OBRE_Reservation table: (select end_time from obre_reservation r where r.obre_reservation_id = obre_reservation_id) - time_end in OBRE_Reservation table: (select to_char(end_time, 'HH12:MI:SS') from obre_reservation r where r.obre_reservation_id = obre_reservation_id) - date_start in OBRE_Reservation table: (select start_time from obre_reservation r where r.obre_reservation_id = obre_reservation_id) - time_start in OBRE_Reservation table: (select to_char(start_time, 'HH12:MI:SS') from obre_reservation r where r.obre_reservation_id = obre_reservation_id) Also some sqllogic of them could be improved: - lastreconciliation column in FIN_Financial_Account table: (select max(fr.dateto) from fin_financial_account ff , fin_reconciliation fr where ff.fin_financial_account_id=fr.fin_financial_account_id and ff.fin_financial_account_id=fin_financial_account_id) | ||||
| Steps To Reproduce | N/A | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2016-02-04 11:29 | aferraz | New Issue | |||
| 2016-02-04 11:29 | aferraz | Assigned To | => Triage Finance | ||
| 2016-02-04 11:29 | aferraz | OBNetwork customer | => No | ||
| 2016-02-04 11:29 | aferraz | Modules | => Core | ||
| 2016-02-04 11:29 | aferraz | Triggers an Emergency Pack | => No | ||
| There are no notes attached to this issue. |