Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041255Openbravo ERP08. Project and service managementpublic2019-07-03 16:522019-08-01 08:41
Reportershuehner 
Assigned ToAtulOpenbravo 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR19Q2.1Fixed in Version3.0PR19Q2.1 
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
Summary0041255: ReportProjectProfitabilityJR.noConversionToHours is not using bind-params
DescriptionThis code is not using bind-params:

    if (StringUtils.isNotEmpty(strOrg)) {
      hsqlScript.append(" and p." + Project.PROPERTY_ORGANIZATION + ".id in (" + strOrg + ")");
    }

When fixing please apply new HQL-style to every HQL in this file.
Steps To Reproduce-
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00412533.0PR19Q4 closed AtulOpenbravo ReportProjectProfitabilityJR.noConversionToHours is not using bind-params 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-07-03 16:53shuehnerTypedefect => backport
2019-07-03 16:53shuehnerTarget Version => 3.0PR19Q2.1
2019-07-17 11:26hgbotCheckin
2019-07-17 11:26hgbotNote Added: 0113471
2019-07-17 11:26hgbotStatusscheduled => resolved
2019-07-17 11:26hgbotResolutionopen => fixed
2019-07-17 11:26hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR19Q2.1/rev/f11c024628de5be12038b7cfef88b855ec229118 [^]
2019-07-17 11:28dmiguelezReview Assigned To => dmiguelez
2019-07-17 11:28dmiguelezNote Added: 0113475
2019-07-17 11:28dmiguelezStatusresolved => closed
2019-07-17 11:28dmiguelezFixed in Version => 3.0PR19Q2.1
2019-08-01 08:41SandrahuguetAssigned ToTriage Finance => AtulOpenbravo

Notes
(0113471)
hgbot   
2019-07-17 11:26   
Repository: erp/backports/3.0PR19Q2.1
Changeset: f11c024628de5be12038b7cfef88b855ec229118
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Mon Jul 15 18:16:43 2019 +0530
URL: http://code.openbravo.com/erp/backports/3.0PR19Q2.1/rev/f11c024628de5be12038b7cfef88b855ec229118 [^]

Fixes Issue 41255: ReportProjectProfitabilityJR.noConversionToHours
is not using bind-params

Applied bind-params to organization ids in noConversionToHours
method. Organization ids are obtained from OrganizationStructureProvider

---
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.java
---
(0113475)
dmiguelez   
2019-07-17 11:28   
Code Review + Testing Ok