Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0032121Openbravo ERPI. Performancepublic2016-02-04 11:292016-02-04 11:29
aferraz 
Triage Finance 
normalminoralways
newopen 
30Professional Appliance
 
 
Core
No
0032121: Some computed columns should not be computed
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)
N/A
No tags attached.
Issue History
2016-02-04 11:29aferrazNew Issue
2016-02-04 11:29aferrazAssigned To => Triage Finance
2016-02-04 11:29aferrazModules => Core
2016-02-04 11:29aferrazTriggers an Emergency Pack => No

There are no notes attached to this issue.