ClearQuest Email Notification Package

From cqwiki
Revision as of 21:50, 16 June 2010 by James parker (talk) (Added license section, specifying LGPL; also added "Getting the Software" header to separate downloading paragraph from that section.)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

ClearQuest Email Notification Package

Created by ClearQuest admin for ClearQuest admins.

Email Notification Package

It is NOT a solution that is provided and supported by IBM-Rational. It is better. Click here if you would like to know why it was created. The package was presented on RUC 2006 I would better give you a quick overview some of the advantages.

Centralized configuration and maintenance

Email settings are stored in the ClearQuest user database. You do not need to configure every client. You configured notification on the database, turned them on – and it is working for all users, regardless of the client type: Windows, CCWeb, UNIX. It also easy to turn off notifications when they are not necessary. For example, you copied your production database to a test environment, turned the plug off, and you do not bother your users with annoying emails.

Reliable delivery/Message Queue

If message cannot be delivered due to SMTP relay outage, delivery error or connectivity issue, it is saved in the message queue and will be re-delivered. You can optimize delivery mode based on your own requirements and needs. There are tree delivery modes offered by the package Light, Deferred (default), and Queue.

In case of Light delivery mode each client tries to deliver message to SMTP relay immediately, and store generated messages in the database for further re-delivery if attempt was unsuccessful only.

Deferred delivery means that client stores all triggered messages in database message queue first, and then tries to deliver them, as well as other eligible messages that might be left from previous unsuccessful delivery attempts. All messages are sent in batch mode when rules evaluation is completed.

In case of Queue delivery mode, client stores all messages in database and does not attempt to deliver. In this case, SMTP delivery is performed by separate CQPerl script running from ClearQuest server.

Email Message Log/Audit trail

In Deferred and Queue delivery mode all generated messages are stored in the message queue, which is a ClearQuest table. You are able to validate what was sent and when, check delivery errors, error messages. In addition to that you can update and re-deliver messages if necessary within the ClearQuest.

Message queue is also useful to develop and debug email notification rules. For example, you can turn on email notifications on your test database, and set Queue delivery mode without delivery script running. Email Rules will be evaluated, emails triggered and saved in the database, but not sent to users. You can review generated emails and sent them manually, if necessary.

Customizable message envelope and body

You can create almost any message you want. Most of the field in the notification rule that defines email message are free-text fields, where you can embed parameters, such as record fields, database properties, results of SQL statements execution, Package or Perl build-in, and user-defined function. At runtime, during the rules evaluation, these parameters will be expanded, substituted with actual field values and function's return results. For example, you configured subject in your email notification rule as:

 Defect $ID has been $State

and subject in the generated email message might look like

 Subject: Defect RATL0000001 has been closed 

Configurable email message priority

Users receive tons of emails, and sometimes you need to attract their attention to some of them. Priority field can be used to flag some messages. It can be a static priority specified for email notification rule, or dynamically evaluated priority. For example, you can flag messages that are generated by incident with Severity 1 only. Since your email body is also customizable, you can add there details instructions for the recipient on what needs to be done when they received such email.

Additional header information

It might be required to include some information not just to message body, but also to the message envelope. For example, to inform the mail agent about character set used in the message, or specify particular message type, such as html, etc. It is nice that you have a option to configure it in email notification rule.

Notification conditions

Notification condition filed provide you additional mechanism to customize message behavior. Along with fields, parameters and function, you can use logical comparison, arithmetic and other operators, as well as regular expressions patterns.

Message sender and reply-to address

You can send email using the current user email address in the “From:” field, or you can select a dedicated email address that will be used for all emails generated in the database. It might make it more convenient for users to configure their email filters. In addition, it can help you to satisfy mail relaying policies in very restrictive environments. You can configure different email, Reply-To address, that will be used when users try to reply to generated emails.

Site-specific settings in Multisited environment

If you use ClearQuest multisite, you might change some database settings based on the site where you are located. For example, to point your users to a different SMTP relay. It is not a problem: the package allows you to create goloba as well as site specific settings to modify or unset global database properties on particular site.

Password authentication with SMTP relay

Optionally, you can configure password authentication with SMTP relay. Credentials used for notification can be saved as encrypted values in the database


The ClearQuest Email Notification Package is licensed under the GNU Lesser General Public License (AKA, the "LGPL"), Version 2.1, February, 1999.

Getting the Software

Would you like to try it? Then, proceed to download page. Please do not forget to backup your databases and read configuration guide, before applying changes to your production database.


Some examples can be found on Examples page.