Bug 1808906 - RFE: Add a timebox to status comparisons in advanced search
Summary: RFE: Add a timebox to status comparisons in advanced search
Alias: None
Product: Bugzilla
Classification: Community
Component: Query/Bug List
Version: 5.0
Hardware: Unspecified
OS: Unspecified
Target Milestone: ---
Assignee: PnT DevOps Devs
QA Contact: tools-bugs
Depends On:
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:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Last Closed: 2020-03-02 04:08:34 UTC

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 )


( ( 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.


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.