Group-related fields in the "Issue field" table now show group IDs instead of names

[#1]

Hi community,

The “Group picker (single group)” and “Group picker (multiple groups)” fields from the Jira “Issue field” table now stores group IDs, instead of names. This change applies to both Atlassian Data Lake connections in Atlassian Analytics and data shares.

To report on group names, please join the Jira “Issue field” table with the “Group” table using “Group ID”. For Atlassian Analytics, “Group” table is under “Organization data”. For data shares, this table will be added soon.

What do I need to do?

If you have chart queries including “Group picker (single group)” or “Group picker (multiple groups)” fields, you will need to update those queries. You’ll need to join the values of these fields to the “Group ID” column in the “Group” table under “Organization data” to be able to get the group names.

Visual SQL example:

SQL code example:

SELECT field.field_id, 
       field.field_key, 
       field.name, 
       group.name, 
       field.issue_id 
FROM jira_issue_field AS field 
JOIN atlassian_group AS group 
       ON group.group_id = field.value 
WHERE field.field_type = 'com.atlassian.jira.plugin.system.customfieldtypes:multigrouppicker'
;

What’s coming?

For Atlassian Analytics users, we are working on a mapping table between the Jira “Issue” and “Group” tables to simplify your queries and allow you to use a single visual mode query in VisualSQL. It explodes the group IDs from the “Group picker (single group) and “Group picker (multiple groups)” fields and provides a ready-to-use mapping between issue IDs and group IDs.

For data share users, we are working on adding the “Group” table to your data shares.

We are aiming to make both of the above tables available by the end of August.

If you need any help adjusting your queries, please contact support. Thank you for your patience and collaboration in this process.