Exporting all issue types used fields and each project

Eran Roiter
Contributor
October 21, 2024

Is there a way to export all the used fields in each issue type by project?

I want to compare the diffrent projects, and try to set a line.

We can find them at the Issue Layout pages, but i don't see any why to export them.

Any idea ?

Thanks ! 

1 answer

0 votes
Dick
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 21, 2024

Hi @Eran Roiter,

I'm not sure if this can work for you because you are using Jira Cloud (I'm on DataCenter).

use JIRADB -- your Jira databasename
SELECT ji.ISSUENUM , ji.ASSIGNEE, concat(concat('"', ji.SUMMARY),'"') AS "Summary" , it.PNAME AS "IssueType", st.PNAME AS "Status", ji.RESOLUTIONDATE
FROM JIRAISSUE ji
LEFT JOIN ISSUETYPE it
ON ji.ISSUETYPE = it.ID
LEFT JOIN ISSUESTATUS st
ON ji.ISSUESTATUS = st.ID
WHERE ji.PROJECT = 10000 -- fill in number
-- ORDER BY ISSUENUM DESC
ORDER BY ISSUETYPE ASC

Hope this SQL statement is a good start for you

Dick

By voting for helpful posts and marking answers to your question, you're helping people with similar questions find a solution more quickly. Sharing is caring applies to knowledge as well :)

Eran Roiter
Contributor
October 21, 2024

Thanks for your answer, to be honest i have no idea how to use this SQL within Jira borders.

But thanks any way ! 

Dick
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 21, 2024

This is by using Microsoft SQL Server Management Studio, but could be used in any database program (ie. DBeaver ). The trick is to connect to the database in the cloud. 

Hope someone can help here, getting you connected

Dick

 

Like Eran Roiter likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events