Exporting all issue types used fields and each project

Question

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 !

Dick · Answer

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

Eran Roiter_tdmgcu · Answer

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

But thanks any way !

Dick · Answer

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 :)