extracting last comments from Jira tickets

[Ritika Ojha]

I have project board and i am trying to figure out a way to extract latest comments ,& updated date for each tickets I out on the board. This board has tickets from various projects.

is there a way to do it?

[Ivan Manolov - JXL]

Hello @Ritika Ojha 

To the best of my knowledge, there is no native way to show this data on a board.

If you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your Jira data that allows viewing, inline-editing, copy-pasting, sorting, and filtering by all your work items' fields, much like you’d do in e.g. Excel, Google Sheets, Smartsheet, or Airtable. It also comes with a number of so-called smart columns that aren’t natively available in Jira, including the Last comment, Date of last comment, and many other comment-related columns.

This is how it looks in action:

 

As you can see above, you can easily sort and filter by the last comment, and also use it across other JXL features, configurable issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. Same thing is available for the Updated date as well.

Any questions just let me know,

Best,
Ivan

[Rajat Pratap Singh]

Hi @Ritika Ojha 

If your Jira instance has Jira Scriptrunner plugin, then you can use this script:
https://www.scriptrunnerhq.com/help/example-scripts/show-last-comment-issue-cloud-cloud 

Hope this helps!

Regards
Rajat

[Ritika Ojha]

we dont. is there a workaround ?

[Ekaterina Smykova]

Hello @Ritika Ojha ,

You can try to make it work Automation for Jira:

1. Create a new automation rule: Navigate to Jira Admin > Automation > Create Rule.
2. Set the trigger: Choose "Issue commented" as the trigger.
3. Add an action: Select "Edit issue" as the action.
4. Edit the "Last Comment" field: Find the "Last Comment" field and check the box to include it.
5. Use smart values: In the "Last Comment" field, enter the smart value {{issue.comments.last.body}}. This smart value retrieves the body of the last comment.
6. Name and turn on the rule: Give the rule a name (e.g., "Set Last Comment") and turn it on.

Hope it helps!

Regards,

Katja