2 messages in com.mysql.lists.eventum-usersRe: Custom fields & notification list...| From | Sent On | Attachments |
|---|---|---|
| Martin Guindon | 24 Jan 2008 08:23 | |
| Bryan Alsdorf | 30 Jan 2008 10:52 |
| Subject: | Re: Custom fields & notification list questions |
|---|---|
| From: | Bryan Alsdorf (bry...@mysql.com) |
| Date: | 01/30/2008 10:52:39 AM |
| List: | com.mysql.lists.eventum-users |
Hi Martin,
Martin Guindon wrote:
Hi!
We've been using Eventum in the past few weeks and we love it. I've got two questions:
a) It is possible to have the Custom Fields appear in the Update Issue form, either through an option in the admin console or by modifying the Update Issue template? (I'm no SQL expert however...). We rely heavily on the Custom Fields to track specific data and it seems counterproductive to have to go to two different forms to update a single issue.
This is on my TODO list but I don't have a timeframe for it. It makes 100%
sense, but I
just haven't had the time to do it.
b) If a user disables the email notifications through the account preferences, it only disable it for new issues, it doesn't seem to modify the notification list of the current issues, so the user is still receiving a bunch of emails. Is there any way to do a bulk update to add/remove a user to the notification list of selected issues? (I guess there'd be a way in SQL, but again I'm no SQL expert..)
Yes, it is possible to do this.
DELETE FROM eventum_subscription WHERE sub_iss_id IN ($ISSUE_IDS) AND sub_usr_id IN($USER_IDS);
You can get the user IDS from the eventum_user table, and both $ISSUE_IDS and
$USER_IDS
should be a comma separated list of numbers.
Best Regards, -- Bryan Alsdorf, Manager of Support Systems MySQL AB, www.mysql.com
Discover new MySQL Monitoring & Advisory features at: http://www.mysql.com/products/enterprise/whats_new.html