Filtering out JIRA issues that dont have a link to a confluence area

[david_parry]

Hello

I'm trying to build a dashboard/alerts around data-quality and want to show all Epics that don't have a link to a page under a specific confluence page/folder/space (basically to ensure there is no work kicking around that doesn't have a document for it)

When I create the links I can see that they come up as "Wiki Page" type links in the Epic itself, and the URL in said link will have the format: 

https://wiki.gbl.confluenceInstance.com/display/CM/RFC*

JQL I have tried: 

issueFunction not in linkedIssuesOfRemote("path", "https://wiki.gbl.confluenceInstance.com/display/CM/RFC*")

which returns no results (I have examples that should show)

If I query for tickets with "Wiki Page" type links:

issueFunction in linkedIssuesOfRemote("Wiki Page")

I get some of the expected tickets, but not all, and when I do this:

issueFunction not in linkedIssuesOfRemote("Wiki Page")

I get the remaining issues I expect to see in the previous query, which DO have a "Wiki Page" but not as the first link listed when I open the issue. I would be looking to use the latter to detect tickets without the right links set.

Of course the latter approach is rather blunt in that it I'm not looking for specific links...its indicative of a situation rather than accurate.

As a non-generic check:

issueFunction in linkedIssuesOfRemote("query", "pageId=239308824")

also does not work, when I can manually find tickets that reference that specific page. Might this be the reason? Do the links need re-indexing?

Thanks in advance

Dave