List of Teams and their IDs

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

1 answer

1 vote

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

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.