How to find the pages which has Jira links present in it for a specific space.

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Summary

This KB will help us to find the pages which have Jira links present in them for a specific space in Confluence.

Solution

The database query shared below will help us fetch the results

PostgresSQL
Select c.* from BODYCONTENT b, CONTENT c
WHERE 
c.contentid=b.contentid and 
c.spaceid='<spaceid>' and
b.body LIKE '%<JIRA_URL>%';




Last modified on May 17, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.