I am trying to retrieve issues in a portfolio plan from JIRA database for reporting purposes and this is similar to JQL function issuekey in issuesInPlan(""). I was able to retrieve plan details from AO_D9132D_PLAN table and I am trying to figure out where the issues for a portfolio are stored in JIRA databse.
I have tried querying AO_D9132D_ASSIGNMENT_EXT table but that has inaccurate data or some relational mapping behind the scenes - I was not able to fetch all the issues in a plan. This query will help me to generate the report automatically without me intervening to run JQL and download as an excel and upload to a reporting tool. Any help is much appreciated.
Note : RestAPI is a pain with my current reporting platform so I don't want to get results using it.
Hello Phani!! could you solve the problem? how did you solve it? I have the same problem
Admin, Plugin Data Storage for JPO 2.26 shows three possible tables:
As to where the issues in particular plan are stored, I see
which is likely the Plan but then Issue Sources could be in
Once you have the issue sources (perhaps AO_D9132D_ISSUE_SOURCE)
I suspect that is first a call to Jira to retrieve the issues in that filter, board or project. I'd plan with a simple plan and some SQL queries
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you @Matt Doar I was able to fetch portfolio plan details from AO_D9132D_PLAN table and I am using JPO 3.x version. I am unable to figure out source tables of portfolio issues - to be more specific I want to find out where in plugin Data storage table we have JIRA issue id's that are part of a given portfolio plan. The current assignment table AO_D9132D_ASSIGNMENT_EXT is inaccurate.
The issue source table - AO_D9132D_ISSUE_SOURCE has information about filters and boards or projects that are used as sources in portfolio and if there is no related table for fetching issue id's for a portfolio - I assume that portfolio plugin is rendering issues using issue sources by computing them on the fly.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.