1509332 - Stop hardcoding users, products, components, keywords, version in bug history; use IDs instead

Status: NEW

(bugzilla.mozilla.org :: General, task, P2)

Description

[Marco Castelluccio [:marco]]

This makes it hard to link the history results with the current results, where we only have the current email of the user.

Comment 1

[Kohei Yoshino [:kohei]]

Hmm, this is a bit difficult issue. In the history (bugs_activity) table, all the added/removed values are hardcoded as a comma-separated string. The solution may be storing unchangeable user IDs instead of email addresses, but we have to dig older emails in the audit log.

Comment 2

[Kohei Yoshino [:kohei]]

Emma also noticed this, which is actually not specific to the API.

Comment 3

[Kohei Yoshino [:kohei]]

(In reply to Kohei Yoshino [:kohei] (Bugzilla UX) (FxSiteCompat) from comment #1)

Hmm, this is a bit difficult issue. In the history (bugs_activity) table,
all the added/removed values are hardcoded as a comma-separated string. The
solution may be storing unchangeable user IDs instead of email addresses,
but we have to dig older emails in the audit log.

Let’s do this.

Comment 4

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

This is also an issue that can affect people whose email changes are associated with gender, relationship and other personal history matters.

Also, a reason to move off of email as a unique identifier.