Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042790Openbravo ERP02. Master data managementpublic2020-01-10 06:542020-01-21 12:56
ReporterAtulOpenbravo 
Assigned ToAtulOpenbravo 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR20Q2 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0042790: Apply new HQL style in ServiceOrderLineEventHandler
Description1. Avoid use of StringBuilder use normal Strings.
2. HQL formatting is important for improving readability.
3. Avoid use of Property Constant for eg:PROPERTY_ORDERLINERELATED
Steps To Reproduce-
Proposed SolutionFollow new style available here http://wiki.openbravo.com/wiki/HQL_Coding_Conventions [^]
Additional Information
TagsNo tags attached.
Relationships
depends on design defect 0041287 acknowledged Triage Platform Base Tracking issue: Convert HQL to apply new style 
Not all the children of this issue are yet resolved or closed.
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-01-10 06:54AtulOpenbravoNew Issue
2020-01-10 06:54AtulOpenbravoAssigned To => AtulOpenbravo
2020-01-10 06:54AtulOpenbravoModules => Core
2020-01-10 06:54AtulOpenbravoTriggers an Emergency Pack => No
2020-01-10 06:54AtulOpenbravoIssue generated from0042789
2020-01-10 06:54AtulOpenbravoRelationship addeddepends on 0041287
2020-01-10 07:05AtulOpenbravoIssue cloned0042791
2020-01-14 11:55AtulOpenbravoStatusnew => scheduled
2020-01-14 11:55AtulOpenbravoNote Added: 0116844
2020-01-21 12:54hgbotCheckin
2020-01-21 12:54hgbotNote Added: 0117135
2020-01-21 12:54hgbotStatusscheduled => resolved
2020-01-21 12:54hgbotResolutionopen => fixed
2020-01-21 12:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2a6057cde2a1134e6d06c4d6450fd8e7965b7b8a [^]
2020-01-21 12:54hgbotCheckin
2020-01-21 12:54hgbotNote Added: 0117136
2020-01-21 12:56dmiguelezReview Assigned To => dmiguelez
2020-01-21 12:56dmiguelezNote Added: 0117137
2020-01-21 12:56dmiguelezStatusresolved => closed
2020-01-21 12:56dmiguelezFixed in Version => 3.0PR20Q2

Notes
(0116844)
AtulOpenbravo   
2020-01-14 11:55   
- Define two products, Type: Item, purchase and sales price
- Define Service product, Type as:Service set Linked To Product = Yes, Include Product Categories: blank, Include Products : Only those Defined, Quantity Rule: As per Product
- Relate Products created in Step 1, Related Product Category of the Product created in step 1.
- Add Purchase and Sales Price.

- Create a Sales Order for any Business Partner
- Add all the three product created in the above steps
- Select the Service Product Line, realize that Select Order Line button is visible
- Click on it and realize that P&E window opens with other two products in the list
- Select the records, try to edit Relate Quantity
- Press Done button, realize that process is successful.
(0117135)
hgbot   
2020-01-21 12:54   
Repository: erp/devel/pi
Changeset: 2a6057cde2a1134e6d06c4d6450fd8e7965b7b8a
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Jan 14 15:55:03 2020 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/2a6057cde2a1134e6d06c4d6450fd8e7965b7b8a [^]

Fixes BUG-42790: Apply new HQL style in ServiceOrderLineEventHandler

**Avoid StringBuilder for hql query string, use String and formatter
off on to improve readability of hql queries.

---
M src/org/openbravo/event/ServiceOrderLineEventHandler.java
---
(0117136)
hgbot   
2020-01-21 12:54   
Repository: erp/devel/pi
Changeset: 26d36ce92af45feff00695ca17864b83df7dc4b8
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Jan 21 12:54:45 2020 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/26d36ce92af45feff00695ca17864b83df7dc4b8 [^]

Related to ISSUE-42790: Code Review changes:
* Simplify the call to the query object

---
M src/org/openbravo/event/ServiceOrderLineEventHandler.java
---
(0117137)
dmiguelez   
2020-01-21 12:56   
Code Review + Testing Ok