Open
Bug 735953
Opened 12 years ago
Updated 12 years ago
Filter whiteboard counts based on specific whiteboard entry
Categories
(Bugzilla :: Reporting/Charting, enhancement)
Bugzilla
Reporting/Charting
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.
Comment 1•12 years ago
|
||
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
Reporter | ||
Comment 2•12 years ago
|
||
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
Comment 4•12 years ago
|
||
This bug is about tabular reports, not buglists.
Status: RESOLVED → REOPENED
Resolution: WORKSFORME → ---
(In reply to Frédéric Buclin from comment #4) > This bug is about tabular reports, not buglists. true, however the search abilities are identical. here's a tabular report using a whiteboard regex: 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=&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=status_whiteboard&type0-0-0=regexp&value0-0-0=^.*\[snappy%3A%28p1|p2|p3%29.*%24&format=table&action=wrap
Status: REOPENED → RESOLVED
Closed: 12 years ago → 12 years ago
Resolution: --- → WORKSFORME
Comment 6•12 years ago
|
||
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.
Description
•