Retrieve details of all custom fields in Jira Align using Enterprise Insights
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
This article describes the way to fetch all the Custom fields created in the Jira Align application via Enterprise Insights(EI), regardless of the WorkItem they are associated with.
Diagnosis
Running the below query should list down all the Custom fields in Jira Align:
1
2
3
4
SELECT TOP 1000 [Custom Field List].[Custom Field Name] AS [Custom Field Name]
FROM [current_dw].[Custom Field List] AS [Custom Field List]
GROUP BY [Custom Field List].[Custom Field Name]
ORDER BY [Custom Field Name] ASC;However, it does not list all the Custom fields that are created in Jira Align.
Cause
The view [Custom Field List] only makes available custom fields that are of the type "Multi Select", and also, only ones that are in use.
The customer fields that are not "Multi Select" type will still not show in EI output if it is not is use.
Solution
Currently, there is no workaround to fetch the list of all the Custom Fields from Jira Align via EI. However, a Suggestion is created to report the same
Was this helpful?