Get the usage of portfolio plugin in projects
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Need to get the usage of portfolio plugin in projects.
Environment
3.24.0 and later
Solution
Users would like to check the projects used for "portfolio for jira":*. This information can be populated from the database.
Users can use below mentioned query to get information about projects with respect to portfolio for jira.
Note: Below query is tested in MySQL database.
select PLAN_ID,pname from AO_D9132D_ISSUE_SOURCE t
INNER JOIN project p on t.source_value = p.id where source_type="Project"
Last modified on Feb 10, 2022
Powered by Confluence and Scroll Viewport.