I'm trying to write a plugin in which I want to create a report of issues with a big select statment with lot of joins with the jira(jiraissue, changehistory etc) tables.
Could you please let me know how to achieve this?
Thanks a million,
The simple answer is: you cannot.
Active Objects tables spaces are separated from the JIRA table space and you cannot query JIRA's table using AO at all, nor have references (fk etc.) from AO tables to JIRA tables.
This is by design.
I think at least I can write JDBC code in my plugin to access JIRA's tables right?
Because of the frustration on jira partial word search problem, we are trying to write a plugin to achieve our goals. The following are the related issues:
Please suggest me if there are any alternatives.
It's officially Tuesday, which means it's officially time for another tip to help you better navigate this space we call the Atlassian Community. 😄 I got a great question from community member, Sa...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs