Open Bug 735953 Opened 12 years ago Updated 12 years ago

Filter whiteboard counts based on specific whiteboard entry

Categories

(Bugzilla :: Reporting/Charting, enhancement)

enhancement
Not set
normal

Tracking

()

REOPENED

People

(Reporter: lmandel, Unassigned)

Details

A common use of the Bugzilla status whiteboard field is to set priority of a cross cutting effort (that doesn't have a component) like 
Snappy ([snappy:p1], [snappy:p2],...), 
Telemetry ([telemetry:p1],...), 
or security (sg:critical, sg:moderate,...). 

When performing a count query using the Bugzilla REST API I want the ability to get the counts for the various priorities. For example, I would like to get the count of Snappy P1, P2, and P3 bugs. Currently this isn't possible due to the way in which filtering happens on the status whiteboard field. As the value of the field is used to create the count buckets, the count query results in many buckets for each priority. Again using Snappy as the example, some of the buckets that results when querying for [snappy:p1] are:
[telemetry][snappy:p1]
[snappy:p1][qa-wanted]
[snappy:p1][ux-wanted]

I want the ability to filter the portion of the status whiteboard that I am interested in using for the bucket so that all of the cases in the above example are counted in a single [snappy:p1] bucket.
BzAPI's abilities in this area are backed by this:
https://bugzilla.mozilla.org/query.cgi?format=report-table

If you can do what you want using that, then BzAPI can do it with a very similar query. If you can't, then you'll need to file a bug to get Bugzilla itself enhanced first.

Gerv
Transferring over to Bugzilla.

Here is a specific query to demonstrate the issue. In this query I would like to see all the bugs that include "[snappy" in the whiteboard. In this case I would like the output buckets to be:

[snappy]
[snappy:p1]
[snappy:p2]
[snappy:p3]

As you can see in the query, I get many more buckets because the entire string in the whiteboard field is used to create the buckets.

As a suggested approach, the whiteboard search field can be modified so that I can specify the portion of the whiteboard entry that I am interested in, for example, using a regex like:

^.*\[snappy:(p1|p2|p3).*$

The portion of the whiteboard entry that is used to create the buckets is found within the parenthesis.

https://bugzilla.mozilla.org/report.cgi?x_axis_field=status_whiteboard&y_axis_field=&z_axis_field=&query_format=report-table&short_desc_type=allwordssubstr&short_desc=&bug_status=NEW&resolution=---&resolution=DUPLICATE&longdesc_type=allwordssubstr&longdesc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&status_whiteboard_type=allwordssubstr&status_whiteboard=[snappy&keywords_type=allwords&keywords=&bug_id=&bug_id_type=anyexact&votes=&votes_type=greaterthaneq&emailassigned_to1=1&emailtype1=exact&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailtype2=exact&email2=&emailtype3=substring&email3=&chfieldvalue=&chfieldfrom=&chfieldto=Now&field0-0-0=noop&type0-0-0=noop&value0-0-0=&format=table&action=wrap
Assignee: gerv → charting
Component: BzAPI → Reporting/Charting
Product: Webtools → Bugzilla
QA Contact: bzapi → default-qa
Version: Trunk → unspecified
you can already use regex's on bugzilla, using the 'custom search' facility:

https://bugzilla.mozilla.org/buglist.cgi?list_id=2603652;type0-0-0=regexp;query_format=advanced;field0-0-0=status_whiteboard;value0-0-0=^.*\[snappy%3A%28p1|p2|p3%29.*%24
Status: NEW → RESOLVED
Closed: 12 years ago
Resolution: --- → WORKSFORME
This bug is about tabular reports, not buglists.
Status: RESOLVED → REOPENED
Resolution: WORKSFORME → ---
See comment 0 vs comment 2! Lawrence is asking to group all bugs with the same substring into one group. You cannot do that currently.
Status: RESOLVED → REOPENED
Resolution: WORKSFORME → ---
You need to log in before you can comment on or make changes to this bug.