669754 - Custom query request or SQL access to bugzilla

Status: RESOLVED WONTFIX

(bugzilla.mozilla.org :: General, defect)

Description

[John Hopkins (:jhopkins)]

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 ([e-mail]|[e-mail])".

Comment 1

[Reed Loden [:reed]]

I'm a bit surprised boolean charts don't allow that. Max/Fred, do you know of any workarounds?

Comment 2

[Frédéric Buclin]

I'm not sure which query you want exactly, but something like that?

https://bugzilla.mozilla.org/buglist.cgi?field0-0-0=component&type0-0-1=regexp&field0-0-1=assigned_to&query_format=advanced&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&value0-0-1=%28gozer|jhopkins%29%40mozilla.com&type0-0-0=anyexact&value0-0-0=%22AUS%20Server%22%2C%20Office%2C%20%22Release%20Engineering%22%2C%20Security%2C%20%22Server%20Operations%22%2C%20Try%20Server&product=Mozilla%20Messaging

Comment 3

[John Hopkins (:jhopkins)]

The query I pasted was a saved query - here it is in full form:

https://bugzilla.mozilla.org/query.cgi?bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&columnlist=bug_severity%2Cpriority%2Cassigned_to%2Creporter%2Cbug_status%2Ccomponent%2Cshort_desc&component=AUS%20Server&component=Office&component=Release%20Engineering&component=Security&component=Server%20Operations&component=Try%20Server&email1=nobody%40mozilla.org|%28gozer|john.hopkins%29%40mozilla%28messaging%29%3F.com&emailassigned_to1=1&emailreporter1=1&emailtype1=regexp&product=Mozilla%20Messaging&query_format=advanced&type0-0-0=equals&known_name=MoMo%20IT

So I'd like the results of the above query merged with the results of the query below:

https://bugzilla.mozilla.org/buglist.cgi?list_id=698474&emailtype1=regexp&emailassigned_to1=1&query_format=advanced&bug_status=UNCONFIRMED&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&email1=%28jhopkins%40mozilla.com|gozer%40mozilla.com%29

Comment 4

[:glob ✱]

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.

Comment 5

[John Hopkins (:jhopkins)]

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.

Comment 6

[David Lawrence [:dkl]]

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

Comment 7

[David Lawrence [: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