JQL query issues mentioned on Confluence

Question

I need to be able to filter all issues which have "mentioned on..." confluence link. Ive already looked at this answer: https://community.atlassian.com/t5/Jira-questions/Jira-query-on-mention-in-Confluence-page/qaq-p/700628 But that does not work. The query on that answer requires PAGE_ID for it to work. issue in (issuesWithRemoteLinksByGlobalId('appId=&pageId=')) I need to see all issues with links to confluence, not to some specific page. Is there a way to use the query without PAGE_ID? Ive not gotten it to work. Simply removing the PAGE_ID does not work. Please do not recommend me addons.

LAL_i6rck1 · Answer

No that doesnt work "AND text ~ "mentioned on"" does not search links and just applies to description text

Frederik Vantroys · Answer

Maybe a simple text search could do the trick ?

Something like :

project = "Your Project" AND text ~ "mentioned on" AND status != Closed