Custom query request or SQL access to bugzilla

RESOLVED WONTFIX

Status

()

RESOLVED WONTFIX
7 years ago
6 years ago

People

(Reporter: jhopkins, Unassigned)

Tracking

Production

Details

(Reporter)

Description

7 years ago
We use the following query to triage our open bugs:

https://bugzilla.mozilla.org/buglist.cgi?cmdtype=dorem&remaction=run&namedcmd=MoMo%20IT&sharer_id=305876&list_id=697165

Unfortunately, it doesn't catch assigned bugs located in components we don't normally use (eg. product bugs as opposed to build/release bugs).  I played with the boolean charts for awhile and found that it's not possible to do an (A and B) or (C) type of query.

Could we (gozer and I) possibly get (a) SQL access to build a custom bugzilla query, or (b) provide a description of what we want and have someone with access build it for us?  Specifically: the above query, plus OR that with "Assignee matches regex (gozer@mozilla.com|jhopkins@mozilla.com)".
I'm a bit surprised boolean charts don't allow that. Max/Fred, do you know of any workarounds?
this is not possible with the boolean charts in bugzilla 4.0, because multiple charts are always joined with AND, not OR.

for security reasons we can't give you direct access to the database.


with the next version of bugzilla (4.2), you _can_ build this query with boolean charts:

https://landfill.bugzilla.org/bugzilla-tip/query.cgi?bug_status=UNCONFIRMED&bug_status=CONFIRMED&bug_status=IN_PROGRESS&f1=OP&f10=OP&f11=assigned_to&f2=component&f4=OP&f5=reporter&f6=assigned_to&f7=CP&f9=CP&j10=OR&j4=OR&j_top=OR&o11=regexp&o2=notequals&o5=regexp&o6=regexp&query_format=advanced&v11=nobody%40mozilla\.org|%28gozer|john.hopkins%29%40mozilla%28messaging%29%3F\.com&v2=ispdb&v5=%28gozer|john.hopkins%29%40mozilla%28messaging%29%3F\.com&v6=nobody%40mozilla\.org|%28gozer|john.hopkins%29%40mozilla%28messaging%29%3F\.com


as we're extremely close to creating a bugzilla 4.2 branch to undergo final QA, i propose waiting for BMO to be upgraded to 4.2 rather than developing a custom report which will become redundant when we upgrade.
(Reporter)

Comment 5

7 years ago
Sounds exciting!  Can you please add me to the cc: list on whatever bug is tracking the bugzilla upgrade?  Also, is there a "dev/test" bugzilla instance running 4.2 where I could go to try the new functionality prior to release?  Thanks.
We will have an upgrade tracker created once the branch is ready for us to work on. Related announcements will be sent out once an internal test instance is up and running.

In the meantime you can test your operations on the community test server at https://landfill.bugzilla.org/bugzilla-tip/ which has the same search UI that BMO 4.2 will have eventually.

dkl
(In reply to John Hopkins (:jhopkins) from comment #5)
> Sounds exciting!  Can you please add me to the cc: list on whatever bug is
> tracking the bugzilla upgrade?  Also, is there a "dev/test" bugzilla
> instance running 4.2 where I could go to try the new functionality prior to
> release?  Thanks.

bugzilla.allizom.org can be used for testing. Hoping to release 4.2 in a month or so.
Add yourself to the cc of bug 764897.

Closing as WONTFIX for current production.

dkl
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → WONTFIX
You need to log in before you can comment on or make changes to this bug.