nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

List of Teams and their IDs

Raj_0ch8lz

Hello All,

We are using Jira data center version 8.20.6 and looking for an API to get list of all Advance Roadmap teams and their respective IDs.

If there is no API, how to get the same from SQL database? Appreciate your help.

Thanks,

Raj

Accepted answers

Aditya Verma

Hi @Raj

REST APIs are currently not available for Advanced Roadmaps. There is a feature request here.

You can get this data from the Database, please use below SQL query.

select * from "AO_82B313_TEAM"

Thanks,
Aditya

All comments

Aditya Verma

Hi @Raj

REST APIs are currently not available for Advanced Roadmaps. There is a feature request here.

You can get this data from the Database, please use below SQL query.

select * from "AO_82B313_TEAM"

Thanks,
Aditya

Raj_0ch8lz

Thanks @Aditya Verma . Is this table shows all existing ones or even deleted teams as well?

Aditya Verma

Hi @Raj ,

I was not able to verify it from DB but my educated guess is that it should only give you a list of current Teams and not deleted ones.

Thanks,
Aditya

Raj_0ch8lz

Thanks @Aditya Verma

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server

advanced-roadmaps