Bug 844516

Summary:	Too many report options
Product:	[Community] Bugzilla	Reporter:	Simon Green <sgreen>
Component:	Reporting/Charting	Assignee:	Simon Green <sgreen>
Status:	CLOSED CURRENTRELEASE	QA Contact:	tools-bugs <tools-bugs>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	4.2	CC:	ebaak, jingwang
Target Milestone:	4.2-6
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:	4.2.4-6	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2012-11-15 03:54: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 Simon Green 2012-07-31 01:26:24 UTC

Description of problem:
There are too many unused statuses and resolution values in the 'Chart dataset' drop down in the old reports page.

Version-Release number of selected component (if applicable):
4.2.2-4

How reproducible:
always.

Steps to Reproduce:
1. Upgrade to Bugzilla 4.2.2-4 (for bug 821671)
2. Visit https://bugzilla.redhat.com/reports.cgi
3. Look at all the values in the 'Charts dataset' drop down.
  
Actual results:
Lots of values that were used once upon a time ago

Expected results:
Should show the currently active bug statuses and resolutions only by default.

Additional info:
This will also make the page load a *lot* quicker too.

Comment 7 Simon Green 2012-10-31 00:55:36 UTC

Eek. I am adding an index on that table which should solve the problem. If it does, I'll create a new patch that does this in production.

  -- simon

Comment 9 Simon Green 2012-11-02 01:43:07 UTC

For HSS NAY QE:

Once you have updated the new packages, and completed the post release instructions, you will need to run

./collectstats.pl --regenerate

this will take some time (up to 24 hours) to run.

  -- simon