Jira Portfolio - How to get the jira portfolio plan assignment of a specific issue?

Question

Dear all,

I'm looking for a way get the Jira Portfolio Plan Name or Plan Id of an issue

E.g. inmagine an Epic which is assigned to/which is Part of  a Jira Portfolio Plan with Plan Name "Plan ABC" and  Plan id "123".

So how could I get that information (give me the Plan Name or Id of that Epic (and null if it's not assigned to any plan)) either as a scriptrunner jql function or programmatically via the scriptrunner groovy script console.

I know there exists this jql function "issuekey in issuesInPlan(123)" so I could do something like "issuekey in issuesInPlan(123) and issuetype = Epic" and than check wether the Epic-Key is in that resultlist, but I need a more direct approach at a lower cost.

Thank you in advance,

Best regards,

Tim

Walter Buggenhout · Answer

Hi @timmurko

I'm unsure as to what you want to achieve, but it sounds like reporting. Have you considered pulling the data from your plan(s) into a reporting tool like EazyBI (based on the filters you use as input to your plan) and aggregating your worklogs there?

timmurko · Answer

Hi @Walter Buggenhout

thanks a lot for your fast reply. What a pitty.

I'm trying to build a time evaluation tool, which aggregates the the jira time bookings (worklogs) to the different Jira Portfolio Plans, so such a feature would have been handy.

Walter Buggenhout · Answer

Hi @timmurko ,

Thanks for reaching out. But I am afraid that what you are trying to achieve is not really possible.

A Portfolio plan retrieves its data through different dynamic data sources: an agile board, a saved filter or a Jira project. The issues belonging to a plan can be retrieved through those sources, but the ID of or reference to a plan is not persisted against the individual issues. And so you cannot go the other way around.