Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




global handling of Email alerts

web-app

Hello,

we are using Gemini v3.6.5 Build 2638.
We have created a base Database with projects and issues, but haven't been using email alerts until now.
Since we want to start using this feature now, we would like to switch it on, but this would result in every user receiving all the created / updated mail-alerts for every project he is in (according to the email-alert setting per user per project).

My question now is - is there a way of globally resetting the user/project/email-alert-settings?
My goal would be, to shut off all the email-alerts for all users for all projects and then manually activating (and testing) the email alerts for only specific users in specific projects.

Since I couldn't find above mentioned functionality yet I assume that this isn't available in the UI.
But maybe you could show me where I would be able to reset the data in the database (table, columns) using SQL?

thnx

Tammo
tammo
· 1 		tammo
Tuesday, July 20, 2010, 10:47:17 AM
Replies (5)
helpful
0
not helpful

What is your email alert engine set to (Administration -> Notifications)?
If it is the scheduler service, please delete all records from the gemini_issuealerts table.

What you can do is switch all alerts off in the Administration -> Notifications page. Then enable each alert (eg created, updated etc...) to see the impact.
Mark Wing
· 9108 		Mark Wing
Tuesday, July 20, 2010, 10:58:00 AM
helpful
0
not helpful

yes, it is set to Scheduler Service at the moment.
But the reason for this was, to initially shut off email alerts, while setting up the projects (since we haven't installed scheduler service).
I will clear the gemini_issuealerts table, but this probably only solves the re-sending off email alerts that have allready been created (since the table has a link to an issue using issueid-column).
What I would like to do is, to set the email alerts for every user in every project to off and then manually re-enable it for one user in one project (and maybe more later), but I cannot find the entry in the database.

The database entry would be the equivalent for the mask
"Configure Project Email Alerts" in the UI, which is project specific I believe.
tammo
· 1 		tammo
Tuesday, July 20, 2010, 1:53:44 PM
helpful
0
not helpful

That is the gemini_watchproject table
Mark Wing
· 9108 		Mark Wing
Tuesday, July 20, 2010, 3:37:32 PM
helpful
0
not helpful

thank you,
I was able to figure out the content of this table.

now, just to summarise the possible email-alerts, so that I don't miss anything.

Email-Alerts are sent whenever
1. An issue is altered or created and an entry exists in the gemini_watchproject table for the corresponding project, user with the corresponding binary watchcode.
This can be configured using the CONFIGURE PROJECT EMAIL ALERTS per user and project and globally by enabling/disabling EMAIL ALERTS in general and CONFIGURE EMAIL ALERTS in detail.

2. An issue is altered where I am assigned as resource and EMAIL ALERTS is enabled and EMAIL ISSUE RESOURCE is enabled.

3. An issue is altered where I am assigned as watcher and EMAIL ALERTS is enabled and ENABLE ISSUE WATCHER ALERTS is enabled

4. I create an Issue and EMAIL ALERTS is enabled and EMAIL ISSUE CREATOR is enabled.

is this information correct?
are there any other reasons, why a person could receive an email alert, which I missed here?
tammo
· 1 		tammo
Thursday, July 22, 2010, 10:47:13 AM
helpful
0
not helpful

You are more or less correct.

1. Yes.
2. No, you will get an issue assigned alert whenever any issue is assigned to ANY user.
3. Yes.
4. Yes, you are added as a watcher therefore will get all alerts for this issue.
5. same as 1 but for update, comment etc...
Mark Wing
· 9108 		Mark Wing
Thursday, July 22, 2010, 10:58:30 AM