Search confluence database for JIRA reference

[Маргарита]

Good afternoon. Would love to get some help on how Confluence Pages and Issues are "linked" in JIRA. In the interface of both systems, the linking occurs using a macro, but in the Confluence database I cannot find the data on the links to JIRA, please help with the question. Thank you in advance.

[Joshua Sneed Contegix]

Hi,

The jira issues macro data is stored in a couple places. The data in the macro is stored in the bodycontent table. It looks something like:

<p><ac:structured-macro ac:name="Jira"><ac:parameter ac:name="columns">key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution</ac:parameter>
<ac:parameter ac:name="server">Jira Old</ac:parameter><ac:parameter ac:name="serverId">79f0263c-a3a5-323b-870c-aea1895cabeb</ac:parameter>
<ac:parameter ac:name="key">TST-1</ac:parameter></ac:structured-macro></p>

The plugin backing the macro lives elsewhere in the database and only converts/renders the above code block into something usable. The following links may give you something to go on.

• https://confluence.atlassian.com/confkb/how-to-bulk-update-jira-issue-macro-to-point-to-a-different-jira-instance-596771463.html
• https://confluence.atlassian.com/confkb/how-to-find-all-pages-and-spaces-that-use-a-specific-macro-via-sql-747837116.html

Cheers!