How to synchronize the list of JIRA projects in 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

Thomas Schlegel · Answer

The SQL is:

select pname, lead, description from project;

Best regards

Thomas

Bob Swift · Answer

Use the Confluence SQL Plugin with a simple query of the JIRA database. Specificially the project table.