Hi all,
I am hoping someone can help with a JQL to return the following (that can be exported to Excel/CSV):
All JIRA Story’s and their LinkedIssues and Linked Issue Types and Summary. So for example:
Issue | Type | Summary | LinkedIssue | LinkedIssueType | LinkedIssueSummary |
JIRA-123 | Story | ‘Create a thing’ | JIRA-321 | Sub-Task | Do some stuff |
JIRA-123 | Story | ‘Create a thing’ | JIRA-456 | Sub-Task | Do some other stuff |
JIRA-123 | Story | ‘Create a thing’ | JIRA-789 | Sub-Task | Do some more stuff |
JIRA-123 | Story | ‘Create a thing’ | JIRA-741 | Task | Do some stuff with code |
JIRA-987 | Story | ‘Create another thing’ | JIRA-852 | Sub-Task | Do some stuff for money |
JIRA-987 | Story | ‘Create another thing | JIRA-999 | Task | Do some stuff |
The results would have to come from a filter like ‘Project=JIRA and Type=Story…..and then the magic’
;-)
Kind Regards
Matt Ashfield
Hello, this seems like a two-part question.
First and foremost, you can save columns to a filter. Please check out this documentation because I cannot summarize it better: JIRA: Using Filters - Defining a filter-specific column order. This means you can save a query and have it return specific data (Filter-specific columns + JQL = Data Slice).
Secondly, a function of the Export (Current Fields) in the Export menu is to only export columns that are on the issue navigator screen.
image2015-4-30 12:50:19.png
So, if you create your JQL, save it as a filter, save the columns you want, and export (current fields) you will get what you asked for.
If you're seeking a particular list of columns, to my knowledge that's not programmable as a JQL query string. You set that in the Columns drop-down. You can then use the Export drop-down to specify the export format.
Now if memory serves me, you can specify which columns to use if you set up a JIRA query in Confluence.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The JIRA macro for Confluence can set columns as well yes. :)
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.