Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009694Openbravo ERP08. Project and service managementpublic2009-06-29 12:042012-05-25 12:10
Reporterarunkumar 
Assigned ToSandrahuguet 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP2 
Target VersionFixed in Version3.0MP12 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009694: Service project report does not accept the input filters Phase, Work type, Project Status
DescriptionIf we use the input filters Phase, Work type and Project Status to get the Service Project report it gives an error message such that it is not an accepted input.
Steps To Reproduce# Go to Project & Service Management -> Analysis Tools -> Service Project report.
# Try to retrieve the report using the filters Phase, Work type and Project Status.


Clicking "HTML Format" gives an error popup window says it is not an accepted input.

The attached screenshot is the report filtered by the "Work type" item is "Road".
Proposed Solution
Additional Information
Tags250MP2QAcylce, OB3-Reviewed, VMA-Reviewed
Relationships
related to defect 0009688 closed rakheemohanlal Project Status filter does not work in Project progress Report 
Attached Filesjpg ErrorServiceProject.JPG (144,775) 2009-06-29 12:04
https://issues.openbravo.com/file_download.php?file_id=1493&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2009-06-29 12:04arunkumarNew Issue
2009-06-29 12:04arunkumarAssigned To => rafaroda
2009-06-29 12:04arunkumarFile Added: ErrorServiceProject.JPG
2009-06-29 12:04arunkumarTag Attached: 250MP2QAcylce
2009-06-30 18:42psarobeRelationship addedrelated to 0009688
2009-06-30 18:43psarobeStatusnew => scheduled
2009-06-30 18:43psarobeAssigned Torafaroda => sathiyan
2009-06-30 18:43psarobefix_in_branch => pi
2009-07-02 14:40sathiyanAssigned Tosathiyan => rakheemohanlal
2009-07-03 09:02hgbotCheckin
2009-07-03 09:02hgbotNote Added: 0017768
2009-07-03 09:02hgbotStatusscheduled => resolved
2009-07-03 09:02hgbotResolutionopen => fixed
2009-07-03 09:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e66db04ec31214a21204d6192ae87dfb1318be5d [^]
2009-07-03 15:26shuehnerStatusresolved => new
2009-07-03 15:26shuehnerResolutionfixed => open
2009-07-03 15:26shuehnerNote Added: 0017892
2009-07-20 22:57psarobePrioritylow => high
2009-07-20 22:57psarobeStatusnew => scheduled
2009-07-20 22:57psarobefix_in_branchpi =>
2011-10-28 19:21psarobeNote Added: 0042301
2011-10-28 19:21psarobeStatusscheduled => closed
2011-10-28 19:21psarobeResolutionopen => unable to reproduce
2011-10-28 19:31psarobeNote Deleted: 0042301
2011-10-28 19:32psarobeAssigned Torakheemohanlal => jonalegriaesarte
2011-10-28 19:32psarobeStatusclosed => new
2011-10-28 19:33psarobeStatusnew => scheduled
2011-10-28 19:33psarobeTag Attached: OB3-Reviewed
2011-10-28 19:33psarobePriorityhigh => urgent
2011-10-28 19:34shuehnerIssue Monitored: shuehner
2012-02-15 19:04iciordiaAssigned Tojonalegriaesarte => vmromanos
2012-02-16 17:14vmromanosTag Attached: VMA-Reviewed
2012-05-03 12:46SandrahuguetAssigned Tovmromanos => Sandrahuguet
2012-05-03 14:11SandrahuguetNote Added: 0048333
2012-05-07 17:33hgbotCheckin
2012-05-07 17:33hgbotNote Added: 0048418
2012-05-07 17:33hgbotStatusscheduled => resolved
2012-05-07 17:33hgbotResolutionunable to reproduce => fixed
2012-05-07 17:33hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/e66db04ec31214a21204d6192ae87dfb1318be5d [^] => http://code.openbravo.com/erp/devel/pi/rev/c4b77f87c25d8e91fecec7b8f12b773bdd48a153 [^]
2012-05-07 17:42miruritaNote Added: 0048421
2012-05-07 17:42miruritaStatusresolved => closed
2012-05-07 17:42miruritaFixed in Version => 3.0MP12
2012-05-25 12:10hudsonbotCheckin
2012-05-25 12:10hudsonbotNote Added: 0049041

Notes
(0017768)
hgbot   
2009-07-03 09:02   
Repository: erp/devel/pi
Changeset: e66db04ec31214a21204d6192ae87dfb1318be5d
Author: Rakhee Mohanlal <rakhee.mohanlal <at> openbravo.com>
Date: Fri Jul 03 12:30:32 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/e66db04ec31214a21204d6192ae87dfb1318be5d [^]

Fixes Issue 9694: Service project report does not accept the input filters Phase, Work type, Project Status

---
M src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSiteJR.java
---
(0017892)
shuehner   
2009-07-03 15:26   
Re-opened. This change fixes the report, but re-opens the old security problem.
The security changes added a validation for incoming parameters but of the wrong type for smoe fields in this report, which make some of the widgets non working. This changed just removed the complete validation fixing the report but re-opening the old problem as no validation is done. Best way is to use the correct validation to solve both problems.

The parameter used for these widgets are values of a specific reference (technically value column of ad_ref_list filtered to a specific ad_reference_id). So the best filter would be to filter according to these values. Idea: use UtilityData.getReference with input parameter the ad_reference_id used in the application dictionary for the field in c_project which the request parameter filters (PROJECTKIND,PROJECTPHASE,PROJECTSTATUS) and use the getReference result (only the value field) to construct a ValueListFilter to be used for the validation.
(0048333)
Sandrahuguet   
2012-05-03 14:11   
Test Plan:
As system administrator
-Go to windows, tabs and fields and active Work Type field int service project window.
-Go to menu and active service project and project report
As F&B International Group admin
-Go to service project, and create one
 ·Organization: F&B US, Inc.
 ·Search key: project
 ·Name: project
 ·Phase: project
 ·Currency: USD (in more information)
 ·Work type: road (in more information)
 ·Add a project line, product: pear juice
-Go to service project report
 ·Phase: project
 ·Project status: open
 ·Work type: road
Click "HTML Format" and you can see the report with the project created
(0048418)
hgbot   
2012-05-07 17:33   
Repository: erp/devel/pi
Changeset: c4b77f87c25d8e91fecec7b8f12b773bdd48a153
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Thu May 03 15:17:51 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c4b77f87c25d8e91fecec7b8f12b773bdd48a153 [^]

Fixed bug 9694 Modify input filters in Service project report

---
M src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSiteJR.java
---
(0048421)
mirurita   
2012-05-07 17:42   
code review + testing OK
(0049041)
hudsonbot   
2012-05-25 12:10   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5401e185a8b0 [^]

Maturity status: Test