Get Advanced Roadmaps Team Custom Field values for issues
Platform Notice: Data Center Only - This article only applies to Atlassian apps on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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
This article explains how to get the values of the Team custom field associated with Advanced Roadmaps.
Environment
Jira Software Data Center
Solution
You can export Advanced Roadmaps Team field values from Jira Data Center using one of the following methods:
Method 1: Retrieve Team details using the REST API
You can use the following REST API endpoint to retrieve all Advanced Roadmaps Team details:
<Jira base-url>/rest/teams-api/1.0/team
Example:
http://localhost:8080/rest/teams-api/1.0/team
This endpoint returns a list of teams, including their IDs, names, and other relevant details. Use this information to map Team IDs to names in your exported data.
Method 2: Query Team values directly from the database
If you have database access, you can run a SQL query to retrieve Team IDs and names for each issue:
SELECT ji.id AS issueid,
p.pkey AS project,
ji.issuenum,
p.pkey || '-' || ji.issuenum AS issuekey,
arteam."ID" AS teamid,
arteam."TITLE" AS teamtitle
FROM jiraissue ji
JOIN project p
ON p.id = ji.project
JOIN entity_property ep
ON ep.entity_name = 'IssueProperty'
AND ep.property_key = 'jpo-issue-properties'
AND ep.entity_id = ji.id
AND ep.json_value LIKE '%"team_id"%'
JOIN "AO_82B313_TEAM" arteam
ON arteam."ID"::varchar = ep.json_value::jsonb -> 'team_id'->>0;Note: This SQL query has been tested on a PostgreSQL database.
Was this helpful?