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

[Louie Chen]

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.

[cmac]

Hi Louie,

Welcome to the Atlassian community. 

You might like to check out Confluence - JIRA Report Blueprint, this allows you to create dynamic reports on your JIRA project and can be customized using advanced JQL queries. 

[Louie Chen]

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.

[cmac]

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]

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?