Last Comment Column for Jira: the newest comment as a column

Last Comment Column adds a read-only field, "Last Comment", that shows the start of the newest public comment on an issue, its date and its author. Use it as a column in the issue navigator. Restricted comments are never shown. It runs inside the cloud product and sends nothing outside it.

日本語のページ

For Jira Cloud. Runs entirely inside it. Updating the field needs an active license; see Marketplace for pricing.

What it does

The field shows the first 120 characters of the newest comment that anyone with access to the issue can read, then its date and its author. It is rebuilt every time a comment is added, edited or deleted, so it follows the issue. The text is also searchable, so the field can be used in filters.

Restricted comments are never shown. Comments limited to a role or group, and internal Service Management comments, are never copied. The field shows the newest public comment instead. If a comment that was shown is later deleted or restricted, the field switches to the next newest public comment, or becomes empty if there is none.
Mentions appear as @user. The person's name is not copied from the comment text.
Dates are in UTC. The date is written as YYYY-MM-DD and followed by "UTC".
The author is shown by display name, looked up when the column is displayed. The app keeps only the author's account ID.

Where to find it

The field is named Last Comment and appears under Settings, Issues, Custom fields. The app also has an administration page in Jira, named Last Comment Column. Only Jira administrators can open it; other people see a notice saying so.

Use it, step by step

Open the issue navigator, choose Columns and tick Last Comment.
New activity is picked up by itself: add, edit or delete a comment and the field updates.
Issues that already have comments have no value until a comment changes. To fill them once, open Last Comment Column in administration, choose a project and press Fill project. The run reads the issues 50 at a time and you can leave the page. Stop ends it; Refresh shows the progress.

Limits

The text is cut to 120 characters. Formatting is flattened to one line; links show as their address and emoji as text.
To find the newest public comment, the app reads at most the newest 500 comments of an issue. If none of them is public, the field stays empty.
The fill runs for one project at a time. If it shows no progress for 3 minutes, you can start it again.
The field is read-only. It cannot be edited by hand.
The app changes no comment and no other issue field. It creates and deletes no issue.

Licensing

Updating the field and starting a fill need an active license. The administration page and its progress display open without one. See Marketplace for pricing.

Data and privacy

The field value on the issue holds the first 120 characters of the newest public comment, its date, the comment ID and the author's account ID. In app storage on your site the app keeps, for each issue it has filled, the creation time, ID and author's account ID of the comment it used, and an index entry from the account ID to the issue key; for each account ID, the time it was last written; and the progress of each fill. Restricted comments are never stored. The account ID is the only personal data it keeps; names and email addresses are not stored. Each week the app reports the stored account IDs to the platform personal-data service, also when it is unlicensed. For an account that has been closed, the app removes the account ID from the field values and deletes its records. It runs inside the cloud product and sends no data outside it. Uninstalling removes the app storage. See the Privacy page for Hullspark's policy.

Support

Write to support@hullspark.com or use the Support page. Include the issue key and what you saw. Do not send comment text.