Has anyone created a plug in that searches for unanswered QUANDA questions?

[clair clark]

I have the following SQL:

select * from QANDAQ where Q_ID not in (select Q_ID from QANDAA)

I would like to show this as a results list within Jira, I am currently writing a report plugin.

Has anyone else done this?

Any advice gratefully received

Thank you

[Timothy]

If you are writing your own add-on, just do a JDBC call then.