how to add the custom fields to default fields

[Someshwaran]

how to add the custom fields to default fields on jira service management so that it can be available on excel when export

[Joseph Chung Yin]

@Someshwaran -

When you export your search result via JQL, you can add your custom field(s) in the UI via "Configure columns" icon.  Once added, then you can export the result to Excel.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

[Someshwaran]

Hi Joseph,

Thanks for your reply. I couldn't see the icon that you highlighted on my end. I am attaching a screenshot for your reference. Could you please let me know if I am looking on the wrong page or something?

[Someshwaran]

I only want these fields to be exported

[Paul Pasler]

@Someshwaran looks like there are two different Issue Navigator in use (depending on the creation date of the instance).

Can you see this on your site?

Or this?

[Paul Pasler]

Oh, maybe you have too much search results (if I see it correctly, you have 1000+ results).

https://community.atlassian.com/t5/Jira-Software-questions/Jira-s-export-limit-is-set-to-1000-rows-Is-there-a-way-to/qaq-p/2246311

[Someshwaran]

Hi @Paul Pasler 

Thank you for your reply. I could not see the icon as well as the column option from my end.

[Paul Pasler]

@Someshwaran have you seen my comment about the 1000 results limit for export?

[Someshwaran]

Hi @Paul Pasler ,

Yes I did, Came to know there is a limitation.

But please check the recent screenshot. It has only 2 issues to export.

[Fabio Racobaldo _Herzum_]

Hi @Someshwaran ,

default fields are fields provided by JIRA natively and you can't add a custom field to that list. As said by @Joseph Chung Yin , you can define which fields extract from JQL.

Fabio

[Someshwaran]

Hi Fabio,

Thank you for your reply. I couldn't see the icon that was highlighted by @Joseph Chung Yin on my end. I am attaching a screenshot for your reference. Could you please let me know if I am looking at the wrong page or something?

I tried using JQL. After this, when I am trying to export the report, I only have the following export options available. If I select "EXPORT CSV (Default)," it picks up the default value. If I select "all fields," it includes every field, which is not really required.

I want only few fields to exported in excel csv.