Bug 844516 - Too many report options
Summary: Too many report options
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Bugzilla
Classification: Community
Component: Reporting/Charting
Version: 4.2
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: 4.2-6
Assignee: Simon Green
QA Contact: tools-bugs
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-07-31 01:26 UTC by Simon Green
Modified: 2018-12-09 06:29 UTC (History)
2 users (show)

Fixed In Version: 4.2.4-6
Clone Of:
Environment:
Last Closed: 2012-11-15 03:54:35 UTC
Embargoed:


Attachments (Terms of Use)

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


Note You need to log in before you can comment on or make changes to this bug.