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 !
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 :)
Thanks for your answer, to be honest i have no idea how to use this SQL within Jira borders.
But thanks any way !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.