Creating daily status updates email from JIRA

Context

My client has always preferred reading an email at the start of his day that summarizes all the work his dev team was up to the night before. We call it the status mail. It usually contains the list of tasks we have worked on, containing its full description along with our comments/status on that day. Such reports are favorites among clients who are non-technical or who cannot afford to spend time in JIRA, as they get all updates in one go. But, of course, this is beneficial only for a team size of 5-20 members. Any more than that, the mail itself becomes too long to read.

Background

We adopted JIRA only recently, slightly more than a year ago. During the pre-JIRA dark ages, my predecessors had to perform a laborious task of compiling status mails from tasks, bugs and feature requests sent by the clients over emails. It used to easily take up 30-60 mins on a rainy day, copy pasting updates provided by the team, then mix-matching the formats to make it look good, etc. Moreover, it was too much manual labor to love this part of the job.

Then came JIRA, and life became much more efficient.

Creating Status Mail from JIRA

So, let us get down to the core part of this post. The steps to create a status mail are pretty straightforward. But before we proceed further, go through the checklist below that you may need (to know).

The Secret Ingredients List

1. JQL (JIRA Query Language) to build your query
2. JIRA API to fetch the query results programmatically
3. An application⁺ to fetch your results using JIRA API
4. JavaScript and JQuery⁺ to process the result (final JSON)
5. JQuery templates⁺ to build your email content (HTML) from your processed final JSON.

[⁺]: Choose language or tool of your choice.

JQL

First and foremost, you need to fetch only relevant issues that have been updated that day to be processed and put into the status mail. JQL (JIRA Query Language) is the best way to get that done. A typical example of the query I use is as follows.

project in ("My Project") AND comment ~ "\\[statuscomment\\]"
    AND updated > startOfDay() AND updated < endOfDay()
ORDER BY key DESC

NOTE

• In our implementation, a comment that needs to go into the status mail must be prefixed with[statuscomment], so that only the relevant comments are grabbed when processing results (later below).
• Of course, you can use any other keyword instead – just change it in the processing function. If you don’t want any “keyword processing” at all, such that all comments from today should show up, that’s fine by me. Just, again, make sure to change the processing function accordingly.
• You may save the JQL query as a JIRA Filter, so that you can reuse or reference it later.
• The JQL above is not perfect, because it may fetch issues that have not been actually updated with a statuscomment on that day. A typical example is, if you added a status comment for an issue yesterday (and not today), but you did update it today (like marked it to done or edited some fields), the task still qualifies for the JQL above. This is because JQL does not support querying individual comments’ updated dates. However, this should not be an issue for us, as we will be filtering out such comments, as you will see later.

JIRA API

To fetch issues from JIRA in to your application, you need to use /search API. You can use either GETor POST method to do so. The JIRA documentation explains all necessary steps clearly, so I’m not covering that. However, here are the key parameters that you should add to fetch all necessary details in one go.

{
    "expand": "names,schema,renderedFields",
    "jql": "our JQL query mentioned above",
    "fields": "summary,description,comment"
}

Sample JQL result-set provided at the bottom. (See gist 03-jira-api-result-sample.json)

There are a few key things to note in this result set:

• It brought only the fields mentioned in fields parameter above.
• The startAt and maxResults properties are used for pagination. By default, JIRA API brings only 50 items per query. So, if you have more than 50 issues to process daily, you should tweak your API call accordingly.
• There is a renderedFields property which contains the actual rendered HTML of the description fields, and not the JIRA wiki syntax as in descriptions in the original fields. The JIRA wiki syntax is useless for us.

Process Result

processStatus(data) function in below 01-jira-task-status-processor.js gist is our public API to building the status HTML. What it essentially does is:

1. Process result set per issue-item per comment
2. Check that the comment must begin with [statuscomment] – else do not process
3. Check that date of comment must be after checkDate passed (checkDate defaults to today) – else do not process
4. Strip out [statuscomment] tag from comment, as not required anymore
5. Prepare an object containing issue title, description, filtered comments content, user details of comments, etc.
6. (Freebie) Encode comments so that we can put it into email replies automatically when Repy >button is clicked. (See further sections below to understand what I’m talking about)
7. Pass object to JQuery Templates (see 02-jira-status-template.html gist) that builds the final status mail HTML.

NOTE

•  jiraAPIResponseProcessor() is just a wrapper function.
• You may need to modify these gists for your use.
• I will try to create an API/library for you in the near future, so that you do not have to deal with these boiler plate codes.

Final Output

Combined together with the JIRA API result-set, you may generate an HTML which finally looks like the following image. Of course, this is a very crude representation below without any styling whatsoever. So, please do stylize the output as you like, before sending it to your boss. 😉

Here is the gist

(No Ratings Yet)
Loading...