Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024283Retail ModulesWeb POSpublic2013-07-08 13:562014-04-28 18:17
Reportermigueldejuana 
Assigned Tomigueldejuana 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR14Q2 
Merge Request Status
Review Assigned Tomigueldejuana
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024283: Avoid using computed columns
DescriptionWe should avoid using computed columns because the way that they are going to work will be change and perhaps it is not best implementation looking performance.

One case is deliveryStatus column in PaidReceiptsHeader.java
Steps To ReproduceSee Description
Proposed SolutionObtain columns to calculate this field or look to another way to obtain this value.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0024516RMP26 closed guilleaer WebPOS relies on delivery status to check if a ticket is a layaway 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-07-08 13:56migueldejuanaNew Issue
2013-07-08 13:56migueldejuanaAssigned To => migueldejuana
2013-08-09 11:07guilleaerRelationship addedrelated to 0024516
2013-08-13 08:32guilleaerNote Added: 0060583
2014-04-28 18:17migueldejuanaReview Assigned To => migueldejuana
2014-04-28 18:17migueldejuanaNote Added: 0066657
2014-04-28 18:17migueldejuanaStatusnew => closed
2014-04-28 18:17migueldejuanaResolutionopen => fixed
2014-04-28 18:17migueldejuanaFixed in Version => RR14Q2

Notes
(0060583)
guilleaer   
2013-08-13 08:32   
Temporary fix:
http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/56c4d15d2a313f7d591ac9b41ff6bc329e68d3b2 [^]

We should try to avoid computedColumns on queries
(0066657)
migueldejuana   
2014-04-28 18:17   
Already done