306063 - Group CC Needed

Status: RESOLVED DUPLICATE of bug 359251

(Bugzilla :: Email Notifications, enhancement)

Description

[Kevin Benton]

We need the following table:

group_cc (
  bug_id mediumint not null,
  group_id mediumint not null
) primary key (bug_id, group_id);

This would allow us to add an entire group to the CC list (without adding
individual emails) so that as the group changes, the list of recipients changes
automatically as well.

Simultaneously, when this is created, we also ought to add an initialgroupcclist
field to bugs so that group CC's can be assigned as bugs are opened.

Comment 1

[Albert Ting]

I think this would be useful not just for CC but for any userid fields
(assigned_to, qa_contact, etc.). 

Comment 2

[Max Kanat-Alexander]

Agreed, it would be nice to be able to specify a group in any field that could
contain a user.

Comment 3

[Kevin Benton]

I think I figured out a way that this could be implemented without adding yet another table - rather than creating a group cc table, it seems that adding a boolean where appropriate would allow us to specify whether or not a user pointer is pointing to a userid or a groupid (i.e. assigned_to_is_a_group, qa_contact_is_a_group, or on the CC, id_pointer_is_a_group ...)

I believe this would give us the greatest flexibilty in handling user / group assignments and make it as seamless as possible.

Comment 4

[Olav Vitters]

*** Bug 322696 has been marked as a duplicate of this bug. ***

Comment 5

[Max Kanat-Alexander]

Bug 359251 has a wider scope, so either it will fix this bug or will be a tracking bug for this one.

Comment 6

[Kevin Benton]

Bug 359251 is a much more elegant solution to this problem and should be tracked there from this point forward.  Marking this bug as a duplicate of that one.