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!
@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!
@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
@Fabio Genovese, thank you, but i need to select jira issue from Confluence database, not from Jira database.
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.
@Nic Brough -Adaptavist- This means when Confluence show linked issue to page = exec a API from Jira to obtain information. Right?
It looks like you're new here. Sign in or register to get started.
