Will it be possible to create a report in Confluence involving Jira fields from two different projects? This would be like a cross-project report. Involves running a SQL query on Jira database.
Currently this is possible using BIRT reports in JIra. But we are looking at any option if possible to do so in Confluence.