Bug 1808906 - RFE: Add a timebox to status comparisons in advanced search
Summary: RFE: Add a timebox to status comparisons in advanced search
Keywords:
Status: CLOSED DEFERRED
Alias: None
Product: Bugzilla
Classification: Community
Component: Query/Bug List
Version: 5.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: PnT DevOps Devs
QA Contact: tools-bugs
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2020-03-01 23:35 UTC by Brendan Conoboy
Modified: 2020-03-02 04:08 UTC (History)
3 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2020-03-02 04:08:34 UTC
Embargoed:


Attachments (Terms of Use)

Description Brendan Conoboy 2020-03-01 23:35:10 UTC
The advanced search feature of bugzilla allows searching for status changes and it allows for time boxing of date fields, but it lacks the ability to narrow results to a time box around status changes.  Having the ability to query when a transition happened would be very useful.  Something like:

( ( Status | changed from | NEW ) && before -7d )

  or

( ( Status | changed to | MODIFIED ) && after -7d )

Basically looking for an extension to the "changed XXX" searches to add a time bound.  Should basically work with the facts stored in the status change table.  It could be applied to a single search, or to a group inside a parenthesis.

Comment 1 Jeff Fearn 🐞 2020-03-02 01:01:19 UTC
I think you can already do this if you use enough parenthesis.

https://bugzilla.redhat.com/query.cgi?bug_status=VERIFIED&bug_status=RELEASE_PENDING&f1=OP&f2=OP&f3=bug_status&f4=bug_status&f5=CP&f6=OP&f7=bug_status&f8=bug_status&f9=CP&j2=AND_G&j6=AND_G&list_id=10879055&o3=changedbefore&o4=changedfrom&o7=changedafter&o8=changedto&product=Red%20Hat%20Enterprise%20Linux%208&query_format=advanced&v3=-7d&v4=NEW&v7=-7d&v8=MODIFIED

Note that the example give is an enormous search space so might time out if you include CLOSED or even NEW bugs.

The first date is < now -7days, which is a all the way back to when b.r.c started.

It might be worth testing with this as a base to see if it does give you the results you want.

Comment 2 Brendan Conoboy 2020-03-02 04:08:34 UTC
It looks like that "against the same field" selector option is doing the trick.  It's slightly more granular than I was hoping for, but I can work with it.  Thanks!


Note You need to log in before you can comment on or make changes to this bug.