Jira Exporter Function fullname is not displaying names for Multi-User Picker field

Michael Suder

I am using the following syntax in my exporter template file BUT no names of users are being displayed when I use the template for export:

${fullname:Approvers}

My field name is "Approvers" and this has been confirmed by inspecting the XML for the issue.

in contrast, this does work to output the display name of the issue Assignee:

${AssigneeUserDisplayName}

Marshall Walker Lee

You're encountering a common syntax difference between various Jira exporter tools. While ${AssigneeUserDisplayName} works for a system field like 'Assignee', custom fields, especially those that can hold multiple users like your "Approvers" field, often require a different approach depending on the specific exporter add-on you are using.

The syntax ${fullname:Approvers} is the correct format for the Xporter for Jira add-on. If you are using Xporter, the issue might stem from a few other possibilities:

• Field Type: Double-check that "Approvers" is indeed a "User Picker (multiple users)" or "User Picker (single user)" field.
• Data in the Field: Ensure that the "Approvers" field in the specific issues you are exporting actually has users selected. An empty field will, of course, produce no output.
• Exporter Caching: In some rare instances, caching within the exporter template can cause issues. Try making a minor edit to your template (like adding a space) and re-uploading it.

Syntax for Other Popular Exporter Add-ons

If you are not using Xporter, the syntax will be different. Here are the common syntaxes for other popular Jira exporter add-ons:

• Better Excel Exporter: This add-on often uses Groovy expressions. To get the display name of users in a custom field, you would typically iterate through the list of user objects.

  For a single user picker:

  ${issue.get("Approvers")?.displayName}
  

  For a multi-user picker, you'll need to loop through the users:

  XML

  <#list issue.get("Approvers") as user>${user.displayName}<#if user_has_next>, </#if></#list>
  

  This example iterates through the list of approvers and prints their display names, separated by a comma.

• Jira's built-in CSV export: Jira's native CSV export has limited capabilities for formatting custom fields and typically exports the username rather than the full display name for user picker fields.