386934 - add pronouns for default assignee and default qa contact

Status: NEW

(Bugzilla :: Query/Bug List, enhancement)

Description

[timeless]

philor (and I, I suppose) want to be able to run a query like this:

qacontact notequal %defaultqacontact%

(and presumably someone somewhere will want to do)
assignee notequal %defaultassignee%

Comment 1

[timeless]

Attachment: maybe this works

Comment 2

[Frédéric Buclin]

I like this idea. joel, justdave, could you please have a look at this patch?

Comment 3

[Joel Peshkin]

Comment on attachment 271009 [details] [diff] [review]
maybe this works

This might work if the subroutine call had a reference to the list and someone tested it.

Comment 4

[timeless]

Attachment: references

Comment 5

[Joel Peshkin]

Comment on attachment 275653 [details] [diff] [review]
references

Earlier in Search.pm, there is an optional join with components as ...

       push @supptables, "INNER JOIN components AS map_components " .
                          "ON bugs.component_id = map_components.id";


When we join components again, we should use the same name "map_components" and use an INNER JOIN (since all bugs have to have a component).  This way, the table won't actually get joined twice.

Also, please do confirm that you've tested this.

Comment 6

[Firefox Bug Husbandry Bot]

Removing good-first-bug keyword because team does not have bandwidth to mentor at the moment.

Comment 7

[Firefox Bug Husbandry Bot]

Removing outreachy because team does not have bandwidth to mentor this cycle.