How to query JIRA issues from Confluence database?

[RacoonRocket]

Hi,

I need to extract pages with reliable jira issues from Confluence database. I find tables AO_563AEE_ACTIVITY_ENTITY, AO_950DC3_TC_JIRA_REMI_EVENTS, but query returns an empty result. How can i link pages with jira issues?

Thank you!

[Moses Thomas]

@RacoonRocketYou cannot query Jira issues from  confluence database as they are completely different  databases. Jira  issues  are  not stored in confluence database.

you will  have to  find relationship between tables where this macro  is stored in the database and tables where  pages are stored and generate the list of pages from database. these tables which  you  have shown  will  not  give you  the results.

Best!

[Fabio Genovese]

@RacoonRocket

It's possible. Let me explain.

Using Confluence and an open source addon, you can query all information from Jira Database and obtain all information you need......... using this documentation for the JIra Tables...

Hope this help :)

Cheers

FABIO

PS: A short description of this addon is reported to this blog post of MrAddon :)

[RacoonRocket]

@Fabio Genovese, thank you, but i need to select jira issue from Confluence database, not from Jira database. 

[Nic Brough -Adaptavist-]

You can't.  The second half of your requirement is nonsense, as you can't select things that are not there.

The Jira issues are in the Jira database.

[Fabio Genovese]

@Nic Brough -Adaptavist- This means when Confluence show linked issue to page = exec a API from Jira to obtain information. Right?

[Nic Brough -Adaptavist-]

Yes, there's no Jira data in the Confluence database, it's pulling the data over the REST api when it needs it. 

Your add-on suggestion does the same, but via a direct database link.

[Fabio Genovese]

Yes. My solution is a workaround to obtain the information. I know where are information in Jira Database but I don't know all Confluence database tables.

Many thanks @Nic Brough -Adaptavist-