How to synchronize the JIRA projects list with confluence ? ( JIRA confluence connectivity )

Question

We want publish the list of jira projects and its project leaders on Confluence page for informatory purpose.

please let me know how it can be done ? or any plugin available for it ?

We are using lincesed versions of JIRA 4.4 and conflunce 3.5.1.

please help..

Sergey Papurin · Answer

Hi, you should use confluence sql plugin for that purposes.

And make proper sql query to jira database.