Is it possible to extract and parse JIRA comments onto a Confluence page?

Question

I want to be able to look through (the computer, not me) JIRA comments for specific cases and parse comments with specific keywords to a Confluence page to track if that specific comment involved "issue/reason x". I would like to aggregate all those comments and see how often/much "issue/reason x" was mentioned and some other information related to it.

Louie Chen_l7cigy · Answer

Thanks for that, this query works as far as returning the actual JIRA issues, is there a way to return the comment in which the matching term/string occurs?

cmac · Answer

I'd recommend going to JIRA and use JQL to setup the query using something like"

project = 'YOUR-PROJECT' and comment ~ 'issue/reason X'

this should confirm whether you have the correct search / filter.

You can then paste this query into either a JIRA Report or JIRA macro to dynamically render the list of JIRAs on your Confluence page.

Below is an excerpt from: Using JIRA and Confluence Together

Alternatively, you can add the JIRA Issues Macro to the page and search for issues directly:

In the editor choose Insert > Jira Issue.
Follow the prompts in the macro browser to choose a project and search for an issue – you can even use JIRA Query Language (JQL)

Louie Chen_l7cigy · Answer

Hi Chris,

Thanks for your response. This link seems to be concerning the tracking of status changes or labels. I'm trying to search through comments for specific phrases and return them into a new page or report.