Embed list of issues with no linked confluence page

[Peter Lloyd]

Hi,

I've found the documentation to do the opposite of what I want How to find issues that have Confluence pages linked to them using JQL? 

Using the Jira Issues macro I would like is to create a dynamic view in confluence of issues for project = xx which are in progress but do NOT have a linked confluence document.

How do I do the last bit? issuesWithRemoteLinksByGlobalId requires a pageID in the GlobalID parameter so...

issue not in (issuesWithRemoteLinksByGlobalId("appId=xxx"))

does not work.

open to suggestions,
thank you 

[Ignacio Aredez GenAI Expert]

Creating a dynamic view in Confluence for Jira issues in progress without linked Confluence pages requires a workaround since JQL does not directly support querying the absence of links. Here's a simplified approach:

Identify Issues with Links: First, identify which issues have Confluence pages linked. This might involve using JQL to find issues with any links, though directly filtering out those without Confluence links isn't straightforward with JQL alone.

Manual Comparison or Scripting: Since JQL can't directly find issues without Confluence links, you would need to manually compare the list of all in-progress issues in your project against those known to have links. Alternatively, consider using the Jira and Confluence APIs to automate this process by scripting a comparison between issues in progress and those with linked Confluence pages.

Display in Confluence: For displaying the filtered list in Confluence, you might manually update a Confluence page with this information or develop a custom solution that automatically updates a list on a Confluence page based on the results from your comparison.

In essence, while JQL alone can't achieve your goal, combining it with manual processes or custom scripting involving the Jira and Confluence APIs could provide a solution.

[Peter Lloyd]

yes remoteLinkApplicationName = "Confluence" gives me the ones that do.
I'll write a service which does the logic and updates a custom field and filter on that
ty for the reply, it pointed me in the right direction :)