Enterprise Insights Table for custom field on Jira Align work item object
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 documents the tables in the Enterprise Insights database that store custom field information present on the Jira Align work items object. We will use the Epic object as an example, but a similar approach could be taken for other work items.
Solution
The Multi-Select List type custom field is on the Epic object similar to the screenshot shown below.
The below screenshot shows the custom field definition from the Details Panels Settings.
The solution below shows which tables in Enterprise Insights database hold this type of custom field information.
Most of the custom field information is stored in the master table itself. In this example, the main table/resource would be Epic.
For Custom fields, the Epic table has column names that are named something like ....Custom....
For Multi-Select List type custom field, there is column similar to [FK Custom Dropdown List x] that will give an ID
Sample query used to extract the above table results here:
select [FK Custom Dropdown List 4],* from current_dw.Epic where [Epic ID]=3349
Use the above ID to check for the custom field value in another table Custom Field List.
The specific column to use to filter the above ID in this table is : [FK Custom Field List ID]
Sample query used to extract the above table results here:
1
2
select * from current_dw.[Custom Field List]
where [FK Custom Field List ID] = 7Was this helpful?