In a query search I would like to add a column to show the last comments made on a story and be able

[Robert.j.kilpatrick]

In a query search I would like to add a column to show the last comments made on a story and be able to add it to the column pull down area so I could add the results in the visual display of the query.

I have tried ...issueFunction in commented("after -7d")... but it just filters items that have comments. 

[Dave Mathijs]

Hi @Robert.j.kilpatrick

Welcome to the Atlassian Community!

Can you confirm whether you are on Cloud or Server/Data Center? What is the URL of your Jira site?

You would need to script this via a Scripted Field in ScriptRunner for Jira. The contents of the last comment will be copied to a custom field called f.e. 'Last Comment'.

[Robert.j.kilpatrick]

proprietary company server. 

[‎9/‎26/‎2022 12:47 PM] 

The scripts we used just sorted out the stories that met the criteria that is why our number of story point reduced because it found say 48 out of the 117 that had comments.

I tried the Lastcomment () and it did not add a column nor a last comment to select in the column pull down.

[Hannes Obweger - JXL for Jira]

Hi @Robert.j.kilpatrick

if you're open to solutions from the Atlassian Marketplace, a "last comment" column is available in the app that my team is working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting and filtering by all your issue fields, plus a number of "smart fields" that aren't natively available. The "last comment" is one of these fields (along with e.g. the number of comments, the date of the last comment, and many others).

This is how it looks in action:

It's worth noting that JXL can do much more than that: From inline issue creation, to support for issue hierarchies, issue grouping, sum-ups, and conditional formatting.

Just in case you're using Jira Server: You will notice that JXL isn't listed for Server on the Marketplace. This is because new apps can't be listed for Server anymore. However, JXL is perfectly compatible with Server; it's just that we need to generate a license for you. If JXL looks like something that might be useful for you, just let me know and I'm more than happy to help.

Best,

Hannes