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

[vinay.mr@volvo.com]

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

[Bob Swift OSS (Bob Swift Atlassian Apps)]

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

[Thomas Schlegel]

The SQL is:

select pname, lead, description from project;

Best regards

Thomas