Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009694
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 08. Project and service managementminoralways2009-06-29 12:042012-05-25 12:10
ReporterarunkumarView Statuspublic 
Assigned ToSandrahuguet 
PriorityurgentResolutionfixedFixed in Version3.0MP12
StatusclosedFix in branchFixed in SCM revisionc4b77f87c25d
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP2SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009694: 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".
Tags250MP2QAcylce, OB3-Reviewed, VMA-Reviewed
Attached Filesjpg file icon ErrorServiceProject.JPG [^] (144,775 bytes) 2009-06-29 12:04

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0009688 closedrakheemohanlal Project Status filter does not work in Project progress Report 

-  Notes
(0017768)
hgbot (developer)
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 (administrator)
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 (developer)
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 (developer)
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 (developer)
2012-05-07 17:42

 code review + testing OK
(0049041)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2009-06-29 12:04 arunkumar New Issue
2009-06-29 12:04 arunkumar Assigned To => rafaroda
2009-06-29 12:04 arunkumar File Added: ErrorServiceProject.JPG
2009-06-29 12:04 arunkumar Tag Attached: 250MP2QAcylce
2009-06-30 18:42 psarobe Relationship added related to 0009688
2009-06-30 18:43 psarobe Status new => scheduled
2009-06-30 18:43 psarobe Assigned To rafaroda => sathiyan
2009-06-30 18:43 psarobe fix_in_branch => pi
2009-07-02 14:40 sathiyan Assigned To sathiyan => rakheemohanlal
2009-07-03 09:02 hgbot Checkin
2009-07-03 09:02 hgbot Note Added: 0017768
2009-07-03 09:02 hgbot Status scheduled => resolved
2009-07-03 09:02 hgbot Resolution open => fixed
2009-07-03 09:02 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e66db04ec31214a21204d6192ae87dfb1318be5d [^]
2009-07-03 15:26 shuehner Status resolved => new
2009-07-03 15:26 shuehner Resolution fixed => open
2009-07-03 15:26 shuehner Note Added: 0017892
2009-07-20 22:57 psarobe Priority low => high
2009-07-20 22:57 psarobe Status new => scheduled
2009-07-20 22:57 psarobe fix_in_branch pi =>
2011-10-28 19:21 psarobe Note Added: 0042301
2011-10-28 19:21 psarobe Status scheduled => closed
2011-10-28 19:21 psarobe Resolution open => unable to reproduce
2011-10-28 19:31 psarobe Note Deleted: 0042301
2011-10-28 19:32 psarobe Assigned To rakheemohanlal => jonalegriaesarte
2011-10-28 19:32 psarobe Status closed => new
2011-10-28 19:33 psarobe Status new => scheduled
2011-10-28 19:33 psarobe Tag Attached: OB3-Reviewed
2011-10-28 19:33 psarobe Priority high => urgent
2011-10-28 19:34 shuehner Issue Monitored: shuehner
2012-02-15 19:04 iciordia Assigned To jonalegriaesarte => vmromanos
2012-02-16 17:14 vmromanos Tag Attached: VMA-Reviewed
2012-05-03 12:46 Sandrahuguet Assigned To vmromanos => Sandrahuguet
2012-05-03 14:11 Sandrahuguet Note Added: 0048333
2012-05-07 17:33 hgbot Checkin
2012-05-07 17:33 hgbot Note Added: 0048418
2012-05-07 17:33 hgbot Status scheduled => resolved
2012-05-07 17:33 hgbot Resolution unable to reproduce => fixed
2012-05-07 17:33 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/e66db04ec31214a21204d6192ae87dfb1318be5d [^] => http://code.openbravo.com/erp/devel/pi/rev/c4b77f87c25d8e91fecec7b8f12b773bdd48a153 [^]
2012-05-07 17:42 mirurita Note Added: 0048421
2012-05-07 17:42 mirurita Status resolved => closed
2012-05-07 17:42 mirurita Fixed in Version => 3.0MP12
2012-05-25 12:10 hudsonbot Checkin
2012-05-25 12:10 hudsonbot Note Added: 0049041

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker