661644 - Newer custom "flag" fields are not available as buglist columns

Status: RESOLVED FIXED

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

Description

[Daniel Veditz [:dveditz]]

Buglists can have the firefox5 fields as columns, but are missing

tracking-firefox7
status-firefox6
status-firefox7

I would imagine adding them manually is not sustainable in the long run, but for now I need these for triage.

Comment 1

[:glob ✱]

looks like this requires a direct database update as there's no UI for changing if a customfield is a selectable column.

justdave: can you please run the following statement on stage-tip, stage, and production:

  UPDATE fielddefs SET buglist=1 WHERE type=2

this makes all FIELD_TYPE_SINGLE_SELECT fields selectabe as columns for bug lists.  the problem is caused by addcustomfield.pl setting buglist to 0 (field added with the webpages always have this set to 1).

i'll update addcustomfield.pl so this is set by default.

Comment 2

[:glob ✱]

addcustomfield.pl updated:
Committing to: bzr+ssh://[e-mail]/bmo/4.0/
modified contrib/addcustomfield.pl
Committed revision 7750.

Comment 3

[Dave Miller [:justdave]]

[production]
mysql> UPDATE fielddefs SET buglist=1 WHERE type=2;
Query OK, 3 rows affected (0.00 sec)
Rows matched: 34  Changed: 3  Warnings: 0
[stage]
Query OK, 0 rows affected (0.00 sec)
Rows matched: 31  Changed: 0  Warnings: 0
[stage-tip]
Query OK, 1 row affected (0.00 sec)
Rows matched: 30  Changed: 1  Warnings: 0

Comment 4

[David Lawrence [:dkl]]

I wonder why this is not a checkbox on the custom field admin UI to turn these on/off? With javascript it could be setup to disable the checkbox unless certain field types are selected.

dkl