How to display a list of custom fields per work item in a Jira project?

[Stephen_Wingert]

I am looking to build a query to display all the work item types configured for a Jira project and the custom fields configured for each work item type. Any help would be greatly appreciated! 

[Mohsin Shaikh]

Hello @Stephen_Wingert

To display a list of all work item types (issue types) configured for a Jira project and the custom fields associated with each work item type in Atlassian Analytics, you can use the following approaches:

---

1. Using the "Issue custom fields" Table (Visual Mode)

• In Atlassian Analytics, open the chart builder and use the "Issue custom fields" table.

• Add the columns:

  • Issue type (from the Issue table)

  • Custom field name (from the Issue custom fields table)

  • Custom field value (optional, if you want to see values)

• Filter by your Jira project if needed.

• This will show which custom fields are present for each issue type in your project.

---

2. Using SQL Mode (Custom Table Example)

If you want a more advanced or tabular view, you can create a custom table using SQL in Atlassian Analytics:

SELECT i."Issue type", f."Name" AS "Custom field name" FROM "Jira family of products"."Issue" i JOIN "Jira family of products"."Issue field" f ON i."Issue ID" = f."Issue ID" WHERE i."Project key" = 'YOUR_PROJECT_KEY' GROUP BY i."Issue type", f."Name" ORDER BY i."Issue type", f."Name"

• Replace 'YOUR_PROJECT_KEY' with your actual project key.

• This query lists each issue type and the custom fields associated with issues of that type in the project.

---

3. Best Practices and Tips

• Custom fields are not always tied to specific issue types in the data lake; they are tied to issues. So, the query will show which custom fields are present on issues of each type, not necessarily which fields are configured for the type in Jira settings.

• If you want to see all possible custom fields for each issue type (even if not yet used), you may need to cross-reference with Jira’s field configuration schemes outside Analytics.

• For a more visual approach, use the "Issue custom fields" table in visual mode and group by "Issue type" and "Custom field name".

---

References

• Query Jira custom fields with custom columns or custom tables

---

Summary:
You can display a list of custom fields per work item (issue) type in a Jira project by joining the Issue and Issue field tables in Atlassian Analytics, either in visual mode or with a custom SQL query. This will show which custom fields are present for each issue type in your project.

I hope this information helps.

Regards,

Mohsin