Issue 85745 - TOP-Voted Issues
Summary: TOP-Voted Issues
Status: CLOSED WONT_FIX
Alias: None
Product: Infrastructure
Classification: Infrastructure
Component: Bugzilla (show other issues)
Version: current
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: issues@www
QA Contact: issues@ooo
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-01-30 18:27 UTC by discoleo
Modified: 2017-05-20 09:42 UTC (History)
2 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description discoleo 2008-01-30 18:27:51 UTC
I do NOT know any way to get a listing of the TOP-Voted issues.

The query page: http://qa.openoffice.org/issues/reports.cgi does NOT offer any
such options.

My search for such an option failed altogether. This feature should be highly
visible, and, IF it is already implemented, it is quite well hidden.

Therefore, this feature should be implemented and made visible in the top-pages
of issue-zilla.

Additionally, I would like to get listings of:
 - top issues sorted on number of votes
 - top issues sorted based on OOo modules (i.e. Writer, Calc, ...)
   and votes
 - top issues sorted on year and votes
 - ability to limit number of issues
   [e.g. to first 25 issues / category]

Mayve other options.
Comment 1 frank.loehmann 2008-01-30 19:28:35 UTC
This is already possible. Please use the following query form:
http://qa.openoffice.org/issues/query.cgi
At the end of this form (above the text 'Run this query') you will find a sectin
which allows you to build the query you are looking for.
Comment 2 discoleo 2008-01-30 20:43:18 UTC
Hi Frank,

> Please use the following query form:
> http://qa.openoffice.org/issues/query.cgi
>
> Thanks to Drew (many thanks), I found one solution. Though, as said,
> there is none directly accessible through the web-interface.

Unfortunately, I was not able to sort the query based on the number of votes (in
descending order). And the resulting list does not display the number of votes
for every issue. Maybe I am making something wrong, but unfortunately, this is
not documented anywhere.

In the end I found a solution (many thanks to Drew). Though, I still hope that
this gets implemented in the web interface:

> Base
http://www.openoffice.org/issues/buglist.cgi?resort=1&issue_type=DEFECT;issue_type=ENHANCEMENT;issue_type=FEATURE;component=Database%20access;issue_status=UNCONFIRMED;issue_status=NEW;issue_status=STARTED;issue_status=REOPENED;email1=;emailtype1=exact;emailassigned_to1=1;email2=;emailtype2=exact;emailreporter2=1;issueidtype=include;issue_id=;changedin=;votes=10;chfield=creation_ts;chfieldfrom=;chfieldto=;chfieldvalue=;short_desc=;short_desc_type=allwords;long_desc=;long_desc_type=allwords;issue_file_loc=;issue_file_loc_type=fulltext;status_whiteboard=;status_whiteboard_type=fulltext;keywords=;keywords_type=anytokens;field0-0-0=noop;type0-0-0=noop;value0-0-0=;namedcmd=Base%20RFE;newqueryname=;Submit%20query=Submit%20query&order=issues.votes%20desc%2C%20issues.issue_status%2C%20issues.priority%2C%20issues.issue_id

> Calc
http://www.openoffice.org/issues/buglist.cgi?resort=1&issue_type=DEFECT;issue_type=ENHANCEMENT;issue_type=FEATURE;component=Spreadsheet;issue_status=UNCONFIRMED;issue_status=NEW;issue_status=STARTED;issue_status=REOPENED;email1=;emailtype1=exact;emailassigned_to1=1;email2=;emailtype2=exact;emailreporter2=1;issueidtype=include;issue_id=;changedin=;votes=10;chfield=creation_ts;chfieldfrom=;chfieldto=;chfieldvalue=;short_desc=;short_desc_type=allwords;long_desc=;long_desc_type=allwords;issue_file_loc=;issue_file_loc_type=fulltext;status_whiteboard=;status_whiteboard_type=fulltext;keywords=;keywords_type=anytokens;field0-0-0=noop;type0-0-0=noop;value0-0-0=;namedcmd=Base%20RFE;newqueryname=;Submit%20query=Submit%20query&order=issues.votes%20desc%2C%20issues.issue_status%2C%20issues.priority%2C%20issues.issue_id

> Draw
http://www.openoffice.org/issues/buglist.cgi?resort=1&issue_type=DEFECT;issue_type=ENHANCEMENT;issue_type=FEATURE;component=Drawing;issue_status=UNCONFIRMED;issue_status=NEW;issue_status=STARTED;issue_status=REOPENED;email1=;emailtype1=exact;emailassigned_to1=1;email2=;emailtype2=exact;emailreporter2=1;issueidtype=include;issue_id=;changedin=;votes=10;chfield=creation_ts;chfieldfrom=;chfieldto=;chfieldvalue=;short_desc=;short_desc_type=allwords;long_desc=;long_desc_type=allwords;issue_file_loc=;issue_file_loc_type=fulltext;status_whiteboard=;status_whiteboard_type=fulltext;keywords=;keywords_type=anytokens;field0-0-0=noop;type0-0-0=noop;value0-0-0=;namedcmd=Base%20RFE;newqueryname=;Submit%20query=Submit%20query&order=issues.votes%20desc%2C%20issues.issue_status%2C%20issues.priority%2C%20issues.issue_id

