How to get list of project Key and Project namefor Jira project

_Download2021 May 25, 2022

Hi

I want to know ,How to get list of project Key and Project namefor Jira project by Database Mysql

1 comment

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 26, 2022

Welcome to the Atlassian Community!

I'd strongly recommend you don't go any further down the path of reading the database, it's the worst possible way you can report on Jira.

This quuery is however simple and safe - read the project table - it's got the key and next number to use in it amongst other project data (note next number - not necessarily the number of issues in the project)

Like Jim Konopka likes this

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events