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; } } }

Get all the fields used in particular project category from JIRA database using SQL

unknown

I have requirement I need to get list of all fields using in any screen, in any issue type for particular project category.

Instead of going to through each projects and screens, I need to have consolidate list of all the fields used in particular project category for maintenance purpose.

Any help is greatly appreciated.

Accepted answers

Niranjan

Hi @[deleted],

Here is the KB article that can help you - https://confluence.atlassian.com/jirakb/how-to-get-a-list-of-all-fields-in-a-project-967318426.html

RESTAPI call should give you the fields in the UI in json. You can use tools like excel or power PI to get the information in readable format.

http://jira.com:8080/rest/api/2/issue/createmeta?projectKeys=SPB&expand=projects.issuetypes.fields

All comments

Niranjan

Hi @[deleted],

Here is the KB article that can help you - https://confluence.atlassian.com/jirakb/how-to-get-a-list-of-all-fields-in-a-project-967318426.html

RESTAPI call should give you the fields in the UI in json. You can use tools like excel or power PI to get the information in readable format.

http://jira.com:8080/rest/api/2/issue/createmeta?projectKeys=SPB&expand=projects.issuetypes.fields

unknown

Does not exactly answer my question, I need based on project category.

Niranjan

You cannot get it directly. Usage of category field to group projects with unrelated schemas is ineffective, especially if your teams needs category specific data.

You would need to tweak the DB query1 in the KB article.

Step 1 - Get the list of IssueTypeScreenSchema for all Projects (Modify the query to get it for projects that belong to category. You may need another join clause)

The remaining steps would be the same as given in KB article, once you identify the project to a particular category.

unknown

Problem is with the third query, does not fit with query 2

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