How to show all Confluence pages WITHOUT linked JIRA ticket?

[paul enggruber]

Hello everybody,

I Need to obtain a list of all my confluence pages in one Project, that are not linked to a JIRA ticket.

Any help is very appreciated.

Best

paul

[Stephen Deutsch · Accepted solution]

Hi Paul,

When you say Project, do you mean Space? All pages in Confluence are bundled in spaces the same way that tickets in Jira are bundled in projects.

I think the easiest way to do this would be to run an empty search, then paste some text in making sure that the end of the URL looks like this:

/dosearchsite.action?cql=type=page%20AND%20space=<spacekey>%20AND%20NOT%20macro=jira

where <spacekey> would be the key that is used to refer to the space (it shows up in the URL when you are looking at a page in that space).

[Stephen Deutsch]

Actually, if I think about it, you could just search for

spacekey:<spacekey> NOT macroName:jira

and it would have the same effect :)

[paul enggruber]

Great, solves my Problem! thanks :)