Number of mentioned confluence pages in Jira ticket

[Yu Zhang]

I would like to set up an automatic count of mentioned confluence page in Jira. Example is below.  I have a number field that dedicated to store the number of mention.

I have the confluence pages mentioned the ticket listed with the ticket (Jira/Confluence native feature)

I want to be able to count Confluence content and apply a filter function. (Start with a text)

Any help is appreciated. 

[Bill Sheboy]

Hi @Yu Zhang -- Welcome to the Atlassian Community!

Short answer: I do not believe that is possible with built-in features.

I hypothesize Atlassian gets those "mentioned on" pages using application code or an internally facing REST API endpoint...

Confluence has a CQL (Confluence Query Language) to search for fields and page content.  And, the documentation shows a search using the CONTAINS ~ operator will search the content.  For, example to search for work item key MYISSUEKEY-123:

text ~ "MYISSUEKEY-123" 

However, my testing shows CQL can search the page title to find that text, or search the content as plain text, but it cannot consistently find links or other references to the work item, such as in query or link macros.

Kind regards,
Bill

[Yu Zhang]

Hi @Bill Sheboy  thank you so much for your kind reply. I was hoping it could be something resolvable with a built-in feature... I can still manually count.