How can I add the field "comment" to a JQL result?

[Hans Ottens]

When I want to add the field 'comment' as an extra field to the JQL result I can't find the field via Configure Fields.

So my question is how can I add the field 'comment' to the result of a JQL?

[Ashish Bijlwan]

Hi @Hans Ottens 

Out of the box, we can not see Comments in the Issue Navigator.

Work around is to create a custom field Last Comment and create a automation to copy the comment from Comments to Last Comment field. This field can be use in Issue Navigator to see the comment but it will only show the Last Comment.

Regards,
Ashish

[Hannes Obweger - JXL for Jira]

Hi @Hans Ottens

just to add to @Ashish Bijlwan's great answer:

If you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are 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, much like you'd do in e.g. Excel or Google Sheets. It also comes with a long list of so-called smart columns that aren’t natively available, including the first/last comment, the author of the [first/last] comment, and many, many more.

This is how it looks in action:

As you can see above, you can easily sort and filter by your comment columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

This all just works - there's no scripting or automation whatsoever required.

Any questions just let me know,

Best,

Hannes

[Vikrant Yadav]

Hi @Hans Ottens ,

Are you looking to add a system Comment field ? 

You can add "Comments" column in JQL search, but it won't show the comments. 

You can use the workaround suggested in this post to show comment in Issue Search : https://community.atlassian.com/t5/App-Central-articles/How-to-display-Last-comment-in-Filter-JQL-and-any-Add-on/ba-p/1489153