> Impress
http://www.openoffice.org/issues/buglist.cgi?resort=1&issue_type=DEFECT;issue_type=ENHANCEMENT;issue_type=FEATURE;component=Presentation;issue_status=UNCONFIRMED;issue_status=NEW;issue_status=STARTED;issue_status=REOPENED;email1=;emailtype1=exact;emailassigned_to1=1;email2=;emailtype2=exact;emailreporter2=1;issueidtype=include;issue_id=;changedin=;votes=10;chfield=creation_ts;chfieldfrom=;chfieldto=;chfieldvalue=;short_desc=;short_desc_type=allwords;long_desc=;long_desc_type=allwords;issue_file_loc=;issue_file_loc_type=fulltext;status_whiteboard=;status_whiteboard_type=fulltext;keywords=;keywords_type=anytokens;field0-0-0=noop;type0-0-0=noop;value0-0-0=;namedcmd=Base%20RFE;newqueryname=;Submit%20query=Submit%20query&order=issues.votes%20desc%2C%20issues.issue_status%2C%20issues.priority%2C%20issues.issue_id

> Writer
http://www.openoffice.org/issues/buglist.cgi?resort=1&issue_type=DEFECT;issue_type=ENHANCEMENT;issue_type=FEATURE;component=Word%20processor;issue_status=UNCONFIRMED;issue_status=NEW;issue_status=STARTED;issue_status=REOPENED;email1=;emailtype1=exact;emailassigned_to1=1;email2=;emailtype2=exact;emailreporter2=1;issueidtype=include;issue_id=;changedin=;votes=10;chfield=creation_ts;chfieldfrom=;chfieldto=;chfieldvalue=;short_desc=;short_desc_type=allwords;long_desc=;long_desc_type=allwords;issue_file_loc=;issue_file_loc_type=fulltext;status_whiteboard=;status_whiteboard_type=fulltext;keywords=;keywords_type=anytokens;field0-0-0=noop;type0-0-0=noop;value0-0-0=;namedcmd=Base%20RFE;newqueryname=;Submit%20query=Submit%20query&order=issues.votes%20desc%2C%20issues.issue_status%2C%20issues.priority%2C%20issues.issue_id

> All Modules - more then 25 votes
http://www.openoffice.org/issues/buglist.cgi?resort=1&issue_type=DEFECT;issue_type=ENHANCEMENT;issue_type=FEATURE;issue_status=UNCONFIRMED;issue_status=NEW;issue_status=STARTED;issue_status=REOPENED;email1=;emailtype1=exact;emailassigned_to1=1;email2=;emailtype2=exact;emailreporter2=1;issueidtype=include;issue_id=;changedin=;votes=25;chfield=creation_ts;chfieldfrom=;chfieldto=;chfieldvalue=;short_desc=;short_desc_type=allwords;long_desc=;long_desc_type=allwords;issue_file_loc=;issue_file_loc_type=fulltext;status_whiteboard=;status_whiteboard_type=fulltext;keywords=;keywords_type=anytokens;field0-0-0=noop;type0-0-0=noop;value0-0-0=;namedcmd=Base%20RFE;newqueryname=;Submit%20query=Submit%20query&order=issues.votes%20desc%2C%20issues.issue_status%2C%20issues.priority%2C%20issues.issue_id

> Copy to your browser and then select 'Edit Query' you can play with the 
> resetting the floor values for Votes to limit or expand the returned 
> number of records. Votes is about found about 2/3 of the way down the form.
> 
> HTH
>
> Drew

Again, many thanks.

But I sincerely hope that this gets implemented in the web interface.
Comment 3 discoleo 2008-01-30 21:14:23 UTC
Another useful page is:
http://wiki.services.openoffice.org/wiki/QA_Metrics
[Thanks to Kirill.]

I got also further improtant informations from Drew. Many thanks for this
extended help.

To sort the displayed list of issues simply click on the column heading 
you want to sort on.

> To add a column to the display you click on the link 'Change columns' 
> found on the next to last line of the listing page. You will get a page 
> with check boxes for all available fields, simply tick the ones you want 
> displayed or un-tick for removal.

Many thanks to this precious help.

ERRATA
I had a small formatting error in my previous message:

  "Thanks to Drew (many thanks), I found one solution. Though, as said,
   there is none directly accessible through the web-interface."

Should have been unquoted, as it was my own writing (NOT from Frank). It got
somehow mixed with the wrong quote. Apologies. I did not notice it. (And I bash
at the laptop developers for implementing all sort of useless keybord shortcuts
that only make things unpredictable! Especially when erroneously pressing the
wrong key, like so often happens on a laptop.)
Comment 4 stx123 2011-03-23 16:17:36 UTC
Reset QA Contact to new default
Comment 5 Kay 2012-06-21 21:27:58 UTC
It seems the reporter found a work around for querying QA issues.