Bug 973802

Summary: report.cgi - returns WRONG results
Product: [Community] Bugzilla Reporter: Chandrasekar Kannan <ckannan>
Component: Reporting/ChartingAssignee: Simon Green <sgreen>
Status: CLOSED UPSTREAM QA Contact: tools-bugs <tools-bugs>
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 4.4CC: benl, ebaak, rjoost
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-06-12 21:13:35 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Chandrasekar Kannan 2013-06-12 19:11:42 UTC 
I used bugzilla's report.cgi to generate a couple of tabular reports.

For example, a list of bugs that was changed to MODIFIED status from 2013-06-01 to 2013-06-07 for product - Red Hat Storage

https://bugzilla.redhat.com/report.cgi?x_axis_field=&y_axis_field=priority&z_axis_field=&no_redirect=1&query_format=report-table&short_desc_type=allwordssubstr&short_desc=&classification=Red+Hat&product=Red+Hat+Storage&longdesc_type=allwordssubstr&longdesc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=&keywords_type=allwords&keywords=&deadlinefrom=&deadlineto=&bug_id=&bug_id_type=anyexact&emailtype1=substring&email1=&emailtype2=substring&email2=&emailtype3=substring&email3=&chfield=bug_status&chfieldvalue=MODIFIED&chfieldfrom=2013-06-01&chfieldto=2013-06-07&j_top=AND&f1=noop&o1=noop&v1=&format=table&action=wrap

the above query returns BZ https://bugzilla.redhat.com/show_activity.cgi?id=968289 which as you can see clearly does not belong.  

I have seen many inconsistencies like this. 

Please fix report.cgi. 

Thanks.
Comment 1 Simon Green 2013-06-12 21:13:35 UTC 
It's a known issue, and being worked on by upstream.