Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0009688Openbravo ERP08. Project and service managementpublic2009-06-29 09:442009-07-16 17:55
arunkumar 
rakheemohanlal 
urgentmajoralways
closedfixed 
5
2.50MP2 
pi 
Core
No
0009688: Project Status filter does not work in Project progress Report
If we give inputs for the Project Progress report using the filter "Project Status" then it gives error such that it is not an accepted input.
# Go to Project & Service Management -> Analysis Tools -> Project Progress
# Give the reference date as 29-06-2009
# Select "open" in the input filter Project Status.
# Click "HTML Format".

Error popup message appears and it says "Input : OP is not an accepted input"
We should be able to use the Project Status input filter.
250MP2QAcylce
related to design defect 0009690 closed alostale Clicking back button in the Project progress report never ends loading. 
related to defect 0009694 closed Sandrahuguet Service project report does not accept the input filters Phase, Work type, Project Status 
jpg ProjectProgressReport.JPG (160,498) 2009-06-29 09:44
https://issues.openbravo.com/file_download.php?file_id=1490&type=bug
jpg
Issue History
2009-06-29 09:44arunkumarNew Issue
2009-06-29 09:44arunkumarAssigned To => rafaroda
2009-06-29 09:44arunkumarFile Added: ProjectProgressReport.JPG
2009-06-29 10:58arunkumarTag Attached: 250MP2QAcylce
2009-06-30 18:38psarobeAssigned Torafaroda => sathiyan
2009-06-30 18:38psarobePrioritylow => urgent
2009-06-30 18:38psarobeSeverityminor => major
2009-06-30 18:38psarobeStatusnew => scheduled
2009-06-30 18:39psarobeRelationship addedrelated to 0009690
2009-06-30 18:42psarobeRelationship addedrelated to 0009694
2009-07-01 12:29sathiyanAssigned Tosathiyan => rakheemohanlal
2009-07-03 06:29hgbotCheckin
2009-07-03 06:29hgbotNote Added: 0017761
2009-07-03 06:29hgbotStatusscheduled => resolved
2009-07-03 06:29hgbotResolutionopen => fixed
2009-07-03 06:29hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/802a8eb91eec6a2d200ae26a9533819552a98ac1 [^]
2009-07-03 15:27shuehnerStatusresolved => new
2009-07-03 15:27shuehnerResolutionfixed => open
2009-07-03 15:27shuehnerNote Added: 0017893
2009-07-15 11:27hgbotCheckin
2009-07-15 11:27hgbotNote Added: 0018252
2009-07-15 11:27hgbotStatusnew => resolved
2009-07-15 11:27hgbotResolutionopen => fixed
2009-07-15 11:27hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/802a8eb91eec6a2d200ae26a9533819552a98ac1 [^] => http://code.openbravo.com/erp/devel/pi/rev/98711645ff0d8e15e985003eb9657bfd3d873a15 [^]
2009-07-16 13:05sureshbabuStatusresolved => closed
2009-07-16 13:05sureshbabuNote Added: 0018311
2009-07-16 13:05sureshbabuFixed in Version => pi
2009-07-16 17:55anonymoussf_bug_id0 => 2822579

Notes
(0017761)
hgbot   
2009-07-03 06:29   
Repository: erp/devel/pi
Changeset: 802a8eb91eec6a2d200ae26a9533819552a98ac1
Author: Rakhee Mohanlal <rakhee.mohanlal <at> openbravo.com>
Date: Fri Jul 03 09:58:11 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/802a8eb91eec6a2d200ae26a9533819552a98ac1 [^]

Fixes Issue 9688: Project Status filter does not work in Project progress Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProgress.java
---
(0017893)
shuehner   
2009-07-03 15:27   
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 (PROJECTSTATUS) and use the getReference result (only the value field) to construct a ValueListFilter to be used for the validation.
(0018252)
hgbot   
2009-07-15 11:27   
Repository: erp/devel/pi
Changeset: 98711645ff0d8e15e985003eb9657bfd3d873a15
Author: Rakhee Mohanlal <rakhee.mohanlal <at> openbravo.com>
Date: Wed Jul 15 14:55:32 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/98711645ff0d8e15e985003eb9657bfd3d873a15 [^]

Fixes Issue 9688: Project Status filter does not work in Project progress Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProgress.java
M src/org/openbravo/erpCommon/utility/Utility.java
M src/org/openbravo/erpCommon/utility/Utility_data.xsql
---
(0018311)
sureshbabu   
2009-07-16 13:05   
Tested the Project progress report, filter Project status with value open is working fine