Volker,
One problem with the eMailAdvanced.js script. It sends one email per item. So if your query returns 50 items the email recipients will receive 50 separate emails.
A while ago I created a script (with the help of this community) that summarizes the items into one email. If someone can improve it please share it with us.
Sample script below:
// <b>Integrity Manager Scheduled Trigger for [Your Title]</b>
// <p>
// This script is used to send mail notification from a scheduled trigger.
// Each issue that the trigger's query matches is summarized in one line,
// and is emailed to the appropriate recipient.
// If the query matches nothing, no email is sent.
// <p>use a <b>comma</b> to separate email addresses.
//
// @param String Email Address
// The email address is required, or we don't know who to send email to.
//
// param String Subject
// The subject is optional, the default subject is ``Scheduled Notification''.
//
// @param MultiString Start of message
// The message start is optional.
//
var eb = bsf.lookupBean("siEnvironmentBean");
if (eb.getEventContext() != "Schedule")
eb.abortScript("The imens_multiple_email.js script may only be run from a scheduled trigger", true);
// Lookup the parameters bean, and from it find our three parameters,
// the recipient, the subject, and the message start.
var params = bsf.lookupBean("parametersBean");
if (params == null)
eb.abortScript("Missing parameters bean", true);
var emailAddresses = params.getParameter("Email Address");
emails = emailAddresses.split(",");
if (emails[0] == null)
eb.abortScript("This script requires an email address to email to!", true);
// Find the arguments bean, this allows us to find all the issues that
// were matched by the query which triggered us.
var args = bsf.lookupBean("imScheduleTriggerArgumentsBean");
if (args == null)
eb.abortScript("Missing schedule trigger arguments bean", true);
var msg = params.getParameter("Start of message");
if (msg == null || msg.length() == 0)
msg = args.getTriggerName()
+ "\n"
+ "YOUR MESSAGE HERE:"
+ "\n";
// var subject = params.getParameter("Subject");
// if (subject == null || subject.length() == 0)
subject = "YOUR SUBJECT HERE";
var issues = args.getIssues();
if (issues.length != 0) {
// Find the server bean, this allows us to lookup an arbitrary issue
var server = bsf.lookupBean("imServerBean");
// Iterate over all the issues, summarizing them and appending them to
// the email message.
for (var i = 0; i < issues.length; i++) {
var issue = server.getIssueBean(issues[i]);
msg +="\n"
+"---------------------------------------------"
+ "\n"
+ "Display Name: "
+ Field Name[i]
+ " "
+ "\n"
+ "Field Name: "
+ issue.getFieldValue("Field Name")
+ "\n"
+ "State: "
+ issue.getFieldValue("State")
+ "\n"
+ "URL: "
+ "http://%host%:%port%/im/viewissue?selection="
+ issue.getIssueID()
+ "\n";
}
// Actually send the email.
for (var i = 0; i < emails.length; i++) {
eb.sendMail("Your_From_email_address", emails[i], subject, msg);
}
}
