Want to write a query that looks to see if the Last Comment is public or private

[Maureen.monahan]

We have a dashboard that uses a filter that looks to see if an update has been made in the last 24 hours.  We need to take it one step further if the update in the comment field is internal vs to the customer.  If it is internal wish to consider it not updated therefore it sill stills show on the dashboard as not being updated in the last 24 hours.

[Brant Schroeder]

@Maureen.monahan Welcome to the Atlassian community 

Currently, this is not possible.  There is a enhancement request here that you can vote for https://jira.atlassian.com/browse/JSDCLOUD-4286 

[Hannes Obweger - JXL for Jira]

Hi @Maureen.monahan

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, this would be easy to do with the app that my team is working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view 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 number of so-called “smart columns” that aren’t natively available, including the last comment visibility (among many, many other comment-related columns).

This is how this looks in action:

You can easy combine the visibility filter with any other column filters. Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.  

It's worth noting that JXL can do much more than that; from support to configurable issue hierarchies, to issue grouping and sum-ups, to conditional formatting. Once thing to point out is that JXL doesn't currently have a dashboard gadget (although we'll provide one, soon) - but many of our users simply use a JXL sheet as a "de-facto dashboard".

Any questions just let me know, 

Best,

Hannes