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

Can we export specific issue columns?

Avrohom Yisroel Silver

If I go to Issues, I can apply filters, then click "Export issues" and choose the file format...

Screenshot 2024-02-14 212328.png

That's fine if I want to export all columns, but I generally don't. I usually want to do this when I need to supply a list of outstanding issues to the stakeholders, and all I want in the list are the issue Id, summary, parent and fix version.

Is it possible to restrict the columns exported? At the moment, I'm wasting a lot of time chopping columns out of the exported file.

Thanks

Accepted answers

Bill Sheboy

Hi @Avrohom Yisroel Silver

If you save your filter with a name, that allows also saving the selected fields, field order, and sort order results. When you export, you may then choose to only export the filter fields.

https://support.atlassian.com/jira-software-cloud/docs/save-your-search-as-a-filter/

Kind regards,
Bill

All comments

Bill Sheboy

Hi @Avrohom Yisroel Silver

If you save your filter with a name, that allows also saving the selected fields, field order, and sort order results. When you export, you may then choose to only export the filter fields.

https://support.atlassian.com/jira-software-cloud/docs/save-your-search-as-a-filter/

Kind regards,
Bill

Kai Becker

Hi @Avrohom Yisroel Silver

thanks for your question. What Jira view do you use to export these issues?

If you go to Filters > View all issues and enter you search query there, you should be able to modify the columns under "my defaults" which is accessible in the export menu:

Screenshot 2024-02-14 at 23.35.40.png

Avrohom Yisroel Silver

@Kai Becker Thanks for the reply, but I'm not clear what you mean. If i go to Filters > View all issues, I get to the same place as if I click the Issues link in the left column. That's where I was when I took the screenshot.

Please can you clarify what you meant by "enter you search query there" as I'm not sure what you mean. I can use the controls to filter the results, but this only limits which issues are shown, it doesn't affect the columns.

Thanks again.

Avrohom Yisroel Silver

@Bill Sheboy Thanks for the reply. How do I select fields? As far as I can see, filters only allow you to choose which issues are included in the results.

Thanks again.

Kai Becker

@Avrohom Yisroel Silver I can confirm, that on my cloud site they are different. When using your way via the issues button you will get the new search experience:

Screenshot 2024-02-15 at 00.22.22.png

When using my option I do get the old search experience with different entries in the export dropdown which you can see on my first post:

Screenshot 2024-02-15 at 00.24.12.png

Bill Sheboy

On the right side of the page, there is a Columns dropdown list to add / remove fields.

As you are a system admin, it will initially show "My Defaults" and "System". (Be careful not to change the System ones unless you mean to do so :^)

Use "My Defaults" to initially select the fields. After you save your filter with a name, you will then see "Filter" as an option to change the columns.

Avrohom Yisroel Silver

@Bill Sheboy I can't see a Columns dropdown, am I looking in the wrong place? I clicked Filters -> View all issues and see the following...

Screenshot 2024-02-14 232942.png

Where is the Columns dropdown?

Thanks

Avrohom Yisroel Silver

@Kai Becker Whichever search experience you get, doesn't that only allow you to filter? I've not delved into JQL yet, but as far as I can see, it doesn't support column choosing.

Could be I've not found the docs for that yet, but all I saw was filtering.

Please could you clarify. Thanks again

Sathish Kumar Golla

Hi @Avrohom Yisroel Silver

Yes you can export the required coloumns choose columsn from the System and export as required

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud