1283312 - (stale-needinfo-search) Advanced Search page doesn’t list Flags and many other fields in Search By Change History

Status: RESOLVED FIXED

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

Description

[Emma Humphries ☕️🎸🧞‍♀️✨ (she/they) [:emceeaich] (Pacific Time) use needinfo]

The search https://bugzilla.mozilla.org/buglist.cgi?f1=flagtypes.name&o1=substring&resolution=---&o2=lessthan&query_format=advanced&f2=delta_ts&v1=needinfo&component=DOM&v2=14d&product=Core returns bugs in Core::DOM with unresolved needinfos and that have not been modified in two weeks. This is a rough form of the report we need, because what we're interested in seeing is if the needinfo has gone untouched. 

The report should allow the user to select product and component and optionaly a date to filter on (bugs filed on or after date) 

The report should show how long the needinfo has been open.

The report should link to a bug list. 

As a bonus the report should allow the user to select a group of bugs and close them as incomplete (in the case of needinfos from reporters who have abandoned the bug, for example.)

Comment 1

[Mike Hommey [:glandium]]

Note that one can "Edit search". Sadly, "Search By Change History" doesn't have needinfo.

Comment 2

[Emma Humphries ☕️🎸🧞‍♀️✨ (she/they) [:emceeaich] (Pacific Time) use needinfo]

Instead of a report, this would be better handled if we could search for bugs which have had a flag value for at least some period of time.

Comment 4

[:Atoll]

This would have been useful to me today for finding needinfo's that have not resulted in the necessary information after several months.

Comment 5

[Emma Humphries ☕️🎸🧞‍♀️✨ (she/they) [:emceeaich] (Pacific Time) use needinfo]

This is also needed by Autonag so should be reviewed for :kohei's backlog.

Comment 6

[Kohei Yoshino [:kohei]]

Looks like you can do it using queries like this:

https://bugzilla.mozilla.org/buglist.cgi?product=Firefox&chfield=flagtypes.name&chfieldfrom=-2m&chfieldto=-1m

Somehow Search By Change History on the Advanced Search page doesn’t list Flags (flagtypes.name) as an option and you have to do it manually. I’ll figure out why all the fields are not listed here. There are 1197 fields available in Custom Search, while this dropdown only has 1127.

Comment 7

[Kohei Yoshino [:kohei]]

Er, 563 vs 598. These 35 fields are missing in Search By Change History:

Assignee Last Login Date, Attachment creator, Attachment description, Attachment filename, Attachment is obsolete, Attachment is patch, Attachment is private, Attachment mime type, Blocks, Bug ID, Bug Interest, CC, Classification, Comment, Comment is private, Comment Tag, Commenter, Content, Creation date, Days since bug changed, Depends on, Flag Requestee, Flag Setter, Flags, Group, Keywords, Changed, Last Visit, Mentor, Number of Comments, Reporter, See Also, Tags, Time Since Assignee Touched, Triage Owner

Comment 8

[Emma Humphries ☕️🎸🧞‍♀️✨ (she/they) [:emceeaich] (Pacific Time) use needinfo]

Is that list of fields in the dropdown not generated?

Comment 9

[Kohei Yoshino [:kohei]]

We need to fix editable_bug_fields in Bug.pm. The field list here is generated from the bugs table columns, which means any fields stored in intermediate tables are not included. Obviously, this will affect the Regressions and Regressed by fields I’m working on.

Comment 10

[Kohei Yoshino [:kohei]]

Attachment: GitHub Pull Request

Comment 11

[Kohei Yoshino [:kohei]]

Merged to master.